To Connect to a JDBC-Compliant Database

Before You Begin

Make sure the database you are connecting to has already been created and is running. If the database drivers for the platforms you are using have not been installed to app_server/lib, copy the drivers to that location.

1. In the NetBeans Services window, expand Databases.

2. If you do not see the driver for the database you are using, copy the driver from your database installation to AppServer_Home/lib and then do the following:

   1. Right-click Drivers, and select New Driver.

   2. On the New JDBC Driver dialog box, click Add.

   3. Browse to and open the JAR or ZIP file you copied to the application server libdirectory.

   4. Accept the default driver class or type in a new one. If no driver is entered, click Find to have the wizard search for an appropriate class.

   5. Enter a name for the driver.

      

   6. Click OK.

   The new database driver appears under Drivers in the Services window.

3. Right-click the new driver, and select Connect Using.

4. In the New Database Connection dialog box, do the following:

   1. Enter the database connection URL.

      ---

      Note –

      Different database platforms use different connection URLs. Refer to your database documentation for the format to use.

      ---

   2. Enter the user name and password to use to log on to the database.

   3. Select Remember Password.

      

   4. To select a specific schema in the database, click the Advanced tab and then click Get Schemas.

      A list of available schemas appears for you to choose from.

   5. Click OK.

   A new database connection appears under Databases.

5. Right-click the new database, and select Connect.