Optimizing connection management

In this recipe, we will see how to manage a database connection in our application, using Java.

Getting ready

To execute the source code we need the java compiler javac and the java runtime environment installed.

Note

Make sure that jdbc\lib\ojdbc6.jar is in the CLASSPATH environment variable. The jdbc folder is located under the Oracle home directory.

To set environment variables in Microsoft Windows environments, right-click on My Computer, select Properties, then navigate to the Advanced button or link—depending on the OS version—and click on Environment Variables and find the CLASSPATH environment variable. If you don't find it, click on the New button and enter the variable name CLASSPATH and variable value %ORACLE_HOME%\jdbc\lib\ojdbc6.jar. If the variable is already defined, click on the Edit button and enter the string %ORACLE_HOME%\jdbc\lib\ojdbc6.jar after the current value.

In Linux environments, export the variable CLASSPATH using the following command...