• Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle type 4 or type 2 driver?

 
Ravi Patel
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Whhats the difference between an Oracle Type 4XA driver and an Oracle Type 2 driver?
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, thanks!
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!