Wiki Markup
{scrollbar}

Excerpt
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

See the attachment sample-mysql-xa-ds-plan-standalone.xml to create a standalone Java EE connector deployment plan.
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.

Use command line to deploy the datasource. Here is the sample command for deploying mysql xa datasource:

No Format
<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.

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

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.
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.
Use command line or adminitrative console to deploy your application with the deployment plan. For example, use the following command line:
No Format
<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.
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:

Code Block

	xml
	xml

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

And for local transaction:

Code Block

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