You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Philip Copeland <pc...@avoka.com> on 2006/04/28 12:44:32 UTC
java.sql.SQLException: No rows for 'payment_items'
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
Re: java.sql.SQLException: No rows for 'payment_items'
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Apr 28, 2006, at 6:44 AM, Philip Copeland wrote:
> 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.
Hi Philip,
So I assume you can run the PK query from phpMyAdmin and/or mysql
command line on the failing database and get a row for
'payment_items'? I guess the only other thing that can be wrong is
MySQL driver version - are they the same on all machine?
Andrus
Re: java.sql.SQLException: No rows for 'payment_items'
Posted by Marcin Skladaniec <po...@gmail.com>.
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 <pc...@avoka.com> 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
>
>
>