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 tion 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(j ava.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. > > >
