Is the JDBC-ODBC Bridge multi-threaded?

Java database interview questions

(Continued from previous question...)

2. Is the JDBC-ODBC Bridge multi-threaded?

No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge, but they won’t get the advantages of multi-threading.

(Continued on next question...)

Other Interview Questions

• How do you call a Stored Procedure from JDBC?
• Is the JDBC-ODBC Bridge multi-threaded?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is cold backup, hot backup, warm backup recovery?
• When we will Denormalize data?
• What is the advantage of using PreparedStatement?
• What is a “dirty read”?
• What is Metadata and why should I use it?
• What are different types of Transaction Isolation Levels?
• What is 2-phase commit?
• How do you handle your own transaction ?
• What is the normal procedure followed by a java client to access the db.?
• What is a data source?
• What are collection pools? What are the advantages?
• How do you get Column names only for a table (SQL Server)?