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

Drivers

 
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am developing a internet application using java and oracle.What JDBC driver is recommanded for developement and what is recommanded for Production.
Can you pls mention why you recommand them.
 
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by raj joe:
I am developing a internet application using java and oracle.What JDBC driver is recommanded for developement and what is recommanded for Production.
Can you pls mention why you recommand them.



I have no specific Oracle advice but I do have a very important recommendation. Use the SAME driver in development that you will in production. Always. Otherwise you risk being caught out by a bug or behaviour difference between your production and development servers.

Actually this applies to your whole set up. As closely as possible your development environment should be the same as your production environment.
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Raj,
Unless you have a reason to do otherwise, you can use the standard driver that comes with Oracle - classes12.zip. And I agree you should use the same driver in development and production.
 
raj joe
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Maximilian Stocker:


I have no specific Oracle advice but I do have a very important recommendation. Use the SAME driver in development that you will in production. Always. Otherwise you risk being caught out by a bug or behaviour difference between your production and development servers.

Actually this applies to your whole set up. As closely as possible your development environment should be the same as your production environment.



Thanks for response.
What are the key factors in deciding to go for type 3 or type 4 driver
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Jeanne Boyarsky:
Raj,
Unless you have a reason to do otherwise, you can use the standard driver that comes with Oracle - classes12.zip. And I agree you should use the same driver in development and production.


Newer versions of Oracle come with ojdbc14.jar. Use that instead of classes12.zip.

There's also an ojdbc14_g.jar which is the same, but contains debug info.

Ofcourse you should visit Oracle's website for the latest info on Oracle JDBC drivers.
 
Jesper de Jong
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by raj joe:
What are the key factors in deciding to go for type 3 or type 4 driver



Look here for a description of the different types of drivers: Types of JDBC technology drivers

Just use ojdbc14.jar, and make sure you use the thin driver (i.e. the database URL must start with "jdbc racle:thin:"). If you use the thin driver, you don't need the Oracle client software on the computer you're running your software on (the thin driver knows how to talk to Oracle directly). This driver is a type 4 driver.

More info on Oracle JDBC drivers
Download page for Oracle JDBC drivers
Oracle JDBC Frequently Asked Questions
Oracle/Java FAQ

(and you can find many more with Google).
[ November 29, 2005: Message edited by: Jesper de Jong ]
 
reply
    Bookmark Topic Watch Topic
  • New Topic