Atomikos Forum

Hi all,

I am trying to add transaction support for tomcat7 using  atomikos 3.8.

I cannot properly define resource for hsqldb datasouce.
I tried following options, no success
            <Resource
                name="jdbc/profile"
                auth="Container"
                uniqueResourceName="jdbc/profileA"
                type="com.atomikos.jdbc.nonxa.NonXADataSourceBean"
                factory="com.atomikos.tomcat.BeanFactory"
                connectionTimeout="30"
                poolSize="3"
                user="sa"
                password=""
                driverClassName="org.hsqldb.jdbcDriver"
                url="jdbc:hsqldb:hsql://localhost:9002"
            />

            <Resource
                name="jdbc/profile"
                auth="Container"
                uniqueResourceName="jdbc/profileA"
                type="com.atomikos.jdbc.nonxa.NonXADataSourceBean"
                factory="com.atomikos.tomcat.EnhancedTomcatAtomikosBeanFactory"
                connectionTimeout="30"
                poolSize="3"
                user="sa"
                password=""
                driverClassName="org.hsqldb.jdbcDriver"
                url="jdbc:hsqldb:hsql://localhost:9002"
            />
The driver itself works
<!-- === non atomicos ==== -->
<!--Resource name="jdbc/profile" auth="Container" type="javax.sql.DataSource"
              maxActive="100" maxIdle="30" maxWait="10000"
              username="sa" password="" driverClassName="org.hsqldb.jdbcDriver"
              url="jdbc:hsqldb:hsql://localhost:9002"/-->

Thanks in advance for any help,
Jan

Hi Jan,

the factory classes do not support NonXADataSourceBean.

Cheers,
Rainer