aspose file tools*
The moose likes JDBC and the fly likes Oracle type 4 or type 2 driver? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle type 4 or type 2 driver?" Watch "Oracle type 4 or type 2 driver?" New topic
Author

Oracle type 4 or type 2 driver?

Ravi Patel
Greenhorn

Joined: Oct 01, 2004
Posts: 7
Whhats the difference between an Oracle Type 4XA driver and an Oracle Type 2 driver?
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

The oracle type-2 driver requires the Oracle Client to be installed on the client machine. The java application talks to the oracle driver, the driver talks to the oracle client, the oracle client talks to the database.

The type 4 driver is a pure java solution. The application talks to the driver, the driver talks to the database. It is also the 'preferred' solution since it is all java. You can wrap up the whole thing and give it to someone and say "here's a java database application", where as an application using the type 2 driver would also require them to install the oracle client too.

Does this answer your question?
Dave
Ravi Patel
Greenhorn

Joined: Oct 01, 2004
Posts: 7
Yes, thanks!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle type 4 or type 2 driver?