[ 
https://issues.apache.org/jira/browse/OPENJPA-2312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13535210#comment-13535210
 ] 

Kevin Sutter commented on OPENJPA-2312:
---------------------------------------

MySQL happens to be one of the databases that the default value is changed to 
"false" for supportsMultipleNontransactionalResultSets.  If you want to run 
with this for H2, you could easily update your persistence.xml with the 
following property to change this setting:

<property name="openjpa.jdbc.DBDictionary" 
value="h2(SupportsMultipleNontransactionalResultSets=false)"/>

Although it looks like this will get you around your immediate problem, I think 
you should still look at whether you are trying to use the managed connection 
factory mode or not.  If you are not, then maybe you do want to run with this 
property set to "false".  Good luck.
                
> H2 is forced to autoCommit; breaks transactions
> -----------------------------------------------
>
>                 Key: OPENJPA-2312
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2312
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.0.0
>            Reporter: Gustavo Lopes
>         Attachments: details.txt
>
>
> DataSourceFactory::installDBDictionary() sets autocommit to TRUE on the 
> ConfiguringConnectionDecorator because 
> supportsMultipleNontransactionalResultSets is true.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to