opensource strategies - Hello World 3 NULL insertion issue
Locked
opensource strategies - Hello World 3 NULL insertion issue
 
|
Hello,
I am currently trying to reconstruct the hello world 3 tutorial on the opensource strategies website ( http://www.opensourcestrategies.com/ofbiz/hello_world3.php ). Everything works fine until the simple minilang service part. I can insert a person into the "guestbook" but when trying to add a hobby for that person, I receive the following error message: 2008-06-06 14:33:09,593 (http-0.0.0.0-8080-Processor4) [ CreateValue.java:66 :ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.GenericEntityException Message: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.))) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.))) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) javax.servlet.http.HttpServlet.service(HttpServlet.java:615) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.)) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:171) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) javax.servlet.http.HttpServlet.service(HttpServlet.java:615) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) javax.servlet.http.HttpServlet.service(HttpServlet.java:615) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) ERROR 23502: Column 'HELLO_PERSON_ID' cannot accept a NULL value. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) javax.servlet.http.HttpServlet.service(HttpServlet.java:615) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2008-06-06 14:33:09,625 (http-0.0.0.0-8080-Processor4) [ TransactionUtil.java:295:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2008-06-06 14:33:09,625 (http-0.0.0.0-8080-Processor4) [ ServiceDispatcher.java:419:ERROR] Service Error [createHelloPersonHobby]: ERROR: Could not complete the Create a Hobby-Person relationship [file:/D:/FHBB/eclips/ofbiz/hot-deploy/hello3/script/org/ofbiz/hello3/Hello3Services.xml#createHelloPersonHobby] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.)))] 2008-06-06 14:33:09,671 (http-0.0.0.0-8080-Processor4) [ TransactionUtil.java:255:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:254) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:236) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) javax.servlet.http.HttpServlet.service(HttpServlet.java:615) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ TransactionUtil.java:265:INFO ] [TransactionUtil.rollback] transaction rolled back 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ ServiceDispatcher.java:467:DEBUG] Sync service [hello3/createHelloPersonHobby] finished in [1110] milliseconds 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ RequestHandler.java:305:ERROR] Request createPersonHobby caused an error with the following message: ERROR: Could not complete the Create a Hobby-Person relationship [file:/D:/FHBB/eclips/ofbiz/hot-deploy/hello3/script/org/ofbiz/hello3/Hello3Services.xml#createHelloPersonHobby] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.)))] 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ RequestHandler.java:425:INFO ] [RequestHandler.doRequest]: Response is a view. sessionId=54565EC6BF09BC60021558752E1B209A.jvm1 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ RequestHandler.java:578:INFO ] servletName=control, view=error sessionId=54565EC6BF09BC60021558752E1B209A.jvm1 2008-06-06 14:33:09,781 (http-0.0.0.0-8080-Processor4) [ ControlServlet.java:256:DEBUG] [[[createPersonHobby] Done rendering page, Servlet Finished- total:1.281,since last([createPersonHobb...):1.281]] That happens when trying to insert the hobby/hobbies via the "See Hobbies" llink on the "Guestbook" page. When doing it via the webtools -> entity data maintenance -> HelloPersonHobby [all] -> Create New, then it works fine and inserts the hobby correctly. Also, the output of that is shown when clicking on a person in the "guestbook". So this works fine, but not through my own link. This is my Hello3Services.xml: <?xml version="1.0" encoding="UTF-8"?> <simple-methods xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/simple-methods.xsd"> <simple-method method-name="createHelloPersonHobby" short-description="Create a Hobby-Person relationship" login-required="false"> <make-value entity-name="HelloPersonHobby" value-name="newEntity"/> <set-nonpk-fields map-name="parameters" value-name="newEntity"/> <set-pk-fields map-name="parameters" value-name="newEntity"/> <create-value value-name="newEntity"/> </simple-method> </simple-methods> I have already looked over and over for spelling mistakes or other obvious errors but can't seem to find any. Maybe some mapping error or missing mapping? (As it seems to submit NULL values). The helloPersonId should be submitted correctly though, as I have set the field to visible and the correct ID shows up on the Hobby-page. Any help appreciated, thanks a lot. |
Re: opensource strategies - Hello World 3 NULL insertion issue
|
|
this is best answered on the opentaps open source forum
https://sourceforge.net/forum/forum.php?forum_id=487771 Ruede,Benjamin sent the following on 6/9/2008 1:05 AM: > Hello, > > I am currently trying to reconstruct the hello world 3 tutorial on the opensource strategies website ( http://www.opensourcestrategies.com/ofbiz/hello_world3.php ). > > Everything works fine until the simple minilang service part. I can insert a person into the "guestbook" but when trying to add a hobby for that person, I receive the following error message: > > > 2008-06-06 14:33:09,593 (http-0.0.0.0-8080-Processor4) [ CreateValue.java:66 :ERROR] > ---- exception report ---------------------------------------------------------- > Exception: org.ofbiz.entity.GenericEntityException > Message: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.))) > ---- stack trace --------------------------------------------------------------- > org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.))) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) > org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) > org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) > org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:615) > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > java.lang.Thread.run(Thread.java:619) > org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.)) > org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:171) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) > org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) > org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) > org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:615) > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > java.lang.Thread.run(Thread.java:619) > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_PERSON_HOBBY (HELLO_PERSON_ID, HELLO_HOBBY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) > org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) > org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) > org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) > org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:615) > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > java.lang.Thread.run(Thread.java:619) > ERROR 23502: Column 'HELLO_PERSON_ID' cannot accept a NULL value. > org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) > org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) > org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) > org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) > org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) > org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:560) > org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) > org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) > org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:615) > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2008-06-06 14:33:09,625 (http-0.0.0.0-8080-Processor4) [ TransactionUtil.java:295:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. > 2008-06-06 14:33:09,625 (http-0.0.0.0-8080-Processor4) [ ServiceDispatcher.java:419:ERROR] Service Error [createHelloPersonHobby]: ERROR: Could not complete the Create a Hobby-Person relationship [file:/D:/FHBB/eclips/ofbiz/hot-deploy/hello3/script/org/ofbiz/hello3/Hello3Services.xml#createHelloPersonHobby] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (SQL Excep > 2008-06-06 14:33:09,671 (http-0.0.0.0-8080-Processor4) [ TransactionUtil.java:255:ERROR] > ---- exception report ---------------------------------------------------------- > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace --------------------------------------------------------------- > java.lang.Exception: Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:254) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:236) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:305) > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:446) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:274) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:615) > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ TransactionUtil.java:265:INFO ] [TransactionUtil.rollback] transaction rolled back > 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ ServiceDispatcher.java:467:DEBUG] Sync service [hello3/createHelloPersonHobby] finished in [1110] milliseconds > 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ RequestHandler.java:305:ERROR] Request createPersonHobby caused an error with the following message: ERROR: Could not complete the Create a Hobby-Person relationship [file:/D:/FHBB/eclips/ofbiz/hot-deploy/hello3/script/org/ofbiz/hello3/Hello3Services.xml#createHelloPersonHobby] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)] (while inserting: [GenericEntity:HelloPersonHobby][createdStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][createdTxStamp,2008-06-06 14:33:08.609(java.sql.Timestamp)][lastUpdatedStamp,2008-06-06 14:33:09.343(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-06 14:33:08.609(j > 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ RequestHandler.java:425:INFO ] [RequestHandler.doRequest]: Response is a view. sessionId=54565EC6BF09BC60021558752E1B209A.jvm1 > 2008-06-06 14:33:09,703 (http-0.0.0.0-8080-Processor4) [ RequestHandler.java:578:INFO ] servletName=control, view=error sessionId=54565EC6BF09BC60021558752E1B209A.jvm1 > 2008-06-06 14:33:09,781 (http-0.0.0.0-8080-Processor4) [ ControlServlet.java:256:DEBUG] [[[createPersonHobby] Done rendering page, Servlet Finished- total:1.281,since last([createPersonHobb...):1.281]] > > > That happens when trying to insert the hobby/hobbies via the "See Hobbies" llink on the "Guestbook" page. When doing it via the webtools -> entity data maintenance -> HelloPersonHobby [all] -> Create New, then it works fine and inserts the hobby correctly. Also, the output of that is shown when clicking on a person in the "guestbook". So this works fine, but not through my own link. > > This is my Hello3Services.xml: > <?xml version="1.0" encoding="UTF-8"?> > > <simple-methods xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/simple-methods.xsd"> > <simple-method method-name="createHelloPersonHobby" short-description="Create a Hobby-Person relationship" login-required="false"> > <make-value entity-name="HelloPersonHobby" value-name="newEntity"/> > <set-nonpk-fields map-name="parameters" value-name="newEntity"/> > <set-pk-fields map-name="parameters" value-name="newEntity"/> > <create-value value-name="newEntity"/> > </simple-method> > </simple-methods> > > > I have already looked over and over for spelling mistakes or other obvious errors but can't seem to find any. Maybe some mapping error or missing mapping? (As it seems to submit NULL values). > The helloPersonId should be submitted correctly though, as I have set the field to visible and the correct ID shows up on the Hobby-page. > > Any help appreciated, thanks a lot. > > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |