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)