Atomikos Forum

hi,

  I'm using Atomikos with Tomcat/Spring for XA transaction.  When Tomcat starts up, a SQL script from my app is executed.  So, Atomikos is handling the connection and during startup, my Tomcat instance throws this exception:

WARN : org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
com.atomikos.jdbc.AtomikosSQLException: Connection pool exhausted - try increasing 'maxPoolSize' and/or 'borrowConnectionTimeout' on the DataSourceBean.
    at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:19)
    at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:62)
    at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:57)
    at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:294)
    at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:180)
    at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:341)
    

Not sure what the problem could be.  I increased the poolSize but no luck.  here's my datasource:


<bean id="dataSource" class="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean">
        <property name="uniqueResourceName" value="My Primary Datasource"/>
        <property name="testQuery" value="select 1"/>
        <property name="driverClassName" value="org.hsqldb.jdbcDriver" />
        <property name="url" value="jdbc:hsqldb:mem:googapp" />
        <property name="user" value="xxxx" />
        <property name="password" value="xxxxx" />
        <property name="maxPoolSize" value="500"/>
        <property name="minPoolSize" value="20"/>
        <property name="poolSize"><value>10</value></property>
        <property name="borrowConnectionTimeout" value="120" />
    </bean>


ideas ?

thx

Are you closing connections when you are done using them?