Removing database pools

There are two alternatives for removing database pools, you can use the command line Deployer tool or the Installed J2EE Connectors portlet available from the Geronimo Administration Console.

If you choose to use the graphical option click on J2EE Connectors from the Administration Console to access the Installed J2EE Connectors portlet.

This portlet list all the available connectors and allows you to stop, start and uninstall any of those J2EE connectors. Just click Uninstall next to the connector you want to remove.

You can also remove the database pools using the Deployer tool. Among other things, this tool allows you to list the available modules, connection pools are listed my moduleID.

To list all the available modules type the following command from the <geronimo_home>\bin directory:

deploy --user system --password manager list-modules

You should see a list similar to the following example.

D:\geronimo-1.1-Tomcat\bin>deploy --user system --password manager list-modules
Using GERONIMO_BASE:   D:\geronimo-1.1-Tomcat
Using GERONIMO_HOME:   D:\geronimo-1.1-Tomcat
Using GERONIMO_TMPDIR: D:\geronimo-1.1-Tomcat\var\temp
Using JRE_HOME:        C:\Java\jdk1.5.0_06\
Found 33 modules
  + console.dbpool/Derby_Test/1.0/rar
  + geronimo/activemq/1.1/car
  + geronimo/activemq-broker/1.1/car
  + geronimo/axis/1.1/car
  + geronimo/axis-deployer/1.1/car
  + geronimo/client-deployer/1.1/car
  + geronimo/geronimo-gbean-deployer/1.1/car
  + geronimo/hot-deployer/1.1/car
  + geronimo/j2ee-deployer/1.1/car
  + geronimo/j2ee-security/1.1/car
  + geronimo/j2ee-server/1.1/car
  + geronimo/j2ee-system/1.1/car
  + geronimo/openejb/1.1/car
  + geronimo/openejb-deployer/1.1/car
  + geronimo/remote-deploy-tomcat/1.1/car @ http://hc2t60p:8080/remote-deploy
  + geronimo/rmi-naming/1.1/car
  + geronimo/sharedlib/1.1/car
  + geronimo/system-database/1.1/car
  + geronimo/tomcat/1.1/car
  + geronimo/tomcat-deployer/1.1/car
  + geronimo/webconsole-tomcat/1.1/car
      `-> standard.war @ http://hc2t60p:8080/console-standard
      `-> framework.war @ http://hc2t60p:8080/console
  + geronimo/welcome-tomcat/1.1/car @ http://hc2t60p:8080/
    geronimo/client/1.1/car
    geronimo/client-corba/1.1/car
    geronimo/client-security/1.1/car
    geronimo/client-system/1.1/car
    geronimo/j2ee-corba/1.1/car
    geronimo/javamail/1.1/car
    geronimo/online-deployer/1.1/car
    geronimo/shutdown/1.1/car
    geronimo/uddi-tomcat/1.1/car
    geronimo/upgrade/1.1/car
    geronimo/upgrade-cli/1.1/car

D:\geronimo-1.1-Tomcat\bin>

For this example we have the database pool that was created in the Create new database pools section so we will be looking for the Derby_Test database pool. From the modules displayed in the previous example, we can see that console.dbpool/Derby_Test/1.0/rar is at the top of the list, this is the module ID we will need to remove this data source.

With the database pool module ID identified ( in this example console.dbpool/Derby_Test/1.0/rar ) you can now remove it by typing the following command from the <geronimo_home>\bin directory:

deploy --user system --password manager undeploy console.dbpool/Derby_Test/1.0/rar

You should see a confirmation message similar to the following example.

D:\geronimo-1.1-Tomcat\bin>deploy --user system --password manager undeploy console.dbpool/Derby_Test/1.0/rar
Using GERONIMO_BASE:   D:\geronimo-1.1-Tomcat
Using GERONIMO_HOME:   D:\geronimo-1.1-Tomcat
Using GERONIMO_TMPDIR: D:\geronimo-1.1-Tomcat\var\temp
Using JRE_HOME:        C:\Java\jdk1.5.0_06\
    Module console.dbpool/Derby_Test/1.0/rar unloaded.
    Module console.dbpool/Derby_Test/1.0/rar uninstalled.

    Undeployed console.dbpool/Derby_Test/1.0/rar

As an additional step for verification the removal of the database pool you can run the following command, there should be no entries listed.

deploy --user system --password manager list-modules | grep Derby_Test

If you are using MS Windows, grep is not a standard command. You may need to install additional software.