Atomikos Forum

Hi,
We are getting an issue while uploading a image file as a blob into Oracle database. We are using Oracle XA Datasource.

Oracle database version
-----------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

Oracle Driver
------------------
ojdbc6.jar


Atomikos version
--------------------
Atomikos 3.4.4

Exception Stack Trace (Snippet)
--------------------------------
Caused by: com.xyz.common.exception.ABCRuntimeException: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; 
--- The error occurred in persistence/store/entity/softwareDomain/utility/common/blob/ScannedImageLegacy.xml. 
--- The error occurred while executing update. 
--- Check the          INSERT INTO images (isi_barcode,isi_file_type,isi_file_size_kb,isi_file_compressed,isi_date_created)         VALUES (?, ?, ?, ?, ?)  . 
--- Check the SQL Statement (preparation failed). 
--- Cause: com.atomikos.datasource.ResourceException: resume for XID com.xyz.iprompt.global_transaction_manager1356300383com.xyz.iprompt.global_transaction_manager146256 raised -6: the XA resource did not expect this command in the current context; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in persistence/store/entity/softwareDomain/utility/common/blob/ScannedImageLegacy.xml. 
--- The error occurred while executing update. 
--- Check the          INSERT INTO images (isi_barcode,isi_file_type,isi_file_size_kb,isi_file_compressed,isi_date_created)         VALUES (?, ?, ?, ?, ?)  . 

Any help pointing to possible reasons is much appreciated?

Thanks,
Satish

Not sure, but it might be an intermediate timeout/rollback.

Newer releases don't rollback on timeout any more, you might want to try downloading a recent version. Or, you might try and increase the timeout.

HTH