topic Re: web connection to openvms in Operating System - OpenVMS

web connection to openvms

nycdata — Thu, 23 Sep 2004 22:46:11 GMT

Hey!

Guys, I am new to this forum. It looked greatly helpful so I thought maybe any one of you might have some information on this.

I am developing an application to connect a jsp page to a RDB database which is running on OPENVMS VAX (not ALPHA) platform. It seems like there are JDBC drivers to connect to RDB for ALPHA platform.

I have been really unsuccessful to find a way to connect the jsp page to the oracle RDB database running on VAX.

Any help or guidance will be greatly appreciated!!

Re: web connection to openvms

Karl Rohwedder — Fri, 24 Sep 2004 00:14:45 GMT

The JDBC kit from Oracle only runs on Alpha.
May be the Attunity Connect product may help you, see http://www.attunity.com/products/OpenVMS.Asp

Re: web connection to openvms

Martin Vorlaender — Fri, 24 Sep 2004 02:54:51 GMT

To clarify Karl's response:

Java and everything related to it are Alpha-only, as the VAX lacks the required IEEE floating point arithmetic, and an emulation has proven to be too slow.

That said, and admitting I've no real insight to Java and JSP, is it really necessary to have an RDB server-side Java component to this? Don't all these cleint components connect to the RDB network server?

HTH,
Martin

Re: web connection to openvms

Ian Miller. — Fri, 24 Sep 2004 05:41:06 GMT

you could use the JBDC drivers on another platform to connect to RDB via SQL/Services on your VAX.

Re: web connection to openvms

nycdata — Fri, 24 Sep 2004 11:31:13 GMT

"you could use the JBDC drivers on another platform to connect to RDB via SQL/Services on your VAX."

Ian,

Buddy...can you guide me little bit towards that direction??

Please!

Re: web connection to openvms

Ian Miller. — Fri, 24 Sep 2004 11:47:06 GMT

On the platform running your web server (OpenVMS Alpha or another platform) you could have the JDBC drivers loaded. These allow java code to open an ODBC connection to a database which is on another systdem (in your case a VAX). SQL/Services is an addon to RDB which supports incoming ODBC connections. The detail I know not as my VMS software development experiance is of a more traditional nature (C, MACRO-32 etc) :-)

Re: web connection to openvms

Willem Grooters — Fri, 24 Sep 2004 12:14:39 GMT

ODBC driver for Windows can be downloaded (after registration, probably) from
http://www.oracle.com/technology/products/rdb/htdocs/rdb_odbc/index.html

It might be possible - depending on the platform - to use the JDBC connection (Unix. Windows). What you need is the RDB-specific one. To be downloaded from http://www.oracle.com/technology/products/rdb/htdocs/rdb_jdbc/index.html

In all cases you'll need SQLServices running on the VAX. this uses a TCP connection to have the outside world connect to the database (the same way as Oracle-Oracle does, but on a different port)

Willem

Re: web connection to openvms

nycdata — Fri, 24 Sep 2004 20:36:55 GMT

GREAT!!! THANKS SO MUCH GUYS!!! THANKS SO MUCH!! THIS SEEMS TO BE GOOD INFORMATION!! I AM GOING TO DEFINITELY GIVE THIS A SHOT AND SEE WHAT HAPPENS...IF IT WORKS..AS I SAID..I WILL POST IT EVERYWHERE ON THE WEB SO NOBODY WILL EVER HAVE ANY PROBLEMS IN FUTURE..THANKS ALOT !!

Re: web connection to openvms

Chris Barratt — Mon, 27 Sep 2004 01:06:00 GMT

The native Rdb JDBC thin driver which can be used from all Java platforms requires that the supplied server program be running on the database node. Since this program is written in Java, this cannot presumably be run on the Vax.
The native Rdb thick driver requires I believe only runs on VMS, and requires Rdb be installed on the node.
The native JDBC drivers therefore do not use SQL Services.
I believe you can use the ORacle Oracle JDBC drivers against SQL*NET via SQL Services, but I have not tried this. There should be some info on this on Oracle Metalink.

There is a later version of JDBC drivers than the ones that I have played with, which uses SQL Services to manage starting the servers - however, I am not sure if the server processes themselves still require Java.

Re: web connection to openvms

nycdata — Mon, 27 Sep 2004 02:57:50 GMT

I'm going to try that..thanks a lot buddy..

tomorrow is the day!!

:)