Thanks for the detailed instruction. It has been documented here: http://cwiki.apache.org/confluence/display/GMOxDOC22/Configuring+a+MySQL+datasource
Any comments? 2009/1/20 Forrest Xia <[email protected]> > Ok, give you a full instruction about how to setup datasource in geronimo. > > There are two ways: > 1. Create a datasource and deploy it as a standalone JEE connector module > 2. Embed a datasource definition in an application deployment plan. > > Method 1: > 1. Refer to the attachment "sample-mysql-xa-ds-plan-standalone.xml" to > create a standalone JEE connector deployment plan > 2. Install the mysql jdbc driver to geronimo repository via admin console, > and ensure its repository id is same as the defined one in the sample plan. > 3. Use command line to deploy it, sample command for 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 > 4. Then you will able to use the datasource via its jndi name > "java:comp/env/jdbc/mysqlxads" > > Method 2: > 1. Refer to the attachment "sample-mysql-xa-ds-plan-embeded.xml" to create > an application deployment plan, replace web module and ejb module according > to your application > 2. Install the mysql jdbc driver to geronimo repository via admin console, > and ensure its repository id is same as the defined one in the sample plan. > 3. Use command line or admin console to deploy your application with the > plan. For example, the command line as follows: > $GERONIMO_HOME/bin/deploy.sh -u system -p manager deploy yourapp.ear > sample-mysql-xa-ds-plan-embeded.xml > 4. Then you will able to use the datasource via its jndi name > "java:comp/env/jdbc/mysqlxads" > > > The transaction config element is something like: > For XA: > <connectionmanager> > <xa-transaction> > <transaction-caching/> > </xa-transaction> > ... > </connectionmanager> > > For local transaction: > <connectionmanager> > <local-transaction/> > ... > </connectionmanager> > > As to how to configure MS SQL datasource, it's similar. > > Good luck! > > Forrest >
