[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Non transactional sequenced ID generation causes unique constraint violation
|
So your sequence is pulling from the DB, correct?
./tch
On Sun, Oct 19, 2008 at 5:51 AM, Mohsen Saboorian <mohsens@xxxxxxxxx> wrote:
>
> Hi,
>
> In a RESOURCE_LOCAL environment we get the following exception when we
> stress test the system using 20 concurrent users. The test scenario is quite
> simple: Open new form for entity E1, fill the form, and press Save button.
>
> Our JPA code is like this:
>
> EntityTransaction tx = em.getTransaction()
> try {
> tx.begin();
> em.persist(obj);
> em.flush();
> tx.commit();
> } catch (Exception ex) {
> if (tx.isActive()) tx.rollback();
> ex.printStackTrace();
> }
>
>
> The error is as follows:
>
> [ITO] INFO (EmaSessionListener.java:17) Initializing user configurations.
> [EL Warning]: 2008.10.19
> 13:00:54.668--UnitOfWork(5099540)--Thread(Thread[http-8080-Processor24,5,main])--Exception
> [EclipseLink-4002] (Eclipse Persistence Services - 1.0.1 (Build 20080905)):
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLException: ORA-00001: unique constraint
> (EMA1.SYS_C005509) violated
>
> Error Code: 1
> Call: INSERT INTO TB_EXPERTIZE (XPT_ID, XPT_CODE, XPT_WAGE, XPT_PROFICIENCY,
> XPT_LAST_UPDATE, XPT_MISSION_WAGE) VALUES (?, ?, ?, ?, ?, ?)
> bind => [48054, null, 1212, poi, 2008-11-08, 1212]
> Query: InsertObjectQuery(Expertize (48054))
> [ITO] ERROR (BaseSession.java:205) Save object Expertize (48054) failed for
> class: Expertize
> javax.persistence.PersistenceException: Exception [EclipseLink-4002]
> (Eclipse Persistence Services - 1.0.1 (Build 20080905)):
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLException: ORA-00001: unique constraint
> (EMA1.SYS_C005509) violated
>
> Error Code: 1
> Call: INSERT INTO TB_EXPERTIZE (XPT_ID, XPT_CODE, XPT_WAGE, XPT_PROFICIENCY,
> XPT_LAST_UPDATE, XPT_MISSION_WAGE) VALUES (?, ?, ?, ?, ?, ?)
> bind => [48054, null, 1212, poi, 2008-11-08, 1212]
> Query: InsertObjectQuery(Expertize (48054))
> at
> org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:387)
> at net.itorbit.ema.biz.BaseSession.save(BaseSession.java:203)
> at net.itorbit.ema.biz.BaseInfoSession.save(BaseInfoSession.java:32)
> at
> net.itorbit.ema.action.ExpertizeAction.executeSave(ExpertizeAction.java:39)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
> at
> org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
> at
> org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
> at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
> at
> org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
> at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
> at
> org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at net.itorbit.ema.helper.LocaleFilter.doFilter(LocaleFilter.java:20)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 1.0.1 (Build 20080905)):
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLException: ORA-00001: unique constraint
> (EMA1.SYS_C005509) viola
>
>
> The ID annotation code in the entity is like this:
> @Id
> @GeneratedValue(strategy = GenerationType.SEQUENCE, generator =
> "ema_id_sq")
> public Long getId() {
> return id;
> }
>
> Where ema_id_sq is:
> @SequenceGenerator(name = "ema_id_sq")
>
>
> Thanks,
> Mohsen.
> --
> View this message in context: http://www.nabble.com/Non-transactional-sequenced-ID-generation-causes-unique-constraint-violation-tp20054596p20054596.html
> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
