[ 
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

Reply via email to