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
This archive was generated by hypermail 2.0.0 : Fri Apr 28 2006 - 06:45:14 EDT