• Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC Drivers  RSS feed

 
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
 
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 ]
 
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.
 
ice is for people that are not already cool. Chill with this tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!