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" <kurt.s...@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" <kurt.s...@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 < tar...@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 tar...@redhat.com -- Toufic Arabi Consultant, Red Hat Consulting Red Hat 8260 Greensboro Dr McLean, VA tar...@redhat.com </blockquote> </blockquote> -- Toufic Arabi Consultant, Red Hat Consulting Red Hat 8260 Greensboro Dr McLean, VA tar...@redhat.com
persistence.xml
Description: XML document