You have to set autocommit to false.
> On Mar 24, 2014, at 14:32, Toufic Arabi <tar...@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 > tar...@redhat.com > >
