Atomikos Forum

Hi,

This post is related to the previous issue reported at default82df.html?community.6.2059.7. My apologies that I couldn't to it quickly.

Guy, I have tried your recommendation of releasing the connection after_statement instead of after_transaction as it is now. But is did not help. In fact no change in behaviour at all. Is there something else that I need to change ?

Or is there something else that I can try?

Thanks for all the help.
Midhun.

Hello Guy,

We're experiencing exactly the same problem.

1) We submit an insert statement that has a constraint violation
2) The insertion fails
3) We are trying to read data after the failure
4) The reading fails and all the following attempts to communicate with the database fail until we re-start the servlet container.

We use Atomikos 3.7.0, Hibernate 3.6.0 and Jetty 6.1.23 as a servlet container.

We tried testQuery on AtomikosDataSourceBean, increased AtomikosDataSourceBean.maxPoolSize - nothing helped.

We also verified in the debugger that hibernate.connection.release_mode is set to after_statement.

Could you please let us know what else should we check?

Thank you in advance,
Yuri

Did you configure a testQuery on the DataSource?

HTH

Hi Guy,

We have a test query configured in applicationContext.xml. Below is the exact code :

<bean id="dbDataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean"
        init-method="init" destroy-method="close" depends-on="sysPropsLoader">
        <property name="maxPoolSize" value="${jdbc.maxPoolSize}" />
        <property name="minPoolSize" value="${jdbc.minPoolSize}" />
        <property name="testQuery" value="SELECT 1 FROM DUAL" />
        <property name="uniqueResourceName" value="${jdbc.username}" />
        <property name="xaDataSourceClassName" value="oracle.jdbc.xa.client.OracleXADataSource" />
        <property name="xaProperties" ref="xaProperties" />
    </bean>

Thanks,
Midhun.