3.4 Connector/J Examples

Examples of using Connector/J are located throughout this document. This section provides a summary and links to these examples.

• Example 3.4, “Connector/J: Obtaining a connection from the DriverManager”

• Example 3.5, “Connector/J: Using java.sql.Statement to execute a SELECT query”

• Example 3.6, “Connector/J: Calling Stored Procedures”

• Example 3.7, “Connector/J: Using Connection.prepareCall()”

• Example 3.8, “Connector/J: Registering output parameters”

• Example 3.9, “Connector/J: Setting CallableStatement input parameters”

• Example 3.10, “Connector/J: Retrieving results and output parameter values”

• Example 3.11, “Connector/J: Retrieving AUTO_INCREMENT column values using Statement.getGeneratedKeys()”

• Example 3.12, “Connector/J: Retrieving AUTO_INCREMENT column values using SELECT LAST_INSERT_ID()”

• Example 3.13, “Connector/J: Retrieving AUTO_INCREMENT column values in Updatable ResultSets”

• Example 3.14, “Connector/J: Using a connection pool with a J2EE application server”

• Example 3.15, “Connector/J: Example of transaction with retry logic”