To Create and Connect to the Database

1. Create a database instance using your database platform tools. If you are using a Java DB database, perform the following steps to create the database:

   1. On the NetBeans Services window, expand Databases.

   2. Right-click Java DB, and then click Create Database.

      The Create Java DB Database dialog box appears.

   3. Enter a name for the database, along with a login user name and password.

   4. Click OK.

      The database appears in the list of databases on the Services window.

2. Make sure your database instance is running.

3. For Oracle, DB2, SQL Server, and Sybase databases, do the following:

   1. Copy the database driver file to JavaCAPS_Home/appserver/lib.

   2. Under Databases on the NetBeans Services window, right-click Drivers and then select New Driver.

      The New JDBC Driver dialog box appears.

   3. Click Add, and then brows to and select the database driver file.

   4. Select or look for the driver class to use.

   5. Accept the default name or enter a name for the driver.

   6. Click OK.

   7. In the Drivers list on the Services window, right-click the driver you just added and click Connect Using.

      The New Database Connection dialog box appears.

   8. Enter the connection information for the database instance you created for MLLP and then click OK.

      The new database connection appears in the Databases list.

4. On the NetBeans Services window, right-click the MLLP database, and click Connect.

   NetBeans connects to the database and the icon changes for that database. The following figure illustrates a Java DB connection.

   

   ---

   Note –

   A broken icon represents that the database is not connected.

   ---