Chapter 5 Connector/J Examples

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

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

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

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

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

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

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

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

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

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

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

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

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