Configuring a DB2 datasource

Configuring datasources

Executing SQL statements at deployment time

This articles shows you how to configure a mysql datasource in Geronimo. Geronimo is embedded with mysql resource adapters supporting both local and XA transactions. You need to install mysql JDBC drivers as instructed.

There are two ways to configure a mysql datasource:

• Creating a datasource and deploying it as a standalone JEE connector module
• Embedding a datasource definition in an application deployment plan

Creating a datasource and deploying it as a standalone JEE connector module

1. See the attachment sample-mysql-xa-ds-plan-standalone.xml to create a standalone Java EE connector deployment plan.
2. Install the mysql jdbc driver to the Geronimo repository by using the adminitration console, and ensure its Module ID is the same as the one defined in the sample plan. In this example, the Module ID of mysql JDBC driver is mysql/mysql-connector-java/5.1.7/jar.
3. Use command line to deploy the datasource. Here is the sample command for deploying mysql xa datasource:

   <geronimo_home>/bin/deploy.sh -u system -p manager deploy 
   <GERONIMO_HOME>/repository/org/tranql/tranql-connector-mysql-xa/1.2/tranql-connector-mysql-xa-1.2.rar sample-mysql-xa-ds-plan-standalone.xml
   

   where <geronimo_home> is the installation directory of Geronimo.

4. Now you are able to use the datasource with its jndi name java:comp/env/jdbc/mysqlxads.

Embedding a datasource definition in an application deployment plan

1. See the attachment sample-mysql-xa-ds-plan-embeded.xml to create an application deployment plan, and replace the web module and the ejb module according to your application.
2. Install the mysql jdbc driver to the Geronimo repository by using the adminitration console, and ensure its Module ID is the same as the one defined in the sample plan. In this example, the Module ID of mysql JDBC driver is mysql/mysql-connector-java/5.1.7/jar.
3. Use command line or adminitrative console to deploy your application with the deployment plan. For example, use the following command line:

   <geronimo_home>/bin/deploy.sh -u system -p manager deploy yourapp.ear sample-mysql-xa-ds-plan-embeded.xml
   

   where <geronimo_home> is the installation directory of Geronimo.

4. Now you are able to use the datasource with its jndi name java:comp/env/jdbc/mysqlxads.

The transaction configuration element is something like the following:

<connectionmanager>
  <xa-transaction>
     <transaction-caching/>
  </xa-transaction>
  ...
</connectionmanager>

And for local transaction:

<connectionmanager>
   <local-transaction/>
   ...
</connectionmanager>