Win a copy of The Java Performance Companion this week in the Performance forum!
  • 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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic