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