wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes Oracle  Connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle  Connectivity" Watch "Oracle  Connectivity" New topic

Oracle Connectivity

Swaminathan Ramanathan

Joined: Sep 23, 2000
Posts: 8
Hello Anybody !
I'm having Personal Oracle 8.0.3 loaded in my system. My Operating System is Windows '98. Now can't i connect Java and Oracle through JDBC ? I'm asking you this because when i open my Oracle Net8 Assistant i find no folders for my Listeners and so i'm unable to configure the Listeners which are vital for connecting Java and Oracle. But I've Listener.ora file located in my system. Now i want to know how should i connect to Oracle thro' JDBC. Or is it not possible unless i shift to Windows NT ?
Please help me as i feel very sick with this issue for a long time.
Thanks and Regards,
[This message has been edited by Swaminathan Ramanathan (edited January 23, 2001).]
Heath Lilley
Ranch Hand

Joined: Jan 09, 2001
Posts: 72
Well if your question is "how do you connect" you might want to look into using the Oracle native drivers. They are in a zip, classes111.zip or classes102.zip. You need to add them to your classpath and import them into any code you are writing(import oracle.sql.*;". The oracle documentation has a good explaination. Or at least our version does. Hope this helps.
[This message has been edited by Heath Lilley (edited January 23, 2001).]
Kevin Mukhar
Ranch Hand

Joined: Nov 28, 2000
Posts: 83
Yes, it is possible to use Java and JDBC with personal Oracle. There should be a way to create a new listener through Net8 Assistant. It's been a while since I had to do it, and I'm unable to detail the exact steps. In any case, you can find precise information from Oracle.
- Go to http://technet.oracle.com.
- Select the documentation link in the left margin
- Select the Oracle 8i link
- Select the General Documentation Release 2 link
- Select the Oracle8i Server Networking and Security link
- Select the Net8 Administrator's Guide link
- Look in chapter 7 for information
You should use the same versions of java and jdbc. For JDK1.1, uses classes111.zip. If you are using Java 2 (1.2 or 1.3) use classes12.zip available from Oracle.
You do not need to 'import oracle.sql.*." Unless you are using Oracle specific extensions or JDBC 2.0 optional packages, your code only needs to 'import java.sql.*."
Wrox Press just published a book on Oracle 8i Application Programming. Download the code for chapters 5 - 16 and then look at the examples for chapter 12. These classes in particular may help:
TestJdbc.java (check your installation)
ForNameLoader.java (how load driver and get connection)
ConnectionTest.java (various connection methods)
SimpleStatement.java (creates tables using jdbc)
I agree. Here's the link: http://aspose.com/file-tools
subject: Oracle Connectivity
It's not a secret anymore!