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,[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,[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'
][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=Tue 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]
