• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC Drivers

 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic