• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Drivers

 
Vrushali Gore
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For Type1 & Type 2 drivers we say that we need to install libraries on Client side and even we say that the request processing takes on to the client side. How this happens? How can I explore my concept of my drivers? Why do all the processing takes place on to the client side wherein we say that in case of type 3 & type 4 drivers all the processings takes place on server side. How this happens actually
 
anagha patankar
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Type 1 is a JDBC ODBC driver
as a result it needs the ODBC code ( native = binary ) on the client

here client = machine that hosts the database connectivity

Type 2 drivers are part java part native code

so both these drivers have os compatibility issues

Infact type 1 would only run on Microsoft OS

Type 2 drivers would face portability issues

Regarding type 3 driver - havent come across a scenario where I would use one

type 4 is a pure java driver - gives good performance - no portability issues

Thanks ,
-anagha
[ December 28, 2005: Message edited by: anagha patankar ]
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by anagha patankar:


Infact type 1 would only run on Microsoft OS



In fact, there are also ODBC drivers for the Macintosh.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic