tranql-connector-mysql-local 1.3

[Trygve Hardersen <tr...@jotta.no>]

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