Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequences after redeploying app weblogic

676767Jun 2 2009 — edited Jun 3 2009
How to configure data source or app to avoid starting seqencing from first deployment?
I have app and when i deployd it first time everything works fine but when i redeployed this app and tried to persist some entity.app assigned ids from beginning.

I'm using org.eclipse.persistence.jpa.PersistenceProvider.

I've got an exeption:

EL Info: 2009.05.29 14:54:53.109--ServerSession(33551112)--EclipseLink, version: Eclipse Persistence Services - 1.0.2 (Build 20081024)
EL Info: 2009.05.29 14:54:53.109--ServerSession(33551112)--Server: WebLogic Server Temporary Patch for CR381265 Wed Oct 08 10:15:58 PDT 2008
EL Info: 2009.05.29 14:54:53.109--ServerSession(33551112)--file:/C:/java/Weblogic/user_projects/domains/alfa_domain/servers/AdminServer/tmp/_WL_user/demoTspEar/he1579/ejbJar.jar-Model login successf
ul
EL Warning: 2009.05.29 14:54:55.765--UnitOfWork(836669)--Exception EclipseLink-4002 (Eclipse Persistence Services - 1.0.2 (Build 20081024)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: naruszono wiŕzy unikatowe (DEMO_TSP.PK_GEO_ZAMOWIENIA)

Error Code: 1
Call: INSERT INTO GEO_ZAMOWIENIA (ID, CZAS_PODJECIA, CZAS_PRZYGOTOWANIA, CZAS_REALIZACJI, GEOMETRY, GEOMETRY_PUNKT, KOD, KURIER_ID, LINK_ID, NAZWA, NODE_ID, NR_DOM, NR_LOKAL, POZYCJA_X, POZYCJA_Y, ULI
CA, UWAGI, REJON_ID, STATUS_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => 173, 2009-05-29 14:54:53.828, null, null, JGeometry (gtype=2, dim=2, srid=8307, JGeometry (gtype=1, dim=2, srid=8307, , null, 361739, Hynka, null, 2, , null, null, Hynka, , 16, 1
Query: InsertObjectQuery(pl.alfaprojekt.model.beans.GeoZamowienia@18104f9)
EL Warning: 2009.05.29 14:54:55.812--UnitOfWork(836669)--Exception EclipseLink-4002 (Eclipse Persistence Services - 1.0.2 (Build 20081024)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: naruszono wiŕzy unikatowe (DEMO_TSP.PK_GEO_ZAMOWIENIA)

Error Code: 1
Call: INSERT INTO GEO_ZAMOWIENIA (ID, CZAS_PODJECIA, CZAS_PRZYGOTOWANIA, CZAS_REALIZACJI, GEOMETRY, GEOMETRY_PUNKT, KOD, KURIER_ID, LINK_ID, NAZWA, NODE_ID, NR_DOM, NR_LOKAL, POZYCJA_X, POZYCJA_Y, ULI
CA, UWAGI, REJON_ID, STATUS_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => 173, 2009-05-29 14:54:53.828, null, null, JGeometry (gtype=2, dim=2, srid=8307, JGeometry (gtype=1, dim=2, srid=8307, , null, 361739, Hynka, null, 2, , null, null, Hynka, , 16, 1
Query: InsertObjectQuery(pl.alfaprojekt.model.beans.GeoZamowienia@18104f9)
<2009-05-29 14:54:55 CEST> <Error> <EJB> <BEA-010026> <Exception occurred during commit of transaction Name=http://EJB pl.alfaprojekt.model.session.DemoTspSessionBean.persistEntity(java.lang.Object),Xid=BE
A1-00CFFAF0F7F73C5232D0(23884579),Status=Rolled back. http://Reason=weblogic.transaction.internal.AppSetRollbackOnlyException,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=1,seconds left=30
,XAServerResourceInfohttp://weblogic.jdbc.wrapper.JTSXAResourceImpl=(ServerResourceInfohttp://weblogic.jdbc.wrapper.JTSXAResourceImpl=(state=rolledback,assigned=AdminServer),xar=weblogic.jdbc.wrapper.JTSXAResou
rceImpl@fb05b7,re-Registered = false),SCInfoalfa_domain+AdminServer=(state=rolledback),properties=({weblogic.transaction.name=[EJB pl.alfaprojekt.model.session.DemoTspSessionBean.persistEntity(java.
lang.Object)], weblogic.jdbc=t3://192.168.230.1:7001}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=AdminServer+192.168.230.1:7001+alfa_domain+t3+, XAResources={WLStore
_alfa_domain__WLS_AdminServer, weblogic.jdbc.wrapper.JTSXAResourceImpl},NonXAResources={})],CoordinatorURL=AdminServer+192.168.230.1:7001+alfa_domain+t3+): weblogic.transaction.RollbackException: Unkn
own reason
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1818)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:336)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:230)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:591)
at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(BaseLocalObject.java:424)
at pl.alfaprojekt.model.session.DemoTspSession_ilspls_DemoTspSessionLocalImpl.persistEntity(DemoTspSession_ilspls_DemoTspSessionLocalImpl.java:1075)
at pl.alfaprojekt.service.AppService.addOrder(AppService.java:95)
at pl.alfaprojekt.view.action.AddOrderAction.execute(AddOrderAction.java:67)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at pl.alfaprojekt.view.filters.UTF8Filter.doFilter(UTF8Filter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: weblogic.transaction.internal.AppSetRollbackOnlyException
at weblogic.transaction.internal.TransactionImpl.setRollbackOnly(TransactionImpl.java:539)
at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:316)
at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:309)
at org.eclipse.persistence.transaction.JTATransactionController.markTransactionForRollback_impl(JTATransactionController.java:145)
at org.eclipse.persistence.transaction.AbstractTransactionController.markTransactionForRollback(AbstractTransactionController.java:196)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.rollbackTransaction(UnitOfWorkImpl.java:4271)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1290)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:478)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1330)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:2848)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:223)
at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157)
at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1217)
at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1195)
at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:118)
at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1302)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2114)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:263)
... 27 more
.>
2009-05-29 14:54:56 org.apache.struts.action.RequestProcessor processException
WARNING: Unhandled Exception thrown: class javax.ejb.TransactionRolledbackLocalException
<2009-05-29 14:54:56 CEST> <Error> <HTTP> <BEA-101017> <[weblogic.servlet.internal.WebAppServletContext@cf6730 - appName: 'demoTspEar', name: 'demoTsp', context-path: '/demoTsp', spec-version: '2.5',
request: weblogic.servlet.internal.ServletRequestImpl@117a88b[
GET /demoTsp/addOrder.do?nazwa=Hynka&ulica=Hynka&nrDom=2&nrLokal=&kod=&uwagi= HTTP/1.1
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10
Accept: text/javascript, text/html, application/xml, text/xml, /
Accept-Language: pl,en-us;q=0.7,en;q=0.3
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-2,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Connection: keep-alive
X-Requested-With: XMLHttpRequest
X-Prototype-Version: 1.6.0.3
Referer: http://localhost:7001/demoTsp/order.do
Cookie: ADMINCONSOLESESSION=hmdxKdLGLJQ0f24cg0X1xkZ9Xy0Hh2T2vWB6sdTSRkqc9P7PZ2Sx!-2037212537; JSESSIONID=gRcCKfLbzqymHQGLy6rpgvfTxjhHPltGQPbxTJ2bV7j7D6hdtvh7!-631661241

]] Root cause of ServletException.
javax.ejb.TransactionRolledbackLocalException: Error committing transaction:; nested exception is: weblogic.transaction.internal.AppSetRollbackOnlyException
at weblogic.ejb.container.internal.EJBRuntimeUtils.throwTransactionRolledbackLocal(EJBRuntimeUtils.java:238)
at weblogic.ejb.container.internal.EJBRuntimeUtils.throwEJBException(EJBRuntimeUtils.java:133)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:623)
at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(BaseLocalObject.java:424)
at pl.alfaprojekt.model.session.DemoTspSession_ilspls_DemoTspSessionLocalImpl.persistEntity(DemoTspSession_ilspls_DemoTspSessionLocalImpl.java:1075)
Truncated. see log file for complete stacktrace
weblogic.transaction.internal.AppSetRollbackOnlyException
at weblogic.transaction.internal.TransactionImpl.setRollbackOnly(TransactionImpl.java:539)
at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:316)
at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:309)
at org.eclipse.persistence.transaction.JTATransactionController.markTransactionForRollback_impl(JTATransactionController.java:145)
at org.eclipse.persistence.transaction.AbstractTransactionController.markTransactionForRollback(AbstractTransactionController.java:196)
Truncated. see log file for complete stacktrace
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2009
Added on Jun 2 2009
#application-servers, #toplink-jpa
4 comments
3,562 views