Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.

Validate the SQL insert To validate the successful JDBC insert into HSQLDB, run the DatabaseManagerSwing class again and query the Player table. You will see that your JDBC code has added a new record ...

For example, setLong(1, articleID) resets the first parameter in the template to long type value articleID. JDBC’s PreparedStatement automatically generates the complete SQL statement for execution.

New JDBC drivers link XML to SQL DataDirect has launched a set of drivers for connecting Java 2 Enterprise Edition (J2EE) applications to data in the major relational databases.

Another is that the feature set is limited. Not every feature of ODBC is exposed through the JDBC interface, and not every JDBC function is guaranteed to work as expected against the ODBC system. But, ...

We're using JDBC to run statements against SQL Server 2008 R2 on a Windows 2008 R2 machine from a machine running 64-bit Ubuntu 10.04 LTS with the 2.6.32-32-server kernel.