This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC drivers

 
Deepika Wadhwa
Ranch Hand
Posts: 57
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
what is the type 4 JDBC driver?
I checked thru so many sites and books... but didn't get complete details...
if anybody of u have used it please give me response asap.
thanx in advance,
Deepika
 
Deepika Wadhwa
Ranch Hand
Posts: 57
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey !!!
No body is there to give me detailed description of JDBC Type 4 Driver ....
plz don't ignore this post.

Deepika
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
 
Deepika Wadhwa
Ranch Hand
Posts: 57
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanx Thomas for ur response ,
But I think u didn't get my point. We are using oracle database for our application to make connection, we are using type 4 driver while for Oracle type 2 and type 4 both drivers are available.
so what are the benefits of using type for drivers ?

 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you read the info at the site:
Driver categories 3 and 4 are the preferred way to access databases using the JDBC API. Driver categories 1 and 2 are interim solutions where direct pure Java drivers are not yet available.
In the case of type 2 drivers, they are undesirable because they are not a pure Java solution and require special native drivers to be installed on the client.
 
rani bedi
Ranch Hand
Posts: 358
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JDBC driver type 2 (the native-API/partly Java driver)converts JDBC calls into database-specific calls for databases such as SQL Server, Informix, Oracle, or Sybase. The type 2 driver communicates directly with the database server; therefore it requires that some binary code be present on the client machine.
The vendor database library needs to be loaded on each client machine. Consequently, type 2 drivers cannot be used for the Internet. Type 2 drivers show lower performance than type 4 drivers.
The JDBC driver type 4 (native-protocol/all-Java driver) converts JDBC calls into the vendor-specific database management system (DBMS) protocol so that client applications can communicate directly with the database server. Level 4 drivers are completely implemented in Java to achieve platform independence.Since type 4 JDBC drivers don't have to translate database requests to ODBC or a native connectivity interface or to pass the request on to another server, performance is typically quite good. Also, there's no need to install special software on the client or server.
But With type 4 drivers, the user needs a different driver for each database.
 
Deepika Wadhwa
Ranch Hand
Posts: 57
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanx Thomas & Parmeet Bedi,
now its clear to me.
thanx a lot,
Deepika
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic