How do find debugging problems related to JDBC API?
Answer Posted / aditi
A good way to find out what JDBC calls are doing is to
enable JDBC tracing. The JDBC trace contains a detailed
listing of the activity occurring in the system that is
related to JDBC operations.
If you use the DriverManager facility to establish your
database connection, you use the DriverManager.setLogWriter
method to enable tracing of JDBC operations. If you use a
DataSource object to get a connection, you use the
DataSource.setLogWriter method to enable tracing. (For
pooled connections, you use the
ConnectionPoolDataSource.setLogWriter method, and for
connections that can participate in distributed
transactions, you use the XADataSource.setLogWriter method.)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?
What are the common JDBC problems that you got and how do you solved them?
How can we execute stored procedures using callablestatement?
What is an SQL Locator?
What do you understand by jdbc statements?
How many categories of jdbc drivers are there?
What is layer in communication?
What is the meaning of batch updates?
What is the benefit of having jdbcrowset implementation?
Why do we need jdbc api?
What is represented by the connection object?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
What are the basic exceptions in jdbc?
Is not bound in this context unable to find jdbc spring boot?
Why do we need jdbc?