You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Vladimir Alarcón (JIRA)" <ib...@incubator.apache.org> on 2006/04/16 16:30:01 UTC
[jira] Created: (IBATIS-288) Sometimes iBatis does not insert BLOBs
using autocommit.
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
[jira] Closed: (IBATIS-288) Sometimes iBatis does not insert BLOBs
using autocommit.
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ http://issues.apache.org/jira/browse/IBATIS-288?page=all ]
Clinton Begin closed IBATIS-288.
--------------------------------
Resolution: Won't Fix
Assignee: Clinton Begin
This is a driver specific behavior, one that I don't think we should do anything about.
> Sometimes iBatis does not insert BLOBs using autocommit.
> --------------------------------------------------------
>
> Key: IBATIS-288
> URL: http://issues.apache.org/jira/browse/IBATIS-288
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects 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
> Assigned To: Clinton Begin
> 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
[jira] Commented: (IBATIS-288) Sometimes iBatis does not insert
BLOBs using autocommit.
Posted by "Sven Boden (JIRA)" <ib...@incubator.apache.org>.
[ 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