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.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
<mailto: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 <mailto:tar...@redhat.com>
--
*Toufic Arabi
**Consultant, Red Hat Consulting*
*Red Hat*
8260 Greensboro Dr
McLean, VA
tar...@redhat.com
