You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by Toufic Arabi <ta...@redhat.com> on 2014/03/24 19:32:31 UTC
Autocommit error with OpenJPA, JBoss and Oracle
Hi,
I am seeing this error when deploying Juddiv3 to EAP 6.1.1 after building from source. It seems that there is a commit that needs to happen on the sequence table that is required to be create for juddiv3 to happen when the auto commit is already set. I add to your SQL file the following:
CREATE TABLE &JUDDI_DBO..openjpa_sequence_table (ID NUMBER(4) NOT NULL, SEQUENCE_VALUE NUMBER(20) default NULL, PRIMARY KEY (ID)) TABLESPACE &JUDDI_DATA;
judd_dbo is the owner of the juddi tables and my datasource user has been granted access to the tables created for juddi_dbo
Here is the error. Have you all seen this before?
13:49:41,287 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/juddiv3]] (ServerService Thread Pool -- 61) JBWEB000289: Servlet RegistryServlet threw load() exception: java.sql.SQLException: You cannot commit with autocommit set!
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1061)
at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:341) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:124) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.closeConnection(AbstractJDBCSeq.java:198) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:918) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:455) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:803) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:621) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:589) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:505) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3028) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570) [openjpa-2.2.1.jar:2.2.1]
at org.apache.juddi.config.Install.install(Install.java:135) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:172) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:147) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.<init>(AppConfig.java:87) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:237) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:259) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.Registry.start(Registry.java:73) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46) [classes:]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
--
Toufic Arabi
Consultant, Red Hat Consulting
Red Hat
8260 Greensboro Dr
McLean, VA
tarabi@redhat.com
Re: Autocommit error with OpenJPA, JBoss and Oracle
Posted by Toufic Arabi <ta...@redhat.com>.
Hey Kurt,
Sorry I got caught up with other things. I was using a local tx datasource not the no-tx-datasource. The persistence.xml is attached.
As of now it was rolled back to its working state, database owner same as datasource owner, however i would like to know what the solution is via the persistence.xml file.
Thanks Kurt, and sorry for the late reply,
Toufic
----- Original Message -----
From: "Kurt T Stam" <ku...@gmail.com>
To: dev@juddi.apache.org
Sent: Thursday, March 27, 2014 9:08:00 AM
Subject: Re: Autocommit error with OpenJPA, JBoss and Oracle
Hi Toufic,
Any progress on this? If not just post the persistence.xml and your datasource config.
Cheers,
--Kurt
On 3/24/14, 5:42 PM, Kurt T Stam wrote:
Either in the persistence.xml or the datasource config.
Did you try using a no-tx-datasource yet?
--Kurt
On 3/24/14, 4:39 PM, Toufic Arabi wrote:
<blockquote>
in the persistence.xml file? if so how is this done?
----- Original Message -----
From: "Kurt Stam" <ku...@gmail.com>
To: dev@juddi.apache.org
Sent: Monday, March 24, 2014 3:39:20 PM
Subject: Re: Autocommit error with OpenJPA, JBoss and Oracle
You have to set autocommit to false.
On Mar 24, 2014, at 14:32, Toufic Arabi < tarabi@redhat.com > wrote:
<blockquote>
Hi,
I am seeing this error when deploying Juddiv3 to EAP 6.1.1 after building from source. It seems that there is a commit that needs to happen on the sequence table that is required to be create for juddiv3 to happen when the auto commit is already set. I add to your SQL file the following:
CREATE TABLE &JUDDI_DBO..openjpa_sequence_table (ID NUMBER(4) NOT NULL, SEQUENCE_VALUE NUMBER(20) default NULL, PRIMARY KEY (ID)) TABLESPACE &JUDDI_DATA;
judd_dbo is the owner of the juddi tables and my datasource user has been granted access to the tables created for juddi_dbo
Here is the error. Have you all seen this before?
13:49:41,287 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/juddiv3]] (ServerService Thread Pool -- 61) JBWEB000289: Servlet RegistryServlet threw load() exception: java.sql.SQLException: You cannot commit with autocommit set!
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1061)
at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:341) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:124) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.closeConnection(AbstractJDBCSeq.java:198) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:918) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:455) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:803) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:621) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:589) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:505) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3028) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570) [openjpa-2.2.1.jar:2.2.1]
at org.apache.juddi.config.Install.install(Install.java:135) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:172) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:147) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.<init>(AppConfig.java:87) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:237) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:259) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.Registry.start(Registry.java:73) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46) [classes:]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194)[jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591)[jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798)[jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156)[jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)[jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)[jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
--
Toufic Arabi
Consultant, Red Hat Consulting
Red Hat
8260 Greensboro Dr
McLean, VA
tarabi@redhat.com
--
Toufic Arabi
Consultant, Red Hat Consulting
Red Hat
8260 Greensboro Dr
McLean, VA
tarabi@redhat.com
</blockquote>
</blockquote>
--
Toufic Arabi
Consultant, Red Hat Consulting
Red Hat
8260 Greensboro Dr
McLean, VA
tarabi@redhat.com
Re: Autocommit error with OpenJPA, JBoss and Oracle
Posted by Kurt T Stam <ku...@gmail.com>.
Hi Toufic,
Any progress on this? If not just post the persistence.xml and your
datasource config.
Cheers,
--Kurt
On 3/24/14, 5:42 PM, Kurt T Stam wrote:
> Either in the persistence.xml or the datasource config.
>
> Did you try using a no-tx-datasource yet?
>
> --Kurt
>
> On 3/24/14, 4:39 PM, Toufic Arabi wrote:
>> in the persistence.xml file? if so how is this done?
>>
>> ------------------------------------------------------------------------
>> *From: *"Kurt Stam" <ku...@gmail.com>
>> *To: *dev@juddi.apache.org
>> *Sent: *Monday, March 24, 2014 3:39:20 PM
>> *Subject: *Re: Autocommit error with OpenJPA, JBoss and Oracle
>>
>> You have to set autocommit to false.
>>
>> On Mar 24, 2014, at 14:32, Toufic Arabi <tarabi@redhat.com
>> <ma...@redhat.com>> wrote:
>>
>> Hi,
>>
>> I am seeing this error when deploying Juddiv3 to EAP 6.1.1 after
>> building from source. It seems that there is a commit that needs
>> to happen on the sequence table that is required to be create for
>> juddiv3 to happen when the auto commit is already set. I add to
>> your SQL file the following:
>>
>> CREATE TABLE &JUDDI_DBO..openjpa_sequence_table (ID NUMBER(4) NOT
>> NULL, SEQUENCE_VALUE NUMBER(20) default NULL, PRIMARY KEY (ID))
>> TABLESPACE &JUDDI_DATA;
>>
>> judd_dbo is the owner of the juddi tables and my datasource user
>> has been granted access to the tables created for juddi_dbo
>>
>> Here is the error. Have you all seen this before?
>>
>> 13:49:41,287 ERROR
>> [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/juddiv3]]
>> (ServerService Thread Pool -- 61) JBWEB000289: Servlet
>> RegistryServlet threw load() exception: java.sql.SQLException:
>> You cannot commit with autocommit set!
>> at
>> org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1061)
>> at
>> org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:341)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:124)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.closeConnection(AbstractJDBCSeq.java:198)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:918)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:455)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:803)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:621)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:589)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:505)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3028)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
>> [openjpa-2.2.1.jar:2.2.1]
>> at
>> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
>> [openjpa-2.2.1.jar:2.2.1]
>> at org.apache.juddi.config.Install.install(Install.java:135)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at
>> org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:172)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at
>> org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:147)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at org.apache.juddi.config.AppConfig.<init>(AppConfig.java:87)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at
>> org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:237)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at
>> org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:259)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at org.apache.juddi.Registry.start(Registry.java:73)
>> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
>> at
>> org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46)
>> [classes:]
>> at
>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194)[jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
>> at
>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100)
>> [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
>> at
>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591)[jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
>> at
>> org.apache.catalina.core.StandardContext.start(StandardContext.java:3798)[jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
>> at
>> org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156)[jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
>> at
>> org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)[jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
>> at
>> org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)[jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
>> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
>> Source) [rt.jar:1.7.0]
>> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
>> [rt.jar:1.7.0]
>> at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0]
>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
>> Source) [rt.jar:1.7.0]
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
>> Source) [rt.jar:1.7.0]
>> at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0]
>> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
>>
>>
>> --
>>
>> *Toufic Arabi
>> **Consultant, Red Hat Consulting*
>> *Red Hat*
>> 8260 Greensboro Dr
>> McLean, VA
>> tarabi@redhat.com <ma...@redhat.com>
>>
>>
>>
>>
>>
>> --
>>
>> *Toufic Arabi
>> **Consultant, Red Hat Consulting*
>> *Red Hat*
>> 8260 Greensboro Dr
>> McLean, VA
>> tarabi@redhat.com
>>
>>
>
Re: Autocommit error with OpenJPA, JBoss and Oracle
Posted by Kurt T Stam <ku...@gmail.com>.
Either in the persistence.xml or the datasource config.
Did you try using a no-tx-datasource yet?
--Kurt
On 3/24/14, 4:39 PM, Toufic Arabi wrote:
> in the persistence.xml file? if so how is this done?
>
> ------------------------------------------------------------------------
> *From: *"Kurt Stam" <ku...@gmail.com>
> *To: *dev@juddi.apache.org
> *Sent: *Monday, March 24, 2014 3:39:20 PM
> *Subject: *Re: Autocommit error with OpenJPA, JBoss and Oracle
>
> You have to set autocommit to false.
>
> On Mar 24, 2014, at 14:32, Toufic Arabi <tarabi@redhat.com
> <ma...@redhat.com>> wrote:
>
> Hi,
>
> I am seeing this error when deploying Juddiv3 to EAP 6.1.1 after
> building from source. It seems that there is a commit that needs
> to happen on the sequence table that is required to be create for
> juddiv3 to happen when the auto commit is already set. I add to
> your SQL file the following:
>
> CREATE TABLE &JUDDI_DBO..openjpa_sequence_table (ID NUMBER(4) NOT
> NULL, SEQUENCE_VALUE NUMBER(20) default NULL, PRIMARY KEY (ID))
> TABLESPACE &JUDDI_DATA;
>
> judd_dbo is the owner of the juddi tables and my datasource user
> has been granted access to the tables created for juddi_dbo
>
> Here is the error. Have you all seen this before?
>
> 13:49:41,287 ERROR
> [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/juddiv3]]
> (ServerService Thread Pool -- 61) JBWEB000289: Servlet
> RegistryServlet threw load() exception: java.sql.SQLException: You
> cannot commit with autocommit set!
> at
> org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1061)
> at
> org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:341)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:124)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.closeConnection(AbstractJDBCSeq.java:198)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:918)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:455)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:803)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:621)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:589)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:505)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3028)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
> [openjpa-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
> [openjpa-2.2.1.jar:2.2.1]
> at org.apache.juddi.config.Install.install(Install.java:135)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at
> org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:172)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at
> org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:147)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.config.AppConfig.<init>(AppConfig.java:87)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at
> org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:237)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at
> org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:259)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.Registry.start(Registry.java:73)
> [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at
> org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46)
> [classes:]
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194)
> [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100)
> [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591)
> [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:3798)
> [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at
> org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156)
> [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
> at
> org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)
> [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
> at
> org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)
> [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
> Source) [rt.jar:1.7.0]
> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
> [rt.jar:1.7.0]
> at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
> Source) [rt.jar:1.7.0]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source) [rt.jar:1.7.0]
> at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
>
>
> --
>
> *Toufic Arabi
> **Consultant, Red Hat Consulting*
> *Red Hat*
> 8260 Greensboro Dr
> McLean, VA
> tarabi@redhat.com <ma...@redhat.com>
>
>
>
>
>
> --
>
> *Toufic Arabi
> **Consultant, Red Hat Consulting*
> *Red Hat*
> 8260 Greensboro Dr
> McLean, VA
> tarabi@redhat.com
>
>
Re: Autocommit error with OpenJPA, JBoss and Oracle
Posted by Toufic Arabi <ta...@redhat.com>.
in the persistence.xml file? if so how is this done?
----- Original Message -----
From: "Kurt Stam" <ku...@gmail.com>
To: dev@juddi.apache.org
Sent: Monday, March 24, 2014 3:39:20 PM
Subject: Re: Autocommit error with OpenJPA, JBoss and Oracle
You have to set autocommit to false.
On Mar 24, 2014, at 14:32, Toufic Arabi < tarabi@redhat.com > wrote:
Hi,
I am seeing this error when deploying Juddiv3 to EAP 6.1.1 after building from source. It seems that there is a commit that needs to happen on the sequence table that is required to be create for juddiv3 to happen when the auto commit is already set. I add to your SQL file the following:
CREATE TABLE &JUDDI_DBO..openjpa_sequence_table (ID NUMBER(4) NOT NULL, SEQUENCE_VALUE NUMBER(20) default NULL, PRIMARY KEY (ID)) TABLESPACE &JUDDI_DATA;
judd_dbo is the owner of the juddi tables and my datasource user has been granted access to the tables created for juddi_dbo
Here is the error. Have you all seen this before?
13:49:41,287 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/juddiv3]] (ServerService Thread Pool -- 61) JBWEB000289: Servlet RegistryServlet threw load() exception: java.sql.SQLException: You cannot commit with autocommit set!
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1061)
at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:341) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:124) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.closeConnection(AbstractJDBCSeq.java:198) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:918) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:455) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:803) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:621) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:589) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:505) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3028) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933) [openjpa-2.2.1.jar:2.2.1]
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570) [openjpa-2.2.1.jar:2.2.1]
at org.apache.juddi.config.Install.install(Install.java:135) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:172) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:147) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.<init>(AppConfig.java:87) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:237) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:259) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.Registry.start(Registry.java:73) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
at org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46) [classes:]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
--
Toufic Arabi
Consultant, Red Hat Consulting
Red Hat
8260 Greensboro Dr
McLean, VA
tarabi@redhat.com
--
Toufic Arabi
Consultant, Red Hat Consulting
Red Hat
8260 Greensboro Dr
McLean, VA
tarabi@redhat.com
Re: Autocommit error with OpenJPA, JBoss and Oracle
Posted by Kurt Stam <ku...@gmail.com>.
You have to set autocommit to false.
> On Mar 24, 2014, at 14:32, Toufic Arabi <ta...@redhat.com> wrote:
>
> Hi,
>
> I am seeing this error when deploying Juddiv3 to EAP 6.1.1 after building from source. It seems that there is a commit that needs to happen on the sequence table that is required to be create for juddiv3 to happen when the auto commit is already set. I add to your SQL file the following:
>
> CREATE TABLE &JUDDI_DBO..openjpa_sequence_table (ID NUMBER(4) NOT NULL, SEQUENCE_VALUE NUMBER(20) default NULL, PRIMARY KEY (ID)) TABLESPACE &JUDDI_DATA;
>
> judd_dbo is the owner of the juddi tables and my datasource user has been granted access to the tables created for juddi_dbo
>
> Here is the error. Have you all seen this before?
>
> 13:49:41,287 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/juddiv3]] (ServerService Thread Pool -- 61) JBWEB000289: Servlet RegistryServlet threw load() exception: java.sql.SQLException: You cannot commit with autocommit set!
> at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1061)
> at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
> at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:341) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:124) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.closeConnection(AbstractJDBCSeq.java:198) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.TableJDBCSeq$AllocateSequenceRunnable.run(TableJDBCSeq.java:918) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:455) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:300) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:778) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:762) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:135) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:600) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:803) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:621) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:589) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:505) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3028) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1042) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2114) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.juddi.config.Install.install(Install.java:135) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:172) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:147) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.config.AppConfig.<init>(AppConfig.java:87) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:237) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:259) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.Registry.start(Registry.java:73) [juddi-core-openjpa-3.2.0-SNAPSHOT.jar:]
> at org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46) [classes:]
> at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
> at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
> at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
> at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [rt.jar:1.7.0]
> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [rt.jar:1.7.0]
> at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0]
> at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
>
> --
> Toufic Arabi
> Consultant, Red Hat Consulting
> Red Hat
> 8260 Greensboro Dr
> McLean, VA
> tarabi@redhat.com
>
>