I've been testing the Tranql DataSourceMCF in my Spring app and have run
into a problem. I'd like to see if this is an actual bug before I open
a new JIRA issue. It seems Tranql is not using the database connection
URL to distinguish underlying connections in its connection pool, which
causes DataSourceMCF to sometimes return a connection to the wrong DB!
I have two DataSourceMCFs defined in my Spring app that connect to two
different databases. They both use the same DB driver and the same
username/password. The only difference is in the URL. See below for my
Spring xml. Anyway, the 'audit.ds' is almost always returning a
connection to the 'main.ds' database - unless all connections to the
'main.ds' in the connection pool are exhausted. Is this expected?
Should I be using a different ConnectionManager with each
DataSourceMCF? Or is this a bug?
Note, I'm using Jencks 2, and I've modified the Spring config below to
show our test HSQLDB config.
Thanks,
Andy
Here is my Spring config:
<beans>
...
<bean id="transactionManager"
class="org.jencks.factory.TransactionManagerFactoryBean"/>
<bean id="connectionManager"
class="org.jencks.factory.ConnectionManagerFactoryBean">
<property name="transactionManager" ref="transactionManager"/>
<property name="poolMaxSize" value="20"/>
</bean>
<bean id="main.ds"
class="org.jencks.factory.ConnectionFactoryFactoryBean">
<property name="managedConnectionFactory">
<bean class="org.jencks.tranql.DataSourceMCF">
<property name="driverName" value="org.hsqldb.jdbcDriver"/>
<property name="user" value="sa"/>
<property name="password" value=""/>
<property name="url" value="jdbc:hsqldb:file:testmain"/>
</bean>
</property>
</bean>
<bean id="audit.ds"
class="org.jencks.factory.ConnectionFactoryFactoryBean">
<property name="managedConnectionFactory">
<bean class="org.jencks.tranql.DataSourceMCF">
<property name="driverName" value="org.hsqldb.jdbcDriver"/>
<property name="user" value="sa"/>
<property name="password" value=""/>
<property name="url" value="jdbc:hsqldb:file:testaudit"/>
</bean>
</property>
</bean>
...
</beans>
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email