juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Toufic Arabi <tar...@redhat.com>
Subject Re: Autocommit error with OpenJPA, JBoss and Oracle
Date Mon, 24 Mar 2014 20:39:09 GMT
in the persistence.xml file? if so how is this done? 

----- Original Message -----

From: "Kurt Stam" <kurt.stam@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 




Mime
View raw message