This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi all, I have a requirement to connect to Oracle RDB from Java. The Oracle RDB is hosted on a VAX Server. The queries I have are - 1. Is classes12.zip used for Oracle 9i sufficient for accessing RDB? 2. Is there a jar file available taht can be used the same way as regular Oracle Thin Drivers? 3. Is there a specific way to approach this connectivity? 4. Any info on this is appreciated
Looking forward for ANY replies whatsoever,
-------------<br />There are wheels within wheels...<br />P.G Wodehouse
I have a requirement to connect to Oracle RDB from Java. The Oracle RDB is hosted on a VAX Server. The queries I have are - 1. Is classes12.zip used for Oracle 9i sufficient for accessing RDB?
Yes it is sufficient, you can also use ojdbc14.jar
2. Is there a jar file available taht can be used the same way as regular Oracle Thin Drivers?
Already answered above,
3. Is there a specific way to approach this connectivity?
For better performance, connection pooling etc..establish your connection via data source
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Joined: Apr 01, 2005
Shaliesh, Thanks! I also should have mentioned that my machine is a windows 2000 and the VAX machine is a seperate one. Do I also need to have a RDB Client installed on my machine? Also have you used the RDB anytime? Is the method of getting a connection similar to what we do for regular database accesses!?
Seems I missed your question, and I answered you question for connecting with 'Oracle DB' instead of 'Oracle RDB'. Please accept my apologies..........I am not sure if ojdbc14.jar or any other jar will do the task for you
Here is answer of your initial question
There are two flavors of Oracle JDBC for Rdb Drivers
First Type Oracle JDBC for Rdb Native Driver
The Oracle JDBC for Rdb Native Driver that connects directly to Rdb SQL via a native API. This driver requires an Rdb client installation, and therefore is Rdb-specific and not suitable for applets. The Native driver, written in a combination of Java and C, converts JDBC invocations to calls to SQLMOD modules, using native methods to call C-entry points.
The Oracle JDBC for Rdb Driver uses the Rdb libraries on the client machine on which it is installed.
Second TypeOracle JDBC for Rdb Thin Driver
The Oracle JDBC for Rdb Thin Driver which is a 100% pure JAVA driver that communicates directly to the Oracle JDBC for Rdb Thin servers via JAVA Sockets over TCP/IP.
The Oracle JDBC for Rdb servers are the server-side components that service JDBC requests issued by applications using the Oracle JDBC for Rdb Thin driver. The Oracle JDBC for Rdb Thin Driver requires no additional Oracle software to be installed on the client side. For applets it can be downloaded into a browser along with the Java applet being run. The Oracle JDBC for Rdb servers require Rdb and JAVA to be installed on the server side.
You can download these drivers from Oracle's website.I haven't used RDB drivers ever.