Re: Persistence question

Armin Waibel Fri, 18 Feb 2005 09:12:34 -0800

seems the constraint violation occur when OJB try to store an 1:n relation of the order object. Does CouponSlug inherit from Product or is it used in a separate relation of Order? Is it possible to post the class-descriptor for Order, Product and CouponSlug? Did involved objects Order or CouponSlug or Product share their database table with other objects? If yes, do you use ojbContrecteClass feature? Which sequence manager do you use?

regards,
Armin

Deborah Nunley wrote:

db-ojb-1.0.1 PersistenceBroker

INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED]
org.apache.ojb.broker.KeyConstraintViolatedException: SQL failure while insert object 
data for class com.valpak.productorder.couponslug.CouponSlug, PK of the given object 
is [ couponSlugId=665058], object was [EMAIL 
PROTECTED],sequenceId=1,address=[],[EMAIL 
PROTECTED],offerText=offer,additionalDisclaimerText=,[EMAIL 
PROTECTED],sequenceId=1,[EMAIL PROTECTED],disclaimerDescription= ,disclaimerText=One 
coupon per customer.,lastUpdate=Fri Sep 18 00:00:00 EDT 
1998]]],productImage=[],expirationDate=<null>,startDate=Tue Aug 31 00:00:00 EDT 
2004,endDate=Tue Aug 31 00:00:00 EDT 
2004,sequenceId=1,printLimit=0,displayExpiration=true]],webLink=[],productImage=[],printable=true,displayRanking=40000,backgroun

[EMAIL PROTECTED],colorName=<null>,hexCode=<null>],[EMAIL PROTECTED],[EMAIL PROTECTED],couponSlugTypeName=<null>]], exception message is [Attempt to insert duplicate key row in object 'Coupon_Slugs' with unique index 'PK_COUPON_SLUGS'

]
        at 
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown 
Source)
        at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToMany(Unknown 
Source)
        at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown 
Source)
        at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToOne(Unknown 
Source)
        at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeReferences(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown 
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown 
Source)
        at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown 
Source)
        at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown 
Source)
        at 
com.valpak.persistence.ojb.OJBPersistenceServiceImpl.storeObject(OJBPersistenceServiceImpl.java:96)
        at 
com.valpak.vpcoladminservice.VPColAdminServiceImpl.storeOrder(VPColAdminServiceImpl.java:119)
        at 
com.valpak.vpcoladmin.action.ProcessOrder.processSave(ProcessOrder.java:176)
        at 
com.valpak.vpcoladmin.action.ProcessOrder.executeAction(ProcessOrder.java:125)
        at 
com.valpak.vpcoladmin.action.VPColAdminBaseAction.execute(VPColAdminBaseAction.java:43)
        at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
com.newatlanta.servletexec.ServletExec.CallServletService(ServletExec.java:1650)
        at 
com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:274)
        at 
com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:191)
        at 
com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1313)
        at 
com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:958)
        at 
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1206)
        at 
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1056)
        at 
com.newatlanta.sedebugger.Responder.processServletRequest(Responder.java:269)
        at com.newatlanta.sedebugger.Responder.run(Responder.java:92)
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Attempt to insert duplicate 
key row in object 'Coupon_Slugs' with unique index 'PK_COUPON_SLUGS'

        at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2738)
        at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2069)
        at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
        at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
        at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
        at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1667)
        at 
com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1650)
        at 
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
        ... 36 more
com.valpak.exceptions.StoreException: SQL failure while insert object data for class 
com.valpak.productorder.couponslug.CouponSlug, PK of the given object is [ 
couponSlugId=665058], object was [EMAIL PROTECTED],sequenceId=1,address=[],[EMAIL 
PROTECTED],offerText=offer,additionalDisclaimerText=,[EMAIL 
PROTECTED],sequenceId=1,[EMAIL PROTECTED],disclaimerDescription= ,disclaimerText=One 
coupon per customer.,lastUpdate=Fri Sep 18 00:00:00 EDT 
1998]]],productImage=[],expirationDate=<null>,startDate=Tue Aug 31 00:00:00 EDT 
2004,endDate=Tue Aug 31 00:00:00 EDT 
2004,sequenceId=1,printLimit=0,displayExpiration=true]],webLink=[],productImage=[],printable=true,displayRanking=40000,background=com.valpak.col

][org.apache.ojb.broker.core.PersistenceBrokerImpl] DEBUG: PB.close was called: 
[EMAIL PROTECTED]

        at 
com.valpak.persistence.ojb.OJBPersistenceServiceImpl.storeObject(OJBPersistenceServiceImpl.java:104)
        at 
com.valpak.vpcoladminservice.VPColAdminServiceImpl.storeOrder(VPColAdminServiceImpl.java:119)
        at 
com.valpak.vpcoladmin.action.ProcessOrder.processSave(ProcessOrder.java:176)
        at 
com.valpak.vpcoladmin.action.ProcessOrder.executeAction(ProcessOrder.java:125)
        at 
com.valpak.vpcoladmin.action.VPColAdminBaseAction.execute(VPColAdminBaseAction.java:43)
        at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
com.newatlanta.servletexec.ServletExec.CallServletService(ServletExec.java:1650)
        at 
com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:274)
        at 
com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:191)
        at 
com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1313)
        at 
com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:958)[2005-02-18
 10:52:30,231] com.valpak.vpcoladmin.action.VPColAdminBaseAction - 
com.valpak.exceptions.StoreException: SQL failure while insert object data for class 
com.valpak.productorder.couponslug.CouponSlug, PK of the given object is [ 
couponSlugId=665058], object was [EMAIL PROTECTED],sequenceId=1,address=[],[EMAIL 
PROTECTED],offerText=offer,additionalDisclaimerText=,[EMAIL 
PROTECTED],sequenceId=1,[EMAIL PROTECTED],disclaimerDescription= ,disclaimerText=One 
coupon per customer.,lastUpdate=Fri Sep 18 00:00:00 EDT 
1998]]],productImage=[],expirationDate=<null>,startDate=Tue Aug 31 00:00:00 EDT 
2004,endDate=T

ue Aug 31 00:00:00 EDT 2004,sequenceId=1,printLimit=0,displayExpiration=true]],webLink=[],productImage=[],printable=true,displayRanking=40000,[EMAIL PROTECTED],colorName=<null>,hexCode=<null>],[EMAIL PROTECTED],[EMAIL PROTECTED],couponSlugTypeName=<null>]], exception message is [Attempt to insert duplicate key row in object 'Coupon_Slugs' with unique index 'PK_COUPON_SLUGS'

]
        at 
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1206)
        at 
com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1056)
        at 
com.newatlanta.sedebugger.Responder.processServletRequest(Responder.java:269)
        at com.newatlanta.sedebugger.Responder.run(Responder.java:92)
-----Original Message-----
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 10:39 AM
To: OJB Users List
Subject: Re: Persistence question
Hi Deb,
what OJB version do you use? Which api?
Could you post the whole stack trace.
regards,
Armin
Deborah Nunley wrote:
Sequence of events
I create the order with a product and persist it twice (as we gather information). I delete the product from the order (within the application). I add another product to the order. I save the order again.
Everything looks good from the debugger but I get the following exception
SQL failure while insert object data for class com.valpak.productorder.couponslug.CouponSlug, PK of the given object is [ couponSlugId=665055], object was [EMAIL PROTECTED],sequenceId=1,address=[],[EMAIL PROTECTED],offerText=offer,additionalDisclaimerText=,couponSlugDisclaimer=[],productImage=[],expirationDate=<null>,startDate=Tue Aug 31 00:00:00 EDT 2004,endDate=Wed Aug 31 00:00:00 EDT 2005,sequenceId=1,printLimit=0,displayExpiration=true]],webLink=[],productImage=[],printable=true,displayRanking=39000,[EMAIL PROTECTED],colorName=<null>,hexCode=<null>],[EMAIL PROTECTED],[EMAIL PROTECTED],couponSlugTypeName=<null>]], exception message is [Attempt to insert duplicate key row in object 'Coupon_Slugs' with unique inde


x 'PK_COUPON_SLUGS'


Deb Nunley

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Persistence question

Reply via email to