[ http://issues.apache.org/jira/browse/IBATIS-288?page=comments#action_12374702 ]
Sven Boden commented on IBATIS-288: ----------------------------------- I don't think this is a bug. It does work when you explicitly demarcate transactions. The default is to rollback, so unless you commit you lose your changes. And this probably is what's happening. In the 30% where it works you will probably commit for other stuff. > Sometimes iBatis does not insert BLOBs using autocommit. > -------------------------------------------------------- > > Key: IBATIS-288 > URL: http://issues.apache.org/jira/browse/IBATIS-288 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.1.5 > Environment: I am working with Oracle 9.2.0.4 using Oracle Thin driver for > 10g2. The client application is running on WIndows XP using JVM 1.4.2_10 and > Oracle is running in a SUSE Enterprise Server 9. > Reporter: Vladimir Alarcón > Priority: Minor > > When inserting an object with a BLOB property, WITHOUT explicit transaction > demarcation, sometimes (approx 30%) it silently does nothing (it does not > insert, but also it does not fail). The other times it inserts the line in > the table without any problems. > I have found that the workaround is to always EXPLICITLY DEMARCATE > transactions, when inserting BLOBs. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira