• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Drivers

 
raj joe
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • 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.
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
  • 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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15627
46
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • 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
Saloon Keeper
Posts: 15627
46
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • 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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic