[jira] Commented: (GERONIMO-2188) Need to configure CommitBeforeAutoCommit=true for Database Commits in Oracle

["Lin Sun (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GERONIMO-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12467397 ] 

Lin Sun commented on GERONIMO-2188:
-----------------------------------

Hi David, Finally able to verify the patch but it didn't work.  It acted as if the patch isn't there - transaction aren't committed to the database right away - I was doing query on the order (like select * from orderejb where account_accountid=203;)

> Need to configure CommitBeforeAutoCommit=true for Database Commits in Oracle
> ----------------------------------------------------------------------------
>
>                 Key: GERONIMO-2188
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-2188
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: connector
>    Affects Versions: 1.1.1
>            Reporter: Krishnakumar B
>         Assigned To: Matt Hogstrom
>         Attachments: G2188-2.patch, G2188.patch
>
>
> We have to configure CommitBeforeAutCommit="true" property exclusively in the database connection pool plan, to have the ejb -based transactions immediately committed for oracle database. Otherwise it only commits transaction when  the server  shuts-down. This problem is not faces with Derby database.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.