Hi I've been using the 1.2 release of tranql-connector-mysql-local but now I'm trying to upgrade to 1.3 to follow what is being used by Geronimo 2.2-SNAPSHOT. However I have a curious problem:
For my test setup I have a plan.xml with 3 datasources: <?xml version="1.0" encoding="UTF-8"?> <!-- The DB connection pools used in the test instance --> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";> <!-- The Main-DB connection pool --> <resourceadapter> <outbound-resourceadapter> <connection-definition> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> <connectiondefinition-instance> <name>jotta/db/main</name> <config-property-setting name="ServerName">db-main</config-property-setting> <config-property-setting name="PortNumber">3306</config-property-setting> <config-property-setting name="DatabaseName">jdb_main_test</config-property-setting> <config-property-setting name="UserName">jotta</config-property-setting> <config-property-setting name="Password">${mysql.jotta.passwd}</config-property-setting> <connectionmanager> <local-transaction/> <single-pool> <max-size>100</max-size> <min-size>5</min-size> <blocking-timeout-milliseconds>10000</blocking-timeout-milliseconds> <idle-timeout-minutes>5</idle-timeout-minutes> <match-one/> </single-pool> </connectionmanager> </connectiondefinition-instance> </connection-definition> </outbound-resourceadapter> </resourceadapter> <!-- The Shard-000 connection pool --> <resourceadapter> <outbound-resourceadapter> <connection-definition> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> <connectiondefinition-instance> <name>jotta/db/shard-000</name> <config-property-setting name="ServerName">db-000</config-property-setting> <config-property-setting name="PortNumber">3306</config-property-setting> <config-property-setting name="DatabaseName">jdb_shard_000_test</config-property-setting> <config-property-setting name="UserName">jotta</config-property-setting> <config-property-setting name="Password">${mysql.jotta.passwd}</config-property-setting> <connectionmanager> <local-transaction/> <single-pool> <max-size>25</max-size> <min-size>2</min-size> <blocking-timeout-milliseconds>10000</blocking-timeout-milliseconds> <idle-timeout-minutes>5</idle-timeout-minutes> <match-one/> </single-pool> </connectionmanager> </connectiondefinition-instance> </connection-definition> </outbound-resourceadapter> </resourceadapter> <!-- The Shard-001 connection pool --> <resourceadapter> <outbound-resourceadapter> <connection-definition> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> <connectiondefinition-instance> <name>jotta/db/shard-001</name> <config-property-setting name="ServerName">db-001</config-property-setting> <config-property-setting name="PortNumber">3306</config-property-setting> <config-property-setting name="DatabaseName">jdb_shard_001_test</config-property-setting> <config-property-setting name="UserName">jotta</config-property-setting> <config-property-setting name="Password">${mysql.jotta.passwd}</config-property-setting> <connectionmanager> <local-transaction/> <single-pool> <max-size>25</max-size> <min-size>2</min-size> <blocking-timeout-milliseconds>10000</blocking-timeout-milliseconds> <idle-timeout-minutes>5</idle-timeout-minutes> <match-one/> </single-pool> </connectionmanager> </connectiondefinition-instance> </connection-definition> </outbound-resourceadapter> </resourceadapter> </connector> With 1.2 I could find these datasources in global JNDI under the following names: jca:/no.jotta.backup.plugins.test/db-plugin/JCAManagedConnectionFactory/jotta/db/main jca:/no.jotta.backup.plugins.test/db-plugin/JCAManagedConnectionFactory/jotta/db/shard-000 jca:/no.jotta.backup.plugins.test/db-plugin/JCAManagedConnectionFactory/jotta/db/shard-001 But after I upgraded to 1.3 only the first datasource can be found. If I change the order of the datasources in plan.xml so that shard-000 is declared before main, I can find this datasource in JNDI but not main... The Geronimo log does not indicate any problem: 14:59:16,385 INFO [KernelContextGBean] bound gbean no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car?J2EEApplication=null,JCAConnectionFactory=jotta/db/main,JCAResource=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,ResourceAdapter=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,ResourceAdapterModule=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,j2eeType=JCAManagedConnectionFactory,name=jotta/db/main at name no.jotta.backup.plugins.test/db-plugin/JCAManagedConnectionFactory/jotta/db/main 14:59:16,403 INFO [KernelContextGBean] bound gbean no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car?J2EEApplication=null,JCAConnectionFactory=jotta/db/shard-000,JCAResource=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,ResourceAdapter=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,ResourceAdapterModule=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,j2eeType=JCAManagedConnectionFactory,name=jotta/db/shard-000 at name no.jotta.backup.plugins.test/db-plugin/JCAManagedConnectionFactory/jotta/db/shard-000 14:59:16,406 INFO [KernelContextGBean] bound gbean no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car?J2EEApplication=null,JCAConnectionFactory=jotta/db/shard-001,JCAResource=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,ResourceAdapter=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,ResourceAdapterModule=no.jotta.backup.plugins.test/db-plugin/1.1-SNAPSHOT/car,j2eeType=JCAManagedConnectionFactory,name=jotta/db/shard-001 at name no.jotta.backup.plugins.test/db-plugin/JCAManagedConnectionFactory/jotta/db/shard-001 Any idea what might be causing this? Using 1.2 still works fine with 2.2-SNAPSHOT AFAICT, so the problem is not critical. Still strange though. Many thanks for your help! Trygve Hardersen - Jotta
