Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Connectivity

 
Swaminathan Ramanathan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
Swamy
[This message has been edited by Swaminathan Ramanathan (edited January 23, 2001).]
 
Heath Lilley
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 83
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic