20+ Asked Interview Questions and Answers (2024)

質問 11. What does setAutoCommit do?

When a connection is created, it is in auto-commit mode. This means that each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed. The way to allow two or more statements to be grouped into a transaction is to disable auto-commit mode:
con.setAutoCommit(false);

Once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitly.

con.setAutoCommit(false);
PreparedStatement updateSales =
con.prepareStatement( "UPDATE EMPLOYEE SET SAL = ? WHERE EMP_NAME LIKE ?");
updateSales.setInt(1, 50000); updateSales.setString(2, "Arindam");
updateSales.executeUpdate();
PreparedStatement updateTotal =
con.prepareStatement("UPDATE EMPLOYEE SET TOTAL = TOTAL + ? WHERE EMP_NAME LIKE ?");
updateTotal.setInt(1, 50000);
updateTotal.setString(2, "Arindam");
updateTotal.executeUpdate();
con.commit();
con.setAutoCommit(true);

質問 12. How do you call a stored procedure from JDBC?

The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open
Connection object. A CallableStatement object contains a call to a stored procedure.
CallableStatement cs = con.prepareCall("{call SHOW_EMPLOYEES}");
ResultSet rs = cs.executeQuery();

質問 13. What is Connection pooling?

Connection pooling is a technique used for sharing server resources among requesting clients. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains a pool of open database connections.

質問 14. Is JDBC-ODBC bridge multi-threaded?

No

質問 15. Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

No

集中型学習パス、模擬テスト、面接向けコンテンツでスキルを伸ばしましょう。

JDBC 面接の質問と回答

関連する比較

質問 11. What does setAutoCommit do?

質問 12. How do you call a stored procedure from JDBC?

質問 13. What is Connection pooling?

質問 14. Is JDBC-ODBC bridge multi-threaded?

質問 15. Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

WithoutBook