Is that the only table which is causing problems ? Does your xxx.driver.xmlfile point to the right database ? Do you have only one database to which you connect from different computers, or different databases ?
If the latter maybe you can try dumping whole database from one of development machines and restore it on test server, and see if problem persist. Cheers Marcin On 4/28/06, Philip Copeland <[EMAIL PROTECTED]> wrote: > > Hi, > > I've been having the strangest problem for the past week that I've not > been able to resolve. > > The problem is only occuring on our test servers (2 of them ) - I cannot > reproduce it on my development machine. > > The problem is I have a table called "payment_items" and whenever I try > to insert a row(s) into this table I get a Cayenne exception - which > says the root cause is > > Caused by: java.sql.SQLException: No rows for 'payment_items' > > As I say the code works fine on my machine and another developers > computer - its just failing on our 2 test servers. We are all using > MySQL and are using Cayenne 1.2B2 - although we initially saw the > problem in 1.2M8. > > I have recreated the payment_items table on the test machines and have > double checked that there is a row in the auto_pk_support table for > "payment_items". From what I can tell the select next_id from > auto_pk_support query is failing - but I don't understand why? > > Any suggestions? > > Thanks > > Philip > > > > > Here is the full exception log > > ----------------------------------------------------------------- > > 2006-04-28 16:24:11,845 INFO [STDOUT] Created New Payment Item OK. > 2006-04-28 16:24:11,845 INFO > [org.objectstyle.cayenne.access.QueryLogger] --- transaction started. > 2006-04-28 16:24:11,861 INFO > [org.objectstyle.cayenne.access.QueryLogger] LOCK TABLES AUTO_PK_SUPPORT > WRITE > 2006-04-28 16:24:11,861 INFO > [org.objectstyle.cayenne.access.QueryLogger] SELECT NEXT_ID FROM > AUTO_PK_SUPPORT WHERE TABLE_NAME = 'payment_items' > 2006-04-28 16:24:11,861 INFO > [org.objectstyle.cayenne.access.QueryLogger] UNLOCK TABLES > 2006-04-28 16:24:11,877 INFO [STDOUT] ---------------Application > Exception------------------------------------- > 2006-04-28 16:24:11,877 INFO [STDOUT] Name =CannotCommitTransaction > 2006-04-28 16:24:11,877 INFO [STDOUT] Message =[v.1.2B2 April 17 2006] > Commit Exception > 2006-04-28 16:24:11,877 INFO [STDOUT] Context = > 2006-04-28 16:24:11,877 INFO [STDOUT] User Message =An unexpected error > has occured and the problem has been logged. You can retry or > alternativly contact support and request further assistance. > 2006-04-28 16:24:11,877 INFO [STDOUT] User Message Extra =Unable to > save PaymentLog details. > 2006-04-28 16:24:11,877 INFO [STDOUT] Fix Recommendation =Cayenne > commit error. Unable to commit changes to PaymentLog. This error should > never occur. > 2006-04-28 16:24:11,877 INFO [STDOUT] > com.avoka.smartform.util.ApplicationException: [v.1.2B2 April 17 2006] > Commit Exception > 2006-04-28 16:24:11,877 INFO [STDOUT] at > com.avoka.smartform.util.AvokaCayenneUtils.commitChanges(Lorg.objectstyl > e.cayenne.access.DataContext;Ljava.lang.String;Ljava.lang.String;Lcom.av > oka.smartform.util.UserDetails;)V(AvokaCayenneUtils.java:35) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > com.avoka.smartform.commweb.CommWebService.processDigitalOrder(Ljavax.se > rvlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lc > om.avoka.smartform.entity.SubmissionLog;Lcom.avoka.smartform.util.XPath; > Lcom.avoka.smartform.util.UserDetails;)V(CommWebService.java:74) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > com.avoka.smartform.servlet.SubmissionServlet.executeRequest(Ljavax.serv > let.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(S > ubmissionServlet.java:215) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > com.avoka.smartform.servlet.AvokaServletBase.doPost(Ljavax.servlet.http. > HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(AvokaServl > etBase.java:77) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRe > quest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:717) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Lja > vax.servlet.ServletResponse;)V(HttpServlet.java:810) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:237) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.objectstyle.cayenne.conf.WebApplicationContextFilter.doFilter(Ljavax > .servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.Fi > lterChain;)V(WebApplicationContextFilter.java:181) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:186) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.StandardWrapperValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardWrapperValve.java:214) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invokeInternal(Lorg.apache > .catalina.Wrapper;Lorg.apache.catalina.Request;Lorg.apache.catalina.Resp > onse;)V(StandardContextValve.java:198) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardContextValve.java:152) > 2006-04-28 16:24:11,877 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Lorg.apach > e.catalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Va > lveContext;)V(SecurityAssociationValve.java:72) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(Lorg.apache.c > atalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Valve > Context;)V(JBossSecurityMgrRealm.java:275) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardHostValve.invoke(Lorg.apache.catalina.R > equest;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext;) > V(StandardHostValve.java:137) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.valves.ErrorReportValve.invoke(Lorg.apache.catalina. > Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext; > )V(ErrorReportValve.java:117) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardEngineValve.invoke(Lorg.apache.catalina > .Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext > ;)V(StandardEngineValve.java:109) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.ContainerBase.invoke(Lorg.apache.catalina.Reque > st;Lorg.apache.catalina.Response;)V(ContainerBase.java:929) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.coyote.tomcat5.CoyoteAdapter.service(Lorg.apache.coyote.Reque > st;Lorg.apache.coyote.Response;)V(CoyoteAdapter.java:160) > 2006-04-28 16:24:11,986 INFO [STDOUT] Caused by: > org.objectstyle.cayenne.CayenneRuntimeException: [v.1.2B2 April 17 2006] > Commit Exception > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.flushToParent(Z)Lorg.objectst > yle.cayenne.graph.GraphDiff;(DataContext.java:1245) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.commitChanges()V(DataContext. > java:1121) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > com.avoka.smartform.util.AvokaCayenneUtils.commitChanges(Lorg.objectstyl > e.cayenne.access.DataContext;Ljava.lang.String;Ljava.lang.String;Lcom.av > oka.smartform.util.UserDetails;)V(AvokaCayenneUtils.java:32) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > com.avoka.smartform.commweb.CommWebService.processDigitalOrder(Ljavax.se > rvlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lc > om.avoka.smartform.entity.SubmissionLog;Lcom.avoka.smartform.util.XPath; > Lcom.avoka.smartform.util.UserDetails;)V(CommWebService.java:74) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > com.avoka.smartform.servlet.SubmissionServlet.executeRequest(Ljavax.serv > let.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(S > ubmissionServlet.java:215) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > com.avoka.smartform.servlet.AvokaServletBase.doPost(Ljavax.servlet.http. > HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(AvokaServl > etBase.java:77) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRe > quest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:717) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Lja > vax.servlet.ServletResponse;)V(HttpServlet.java:810) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:237) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.objectstyle.cayenne.conf.WebApplicationContextFilter.doFilter(Ljavax > .servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.Fi > lterChain;)V(WebApplicationContextFilter.java:181) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:186) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardWrapperValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardWrapperValve.java:214) > 2006-04-28 16:24:11,986 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invokeInternal(Lorg.apache > .catalina.Wrapper;Lorg.apache.catalina.Request;Lorg.apache.catalina.Resp > onse;)V(StandardContextValve.java:198) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardContextValve.java:152) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Lorg.apach > e.catalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Va > lveContext;)V(SecurityAssociationValve.java:72) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(Lorg.apache.c > atalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Valve > Context;)V(JBossSecurityMgrRealm.java:275) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardHostValve.invoke(Lorg.apache.catalina.R > equest;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext;) > V(StandardHostValve.java:137) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.valves.ErrorReportValve.invoke(Lorg.apache.catalina. > Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext; > )V(ErrorReportValve.java:117) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardEngineValve.invoke(Lorg.apache.catalina > .Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext > ;)V(StandardEngineValve.java:109) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,002 INFO [STDOUT] Caused by: java.sql.SQLException: > No rows for 'payment_items' > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.getPrimaryKey(Ljava.s > ql.Statement;Ljava.lang.String;)I(MySQLPkGenerator.java:182) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.pkFromDatabase(Lorg.o > bjectstyle.cayenne.access.DataNode;Lorg.objectstyle.cayenne.map.DbEntity > ;)I(MySQLPkGenerator.java:97) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.dba.JdbcPkGenerator.generatePkForDbEntity(Lorg.o > bjectstyle.cayenne.access.DataNode;Lorg.objectstyle.cayenne.map.DbEntity > ;)Ljava.lang.Object;(JdbcPkGenerator.java:326) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainInsertBucket.createPermIdsForOb > jEntity(Lorg.objectstyle.cayenne.map.ObjEntity;Ljava.util.List;)V(DataDo > mainInsertBucket.java:194) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainInsertBucket.appendQueriesInter > nal(Ljava.util.Collection;)V(DataDomainInsertBucket.java:122) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainSyncBucket.appendQueries(Ljava. > util.Collection;)V(DataDomainSyncBucket.java:108) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainFlushAction.preprocess(Lorg.obj > ectstyle.cayenne.access.DataContext;Lorg.objectstyle.cayenne.graph.Graph > Diff;)V(DataDomainFlushAction.java:211) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainFlushAction.flush(Lorg.objectst > yle.cayenne.access.DataContext;Lorg.objectstyle.cayenne.graph.GraphDiff; > )Lorg.objectstyle.cayenne.graph.GraphDiff;(DataDomainFlushAction.java:16 > 7) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain.onSyncFlush(Lorg.objectstyle.c > ayenne.ObjectContext;Lorg.objectstyle.cayenne.graph.GraphDiff;)Lorg.obje > ctstyle.cayenne.graph.GraphDiff;(DataDomain.java:827) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain$2.transform(Ljava.lang.Object; > )Ljava.lang.Object;(DataDomain.java:798) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain.runInTransaction(Lorg.apache.c > ommons.collections.Transformer;)Ljava.lang.Object;(DataDomain.java:853) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain.onSync(Lorg.objectstyle.cayenn > e.ObjectContext;Lorg.objectstyle.cayenne.graph.GraphDiff;I)Lorg.objectst > yle.cayenne.graph.GraphDiff;(DataDomain.java:795) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.flushToParent(Z)Lorg.objectst > yle.cayenne.graph.GraphDiff;(DataContext.java:1217) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.commitChanges()V(DataContext. > java:1121) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > com.avoka.smartform.util.AvokaCayenneUtils.commitChanges(Lorg.objectstyl > e.cayenne.access.DataContext;Ljava.lang.String;Ljava.lang.String;Lcom.av > oka.smartform.util.UserDetails;)V(AvokaCayenneUtils.java:32) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > com.avoka.smartform.commweb.CommWebService.processDigitalOrder(Ljavax.se > rvlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lc > om.avoka.smartform.entity.SubmissionLog;Lcom.avoka.smartform.util.XPath; > Lcom.avoka.smartform.util.UserDetails;)V(CommWebService.java:74) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > com.avoka.smartform.servlet.SubmissionServlet.executeRequest(Ljavax.serv > let.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(S > ubmissionServlet.java:215) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > com.avoka.smartform.servlet.AvokaServletBase.doPost(Ljavax.servlet.http. > HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(AvokaServl > etBase.java:77) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRe > quest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:717) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Lja > vax.servlet.ServletResponse;)V(HttpServlet.java:810) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:237) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.objectstyle.cayenne.conf.WebApplicationContextFilter.doFilter(Ljavax > .servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.Fi > lterChain;)V(WebApplicationContextFilter.java:181) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:186) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:12,002 INFO [STDOUT] at > org.apache.catalina.core.StandardWrapperValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardWrapperValve.java:214) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invokeInternal(Lorg.apache > .catalina.Wrapper;Lorg.apache.catalina.Request;Lorg.apache.catalina.Resp > onse;)V(StandardContextValve.java:198) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardContextValve.java:152) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Lorg.apach > e.catalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Va > lveContext;)V(SecurityAssociationValve.java:72) > 2006-04-28 16:24:12,017 INFO [STDOUT] Cause=[v.1.2B2 April 17 2006] > Commit Exception > 2006-04-28 16:24:12,017 INFO [STDOUT] > org.objectstyle.cayenne.CayenneRuntimeException: [v.1.2B2 April 17 2006] > Commit Exception > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.flushToParent(Z)Lorg.objectst > yle.cayenne.graph.GraphDiff;(DataContext.java:1245) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.commitChanges()V(DataContext. > java:1121) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > com.avoka.smartform.util.AvokaCayenneUtils.commitChanges(Lorg.objectstyl > e.cayenne.access.DataContext;Ljava.lang.String;Ljava.lang.String;Lcom.av > oka.smartform.util.UserDetails;)V(AvokaCayenneUtils.java:32) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > com.avoka.smartform.commweb.CommWebService.processDigitalOrder(Ljavax.se > rvlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lc > om.avoka.smartform.entity.SubmissionLog;Lcom.avoka.smartform.util.XPath; > Lcom.avoka.smartform.util.UserDetails;)V(CommWebService.java:74) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > com.avoka.smartform.servlet.SubmissionServlet.executeRequest(Ljavax.serv > let.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(S > ubmissionServlet.java:215) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > com.avoka.smartform.servlet.AvokaServletBase.doPost(Ljavax.servlet.http. > HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(AvokaServl > etBase.java:77) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRe > quest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:717) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Lja > vax.servlet.ServletResponse;)V(HttpServlet.java:810) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:237) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.objectstyle.cayenne.conf.WebApplicationContextFilter.doFilter(Ljavax > .servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.Fi > lterChain;)V(WebApplicationContextFilter.java:181) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:186) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:12,017 INFO [STDOUT] at > org.apache.catalina.core.StandardWrapperValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardWrapperValve.java:214) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invokeInternal(Lorg.apache > .catalina.Wrapper;Lorg.apache.catalina.Request;Lorg.apache.catalina.Resp > onse;)V(StandardContextValve.java:198) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardContextValve.java:152) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Lorg.apach > e.catalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Va > lveContext;)V(SecurityAssociationValve.java:72) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(Lorg.apache.c > atalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Valve > Context;)V(JBossSecurityMgrRealm.java:275) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardHostValve.invoke(Lorg.apache.catalina.R > equest;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext;) > V(StandardHostValve.java:137) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.valves.ErrorReportValve.invoke(Lorg.apache.catalina. > Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext; > )V(ErrorReportValve.java:117) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :102) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardEngineValve.invoke(Lorg.apache.catalina > .Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContext > ;)V(StandardEngineValve.java:109) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,111 INFO [STDOUT] Caused by: java.sql.SQLException: > No rows for 'payment_items' > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.getPrimaryKey(Ljava.s > ql.Statement;Ljava.lang.String;)I(MySQLPkGenerator.java:182) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.pkFromDatabase(Lorg.o > bjectstyle.cayenne.access.DataNode;Lorg.objectstyle.cayenne.map.DbEntity > ;)I(MySQLPkGenerator.java:97) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.objectstyle.cayenne.dba.JdbcPkGenerator.generatePkForDbEntity(Lorg.o > bjectstyle.cayenne.access.DataNode;Lorg.objectstyle.cayenne.map.DbEntity > ;)Ljava.lang.Object;(JdbcPkGenerator.java:326) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainInsertBucket.createPermIdsForOb > jEntity(Lorg.objectstyle.cayenne.map.ObjEntity;Ljava.util.List;)V(DataDo > mainInsertBucket.java:194) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainInsertBucket.appendQueriesInter > nal(Ljava.util.Collection;)V(DataDomainInsertBucket.java:122) > 2006-04-28 16:24:12,111 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainSyncBucket.appendQueries(Ljava. > util.Collection;)V(DataDomainSyncBucket.java:108) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainFlushAction.preprocess(Lorg.obj > ectstyle.cayenne.access.DataContext;Lorg.objectstyle.cayenne.graph.Graph > Diff;)V(DataDomainFlushAction.java:211) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomainFlushAction.flush(Lorg.objectst > yle.cayenne.access.DataContext;Lorg.objectstyle.cayenne.graph.GraphDiff; > )Lorg.objectstyle.cayenne.graph.GraphDiff;(DataDomainFlushAction.java:16 > 7) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain.onSyncFlush(Lorg.objectstyle.c > ayenne.ObjectContext;Lorg.objectstyle.cayenne.graph.GraphDiff;)Lorg.obje > ctstyle.cayenne.graph.GraphDiff;(DataDomain.java:827) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain$2.transform(Ljava.lang.Object; > )Ljava.lang.Object;(DataDomain.java:798) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain.runInTransaction(Lorg.apache.c > ommons.collections.Transformer;)Ljava.lang.Object;(DataDomain.java:853) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataDomain.onSync(Lorg.objectstyle.cayenn > e.ObjectContext;Lorg.objectstyle.cayenne.graph.GraphDiff;I)Lorg.objectst > yle.cayenne.graph.GraphDiff;(DataDomain.java:795) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.flushToParent(Z)Lorg.objectst > yle.cayenne.graph.GraphDiff;(DataContext.java:1217) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.access.DataContext.commitChanges()V(DataContext. > java:1121) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > com.avoka.smartform.util.AvokaCayenneUtils.commitChanges(Lorg.objectstyl > e.cayenne.access.DataContext;Ljava.lang.String;Ljava.lang.String;Lcom.av > oka.smartform.util.UserDetails;)V(AvokaCayenneUtils.java:32) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > com.avoka.smartform.commweb.CommWebService.processDigitalOrder(Ljavax.se > rvlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lc > om.avoka.smartform.entity.SubmissionLog;Lcom.avoka.smartform.util.XPath; > Lcom.avoka.smartform.util.UserDetails;)V(CommWebService.java:74) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > com.avoka.smartform.servlet.SubmissionServlet.executeRequest(Ljavax.serv > let.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(S > ubmissionServlet.java:215) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > com.avoka.smartform.servlet.AvokaServletBase.doPost(Ljavax.servlet.http. > HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(AvokaServl > etBase.java:77) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRe > quest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:717) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Lja > vax.servlet.ServletResponse;)V(HttpServlet.java:810) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:237) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.objectstyle.cayenne.conf.WebApplicationContextFilter.doFilter(Ljavax > .servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.Fi > lterChain;)V(WebApplicationContextFilter.java:181) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax. > servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilt > erChain.java:186) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax.servlet. > ServletRequest;Ljavax.servlet.ServletResponse;)V(ApplicationFilterChain. > java:157) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.StandardWrapperValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardWrapperValve.java:214) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.StandardPipeline.invoke(Lorg.apache.catalina.Re > quest;Lorg.apache.catalina.Response;)V(StandardPipeline.java:520) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invokeInternal(Lorg.apache > .catalina.Wrapper;Lorg.apache.catalina.Request;Lorg.apache.catalina.Resp > onse;)V(StandardContextValve.java:198) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.StandardContextValve.invoke(Lorg.apache.catalin > a.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.ValveContex > t;)V(StandardContextValve.java:152) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.apache.catalina.core.StandardValveContext.invokeNext(Lorg.apache.cat > alina.Request;Lorg.apache.catalina.Response;)V(StandardValveContext.java > :104) > 2006-04-28 16:24:12,220 INFO [STDOUT] at > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Lorg.apach > e.catalina.Request;Lorg.apache.catalina.Response;Lorg.apache.catalina.Va > lveContext;)V(SecurityAssociationValve.java:72) > 2 > > >
