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.
|