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 Thu, 27 Mar 2014 13:08:00 GMT
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" <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