• 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 ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Oracle Drivers

 
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is the difference between the Oracle Thin and OCI drivers?
On the Oracle site, there is only the JDBC drivers for JDK1.1.1 for Oracle8. Is this the latest?
 
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
They have the JDBC drivers for Oracle 8.1.7 for JDK 1.2.x
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've been trying to get it to work for the past many days now and nothing seems to be working.
How can I work with Oracle Server 8.05 and JDK1.3? I mean, how do I configure Oracle to work with JDK1.3 instead of the JRE it came with (v1.1.1)? What drivers should I use with JDK1.3?
I always get a make_c_state error running the sample application.
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
1. JRE - uninstall the old one, install the new jre.
2. decide on whether you want the thin or OCI drivers (thin recommended in most cases) - http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_59_
3. download the drivers for Oracle version 8.1.7(because the drivers are backward compatible to 8.0.x) for the jdk 1.2.x for Windows(assuming your running your clients from windows - http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/winsoft.html )
This link should help you the rest of the way (client configuration to trouble shooting) http://www.javaranch.com/ubb/Forum55/HTML/000010.html
hope this helps,
if you can post the error number(ORA-XXXXX) of your SQLExceptions it is sometimes easier to investigate the problem(if you are using the oracle drivers)
Jamie

3.
[This message has been edited by Jamie Robertson (edited December 14, 2001).]
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot. I tried downloading the 8.1.7 drivers but it looks for a DLL that I assume is specific to 8.1.7, so I guess it's not really backwards compatible with 8.05.
The thin driver is working. The OCI driver doesn't. I'm using it for a servlet/jsp 3-tier architecture. I guess using the thin driver would be recommended, right?
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I believe that the OCI driver(v.8.1.7) is compatible, but you are missing the DLL for the driver to work, or it can't find the DLL. This is a very common (and annoying!) error that can be frustrating to get right. It took me a couple of days to get mine working...This is one of the advantages of the thin drivers
If you want to trouble shoot this problem, you can start here: http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_39_ (assuming it is the "Unsatisfied link error with OCI driver"
but I would stick with the thin drivers anyway.
Jamie
[This message has been edited by Jamie Robertson (edited December 15, 2001).]
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks, yeah, I won't trouble myself anymore and I'll just use the thin drivers.
I don't think there's an advantage to using the OCI drivers, are there?
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic