aspose file tools*
The moose likes JDBC and the fly likes JDBC drivers questions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC drivers questions" Watch "JDBC drivers questions" New topic
Author

JDBC drivers questions

Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9426
    
    2

Guys,

I have some doubts related to JDBC drivers...

1) Native-protocol pure Java driver: This kind of driver converts JDBC calls directly into the network protocol used by DBMSs...What it means by saying network protocol used by DBMS???

2) JDBC-Net pure Java driver: This driver translates JDBC calls into a DBMS-independent net protocol, which is then translated to a DBMS protocol by a server. This net server middleware is able to connect its pure Java clients to many different databases....so does it mean that we always need a server middleware when we use this driver??

3) Also with JDBC-ODBC bridge driver plus ODBC driver, why do we need ODBC binary code and database client code to be loaded on each clients machine??

Please help guys!


SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


1) Native-protocol pure Java driver: This kind of driver converts JDBC calls directly into the network protocol used by DBMSs...What it means by saying network protocol used by DBMS???

It means whatever protocol the database engine uses to serve requests. That could be something like TCP/IP, but could be something proprietory.


2) JDBC-Net pure Java driver: This driver translates JDBC calls into a DBMS-independent net protocol, which is then translated to a DBMS protocol by a server. This net server middleware is able to connect its pure Java clients to many different databases....so does it mean that we always need a server middleware when we use this driver??

Yes, though this should be part of your database.


3) Also with JDBC-ODBC bridge driver plus ODBC driver, why do we need ODBC binary code and database client code to be loaded on each clients machine??

That's just how ODBC work I'm afraid. Something has to implement the ODBC standards, and that something must be resident on the client machine.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC drivers questions