How do find debugging problems related to JDBC API?
Answer / 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 |
What is the function of setautocommit?
What is JDBC DataSource and what are it’s benefits?
Which is better jpa or jdbc?
How do you create Connection?
What are the different types of 2 tier and 3 tier architecture ?
If iam using JDBC API, do I also have to use ODBC?
How to use JDBC API to call Stored Procedures?
i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?
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 is the syntax of URL to get connection?
How to store images in database?
What are the new features available in jdbc 4.0?