This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin for Android App Development and have Peter Sommerhoff on-line!
See this thread for details.
Win a copy of Kotlin for Android App Development this week in the Kotlin forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Devaka Cooray
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

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.
 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database
https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!