It is advantageous in the situation where no native JDBC database driver is available. This is a three-tier driver, which involves a third server that acts in between the client and the database server. Below is a partial list of companies that are shipping products with JDBC support please see the JavaSoft Web site for most recent list: Those are all open-source. Eliminating the major disadvantages of its legacy, this driver greatly simplifies database access.

Uploader: Nikoran
Date Added: 25 September 2016
File Size: 65.89 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 36513
Price: Free* [*Free Regsitration Required]

You can also learn more here.

9 – JDBC-ODBC Bridge Driver

Industry Momentum Leading database, middleware and tool vendors have been building JDBC support into many new products. Unlike Type 4 ‘All Java’ has a different connotation here — the JDBC driver at the client side translates the client request into a driver specific network protocol, which then sends the request to the listener process on the server. Importantly, it is built for commercial use with high transaction rates and dependable performance.

Sign up using Facebook. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use bridfe the website is subject to these policies.


What is your company size? Email Required, but never shown. You can pull out the dll too.

JDBC Application Design Consideration –

However, the choice becomes crucial in view of performance, compatibility, idbc availability and the programming model to be used. Send SQL statements 3. The bridge driver is no longer shipped with any JVM.

The connection logic is really simple: It is compatible with any third party ODBC driver and gives concurrent access to multiple data sources from multiple client devices. After the request is served, the result is translated back in the reverse order, native format to JDBC and ultimately to the client application.

Now, this flow of information must follow a certain model to systematically transact the information. Like Type 1, Type 2 is also not a very viable alternative for network applications either.


Now Javascript is disabled. Open a CMD window. Version Platform Distribution jdbc-kdbc. The remote server process acts as a proxy for the client. Upvoting this solution, as it worked ok for me. This not only creates a clean and secure environment but also minimizes ripple effect of changes made in any other tier in the scenario.

This ensures that customers can build portable Java applications while choosing from a wide range of competitive products for the solution best suited to their needs. The database is the server, feeding information to the client on every SQL request.


Sign up or log in Sign up using Google.

Both are a bit more work than ODBC though. You can always pull the driver from JDK 7.

ODBC driver is a database vendor independent driver and can be used to connect multiple databases. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Would you like to answer one of these unanswered questions instead?

Client requests are routed through a proxy server. JDBC meta-data access enables the development of sophisticated applications that need to understand the underlying facilities and capabilities of the specific database connection.

We used your product to synchronize our ODBC database with our legacy application and bridgr extremely happy with the performance. Click here to see figures. Using one vendor’s driver on the client and another vendor’s driver on the server will not work. The responses followed the same path in the opposite direction.