• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
  • Piet Souris
  • Himai Minh

Oracle Connectivity

Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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,
[This message has been edited by Swaminathan Ramanathan (edited January 23, 2001).]
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).]
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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)
You didn't tell me he was so big. Unlike this tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
    Bookmark Topic Watch Topic
  • New Topic