Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

web connection to openvms

 
SOLVED
Go to solution
nycdata
Occasional Visitor

web connection to openvms

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!!
9 REPLIES
Karl Rohwedder
Honored Contributor
Solution

Re: web connection to openvms

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
Martin Vorlaender
Honored Contributor

Re: web connection to openvms

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
Ian Miller.
Honored Contributor

Re: web connection to openvms

you could use the JBDC drivers on another platform to connect to RDB via SQL/Services on your VAX.
____________________
Purely Personal Opinion
nycdata
Occasional Visitor

Re: web connection to openvms


"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!
Ian Miller.
Honored Contributor

Re: web connection to openvms

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) :-)
____________________
Purely Personal Opinion
Willem Grooters
Honored Contributor

Re: web connection to openvms

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
Willem Grooters
OpenVMS Developer & System Manager
nycdata
Occasional Visitor

Re: web connection to openvms


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 !!
Chris Barratt
Frequent Advisor

Re: web connection to openvms

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.
nycdata
Occasional Visitor

Re: web connection to openvms

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

tomorrow is the day!!

:)