JDBC

Before using savepoints in your application, you need to be sure that your RDBMS supports this facility.

Using java.util.Logger as your logging/tracing tool allows you to take advantage of the Logging framework.

Suppose you need to insert 200,000 records into a database in Hibernate. You'll need to adjust these settings.

If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them.

If you're closint database connections directly—without closing the ResultSet or Statement, you've been causing yourself unnecessary trouble.

If you insert/update/delete multiple times to the database, you ...

Let's start with a code ...

Does "Connection.setAutoCommit(false)" mean "begin a transaction?"

If ResultSet is an interface, then why can we call methods like next(), isLast() etc. without defining the method body anywhere in the program? As I understand it, in an interface, methods are only declared but not defined.

Is the JDBC Connection class thread safe? In other words, can a connection be shared between multiple threads without using synchronization?

Most Java programmers close a connection with database directly without closing the ResultSet. This is okay with standalone Java programs, where the Java compiler automatically closes the Resultset ...

How do I get a string representation of a database field using JDBC regardless of its type? In other words, I have to use the getInt(), getDate(), getString(), etc., to get a field value depending on the field type in the database. I just want the string representations so I can print them in HTML output to a Web browser.

< ...

I have a ResultSet created using JDBC and it contains some date fields. Now I want to subtract one date from the other. How do I do this?

Using JDBC, how can I turn a database table into a series of SQL INSERT statements that can recreate the table?

I'm trying to test the JDBC-ODBC bridge with JDBCTest tool and it gives me the following error: registerDriver() Failed: java.lang.ClassNotFoundException: sun/jdbc/odbc/JdbcOdbcDriver What's the problem?

How can I access the next and previous rows in a ResultSet when I connect to a database through a JDBC driver?

I am building a prototype but am trying to make the code as reuseable as possible. To test the prototype, I need to simulate a ResultSet being returned from a database. When my backend program simulating a database tries to add columns into the ResultSet, I get error messages that the ResultSet has not been initialized, which is true. How would I go about initializing this ResultSet given that I have no database and am currently reading a file and trying to populate the ResultSet using methods within ResultSet.