juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kurt T Stam <kurt.s...@gmail.com>
Subject Re: Autocommit error with OpenJPA, JBoss and Oracle
Date Mon, 24 Mar 2014 21:42:28 GMT
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" <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 
> <mailto: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 <mailto:tarabi@redhat.com>
>
>
>
>
>
> -- 
>
> *Toufic Arabi
> **Consultant, Red Hat Consulting*
> *Red Hat*
> 8260 Greensboro Dr
> McLean, VA
> tarabi@redhat.com
>
>


Mime
View raw message