JDBC Section Index

If the DataSource supports pooling connections, calling getConnetion() on the source will return a PooledConnection, instead of a plain Connection. The DataSource will implement ConnectionPoolData...more

If the DataSource supports pooling connections, calling getConnetion() on the source will return a PooledConnection, instead of a plain Connection. The DataSource will implement ConnectionPoolData...more

There are three areas where exception handling your JDBC code has improved with the changes in JDBC 4.0. First off, you can use the Java 5 for-each loop to easily iterate through the cause of an e...more

With JDBC 4.0, you can call the isValid(int timeout) method. The timeout represents the number of seconds to wait for a reply. If no reply is acquired during the time, false is returned and the ca...more

Place the name of your java.sql.Driver implementation in the file META-INF/services/java.sql.Driver.

When making a JDBC call, an exception may happen. If performing the same task could succeed without changing anything, that exception is transient. For instance, a timeout is a type of transient e...more

National character set support is part of the JDBC 4.0 specification. It didn't quite make it into Java SE 6.0, though was available in early betas.

This is part of the SQL 2003 specification.

JDBC 4.0 is defined by JSR 221. Information is available through its JCP home at http://www.jcp.org/en/jsr/detail?id=221.

Derby is an open source relational database from Apache that is implemented entirely in Java and available under the Apache License. You can get it from http://db.apache.org/derby/.more

Provided the JAR file containing the driver is properly configured, just place the JAR file in the classpath. That's it. No need to manually load the class or register the driver.

You can call the getCause() method of the exception repeatedly try { ... } catch (SQLException sqle) { for(Throwable t : sqle) { System.out.println("Throwable: " + t); Throwable ca...more

You can repeatedly call getCause() of the SQLException: try { ... } catch (SQLException sqle) { for(Throwable t : sqle) { System.out.println("Throwable: " + t); Throwable cause = t...more

Using ROWID as the column name in the query, you can use the Java 6 getRowId(columnNum) method.

The SQLException class is now Iterable in Java 6. try { ... } catch (SQLException sqle) { for(Throwable t : sqle) { System.out.println("Throwable: " + t); } } more