Setting the JVM Classpath to the Database JDBC Drivers

The database JDBC drivers must be either set in the GlassFish JVM classpath (preferred) or placed in the /glassfish/lib directory before you create the connection pools. This is not necessary for the Derby (JavaDB) database, but is required for Oracle or MySQL. For example, if you are using JDK 6, you would set your GlassFish JVM classpath to the ojdbc6.jar file, which is the Oracle database JDBC driver file for JVM 6.

To Set the GlassFish JVM Classpath Settings

1. Open the GlassFish Admin Console. To access the Admin Console, do the following:

   1. From the Services window of the NetBeans IDE, start the GlassFish server.

   2. Right-click the GlassFish server and select View Admin Console from the popup menu.

      The login screen of the Admin Console appears.

   3. Open the Admin Console using the default username and password:

      • Username: admin

      • Password: adminadmin

2. To access the GlassFish JVM classpath settings:

   1. From the Admin Console's Common Tasks window, click Application Server.

      The Application Server settings appear in the console window to the right.

   2. Click the JVM Settings tab and the Path Settings sub-tab.

3. In the Classpath Suffix field, type the full path for your database JDBC driver on your local directory. For example, C:\GlassFishESB\drivers\oracle11gDriver\ojdbc6.jar.

4. Click Save, and restart GlassFish.

Setting the JVM Classpath for GlassFish Clustering

Additional steps must be taken when setting the GlassFish JVM Classpath to the Database drivers in a clustered environment. For additional information see Configuring the BPEL Service Engine for Clustering in Configuring GlassFish ESB for Clustering.