You can create new pools by clicking the Using the Geronimo database pool wizard link on the Database Pools portlet. This wizard will guide you through a four easy steps procedure.
- you need to specify the name of the database pool and the database type.
- you select the JDBC drivers which, by default, it has been pre-filled based on the database type you selected in the previous step. You also have to select the driver JAR from the scroll-down menu and then specify the database name. For this example a test database was previously created, this is a single step procedure and it is explained in Configuring databases in Geronimo. Starting from 2.1.7, you can secure the connections to the embedded Derby databases using geronimo-admin security realm. The default user name is dbadmin and the password manager. You can always change the default password if necessary. For datasources created using blank username and password, you must update the values of those 2 parameters as APP and APP to access relevant databases properly. See accessing user defined databases for more details.
- The following figure shows the Deployment Plan for the selected database. This plan contains the pool type and connector interface as well as the connection factory options from the setup properties.
- When you successfully tested the connection, click on Deploy. Alternatively you can click on Show Plan, this option shows you the deployment plan for this database pool and lets you edit it. Additional instructions on how to manually deploy a DB plan may be found in the Configuring DB2 Datasource section.