Is the JDBC-ODBC Bridge multi-threaded?

Is the JDBC-ODBC Bridge multi-threaded?

No. The JDBC-ODBC Bridge uses synchronized methods to serialize all the calls made to ODBC. The concurrent access from multiple threads is not supported by the bridge.

The multi-threaded Java programs that use the bridge wouldn’t get the benefits of multi-threading. Also, there are chances of the occurrence of deadlocks between the locks held in the database and the semaphores used in the bridge. Although, they were added to make things simple for programmers, it is being thought of having them removed.
What is an SQL Locator?
JDBC SQL Locator - DBMS uses the logical pointers as identifiers to locate and manipulate the data. A Locator is an SQL3 data-type...
What is optimistic concurrency control?
JDBC Optimistic Concurrency Control - In optimistic concurrency control, locks are granted without performing conflict checks. In this, a track of files which have been read...
What is pessimistic concurrency?
JDBC Pessimistic Concurrency - In this approach, each transaction is assigned a timestamp. One can make sure that they are unique...
Post your comment