File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Type 1 - Type 4 driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Type 1 - Type 4 driver" Watch "Type 1 - Type 4 driver" New topic

Type 1 - Type 4 driver

aakash bhatt
Ranch Hand

Joined: Jan 09, 2003
Posts: 182
In my application my backend databse is Oracle 8 and webserver is Tomcat
So if use Type 1 Driver JDBC ODBC then should I had to install Oracle 8 client in my Tomcat machine
or if i use Type 4 Pure Java driver then to should I had to install Oracle 8 client.
rajesh godbole
Ranch Hand

Joined: Jan 10, 2003
Posts: 31
Hi Aakash,
I will try to explain what can be done at your end..
Type 1 JDBC drivers use ODBC to get connected to the database. Since it uses ODBC driver your installation has to be on Microsoft platform. If tomcat is installed on win2k machine then just create a DSN pointing to the Database server and that will take care of all things. But this approach is used only in the development scenario.
If the installation is on non-Microsoft platform then you will need to use Type 3 or Type 4 JDBC driver. Type 4 drivers are native net drives and use direct connection to the database.
So while connecting to database use net driver and in the database url, mention the database name and port. I am not very much confident about driver 3 but I think that, the application server takes care of getting connected to database.
Hope this helps.
Sudharsan Govindarajan
Ranch Hand

Joined: Jul 03, 2002
Posts: 319
In both the cases, you need not install Oracle 8 Client in your tomcat machine. Using a Type 4 driver would be a better approach though.
I agree. Here's the link:
subject: Type 1 - Type 4 driver
It's not a secret anymore!