Atomikos Forum

Statement is invalid within a global transation error

Hi All,

I am using spring/hibernate/atomikos combination. I get the following error when trying to insert data into two databases. The error seems to be issued by the informix JDBC driver.

I also see a call to the setAutoCommit() method. could you please help me understand what is happening here?

Thanks in Advance.

Regards
Prasad

==
176248: Jun 13 17:47:06.917 IST %MADM-LIB_JDBC-7-JDBC_LOG_MONITOR:JDBC log: message=Connecting to database for operation 'prepareStatement',error_desc=null
176249: Jun 13 17:47:06.918 IST %MADM-LIB_JDBC-7-UNK:SQLWarning: reason(No data) SQLState(02000) vendor code(100)
176250: Jun 13 17:47:06.929 IST %MADM-LIB_JDBC-7-UNK:SQLState(IX000) vendor code(-700)
176251: Jun 13 17:47:06.929 IST %MADM-LIB_JDBC-7-UNK:java.sql.SQLException: Statement is invalid within a global transaction.
176252: Jun 13 17:47:06.929 IST %MADM-LIB_JDBC-7-UNK:  at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:407)
176253: Jun 13 17:47:06.929 IST %MADM-LIB_JDBC-7-UNK:  at com.informix.jdbcx.IfxXAReusableConnection.setAutoCommit(IfxXAReusableConnection.java:271)
176254: Jun 13 17:47:06.929 IST %MADM-LIB_JDBC-7-UNK:  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
176255: Jun 13 17:47:06.929 IST %MADM-LIB_JDBC-7-UNK:  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
176256: Jun 13 17:47:06.930 IST %MADM-LIB_JDBC-7-UNK:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
176257: Jun 13 17:47:06.930 IST %MADM-LIB_JDBC-7-UNK:  at java.lang.reflect.Method.invoke(Method.java:597)
176258: Jun 13 17:47:06.930 IST %MADM-LIB_JDBC-7-UNK:  at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:125)
176259: Jun 13 17:47:06.930 IST %MADM-LIB_JDBC-7-UNK:  at $Proxy99.setAutoCommit(Unknown Source)
==
Prasad Katti Send private email
Sunday, June 13, 2010
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics