• 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
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

JDBC driver with WLS6.1sp3 and Oracle9

 
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What jdbc driver should be used?
classes12.zip from Oracle or oci from BEA?
What are the pros and cons for each?
Thanks.
 
Ranch Hand
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We have found less problems with the JDriver when XA transactions, but your mileage might vary. Oracle's drivers are very good and they also offer an OCI driver. If performance is your main concern than use JDriver or the OCI version of Oracle's driver. If ease of configuration is the main issue then use Oracle's thin driver.
If you need to access special Oracle features such as Oracle Spatial data then you will need to use Oracle's drivers.
Finally, if you are writing plain JDBC, not messing with driver-specific code. it will be easy to test your application with both drivers and choose the one that works best.
 
It's just like a fortune cookie, but instead of a cookie, it's pie. And we'll call it ... tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic