cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Philip Copeland" <pcopel...@avoka.com>
Subject java.sql.SQLException: No rows for 'payment_items'
Date Fri, 28 Apr 2006 10:44:32 GMT
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
 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message