|Executing SQL statements at deployment time||Configuring datasources||Import database pools from WebLogic 8.1|
This topic introduces how to import the existing JBoss 4 database pools. For this particular example, use the
hsqldb-ds.xml provided by the default JBoss server, that is
<jboss_home>\server\default\deploy\hsqldb-ds.xml and Hypersonic database.
Before getting started, you must provide Geronimo with the driver jar for Hypersonic HSQL. You can install that driver into Geronimo's repository as described in the following steps:
- Locate the HSQL driver jar
hsqldb.jar. This file is located in the
<jboss_home>\server\default\libdirectory. Make a copy of this file and rename it hsqldb-1.8.0.jar.
- Use the Repository portlet to install the HSQL driver jar . From the Administration Console, click JAR Repository to access the portlet. Click Browse and point to the database driver jar. Change the Group: to Hipersonic, and leave the remaining fields by default. Then click Install. You will see
Hipersonic/hsqldb/1.8.0/jarlisted near the top of the repository entries list.
The following steps will guide you through importing JBoss 4 database pools in the administration console.
- From the Geronimo Administration Console, click on the Database Pools link. From the Database Pools portlet, click Import from JBoss 4. In the Step 1 of Importing the Database Pools, specify the location of the
*-ds.xmlfile and click Next.
- After the JBoss specific datasource is loaded, Step 2 lists the database pools that the wizard was able to recognize from the
hsqldb-ds.xmlfile. Click Confirm and Deploy.
- In the third step, you can edit the recognized database pool. In this step, you have to specify the driver jar that you declared when updating the Geronimo repository. See how Driver JAR: is listed in the following figure.
- Click Test Connection to verify that you entered all the necessary data, and Geronimo can establish a connection.
- Click Deploy. This will take you to the same database pool list page that you saw in Step 2. If you would have more pools defined in the file, you can repeat these steps and selectively import some of the database pools. Because we have only one database pool in this example, you can click Finish to complete the import wizard.
- You now see the imported DefaultDS database pool.