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

JDBC-ODBC Bridge

Keerthi Sagar
Greenhorn

Joined: Apr 21, 2007
Posts: 28
Can anybody tell me how the JDBC-ODBC Bridge works??

I got this question in an technical interview by an MNC... So, before reply, please keep this in mind.


Thanks and Regards,<br />Y. Keerthi Sagar.
Parthasarathy balakrishnan
Greenhorn

Joined: Apr 20, 2007
Posts: 14
Type 1: A JDBC-ODBC Bridge (not the Easysoft JDBC-ODBC Bridge)



JDBC:ODBC Driver

Type 1 JDBC Driver architecture

Type 1 JDBC drivers are always written in platform-specific code and thus limit the potential of the application for cross-platform deployment.

This simple JDBC driver is provided by Sun with the Java Development Kit and implements the JDBC API by making ODBC calls, allowing connection to any ODBC data source available on the local machine.

[ April 21, 2007: Message edited by: David O'Meara ]
[ April 21, 2007: Message edited by: David O'Meara ]

Thanks and Regards,<br />-------------------<br />Parthasarathy Balakrishnan,<br />Bangalore.
Keerthi Sagar
Greenhorn

Joined: Apr 21, 2007
Posts: 28
Thanks for the reply,

But the thing is that I already got the information that you provided.

Still I posted this topic because I need some what more information on this, like how internally it will work, scope related details, limitations of each steps (like JDBC may not connect to DB without using ODBC, in Type 1 architecture) etc.

Any way, once again thanks for your reply.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

I would still say that Parthasarathy Balakrishnan did give a great reply. Reading your initial question, he could not have foreseen that you already knew how the bridge works.
Regards, Jan
[ April 21, 2007: Message edited by: Jan Cumps ]

OCUP UML fundamental and ITIL foundation
youtube channel
Parthasarathy balakrishnan
Greenhorn

Joined: Apr 20, 2007
Posts: 14
Originally posted by Jan Cumps:
I would still say that Parthasarathy Balakrishnan did give a great reply. Reading your initial question, he could not have foreseen that you already knew how the bridge works.
Regards, Jan

[ April 21, 2007: Message edited by: Jan Cumps ]




hi Keerthi Sagar Yanagudda
& Jan Cumps ,


sorry friends that the link is not seen clearly to you both
its my fault that the link name changed.

please refer in the same picture above one link is there
do click on it will get all details about the connectivity query
answers....



by,
Keerthi Sagar
Greenhorn

Joined: Apr 21, 2007
Posts: 28
Thanks Parthasarathy for your reply.

I got information for what I am searching, in the link provided by you.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC-ODBC Bridge