Setting the GlassFish JVM Classpath to the Database Drivers

The database JDBC drivers for Oracle or MySQL 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. For example, if you are using Oracle and JDK 6, you would set your GlassFish JVM classpath to the ojdbc6.jar file.

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.

      The login screen of the Admin Console appears.

   3. Enter your username and password.

      The default user name is admin and the password is adminadmin.

2. To access the GlassFish JVM classpath settings, do the following:

   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 then restart GlassFish.