Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 75153 invoked from network); 24 Jun 2010 04:16:07 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 24 Jun 2010 04:16:07 -0000 Received: (qmail 71481 invoked by uid 500); 24 Jun 2010 04:16:07 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 71374 invoked by uid 500); 24 Jun 2010 04:16:04 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 71359 invoked by uid 99); 24 Jun 2010 04:16:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jun 2010 04:16:03 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [206.190.36.80] (HELO smtp102.rog.mail.re2.yahoo.com) (206.190.36.80) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 24 Jun 2010 04:15:56 +0000 Received: (qmail 67556 invoked from network); 24 Jun 2010 04:15:35 -0000 Received: from [192.168.1.10] (awillerding@99.242.247.174 with plain) by smtp102.rog.mail.re2.yahoo.com with SMTP; 23 Jun 2010 21:15:35 -0700 PDT X-Yahoo-SMTP: ChVU2eqswBDSFej3Lf4i2Y53UZyBmGcLKhIKvoPeYDa9tHhZulM- X-YMail-OSG: 98v4JrAVM1muWcvzXKQDzzOH.rFs0uUAfj5HPIz0zTNYFNSLvOqANPte8Gorm34_WumxRZarNY_hJ6DyjvqpK.LzX5Et7MqYGtc7QmEW_NOULX7Qr4vy9C2ycUAdmzjotzBzrjCPw9JaBZkjVBKDCOs3E1HgeQ3UCFrd9p1SM8iPZqmNJy8rxiN.z5o5px21cuAY.Fxp2HJ.I09RAcQnbsAMTytkb23uJreHLH1.L_xmmBgqBvn6nVtf.lwZINZjlqsSTo55o1.hhmfnwvdIF.uGl3rxTq_Dq99HcMRIXHhoRt4LuoSzAFLKWZWRg50dGZ3_FgJFRmwl06CQLJHlZlJVRSR2jP.sxvtgAzc4wBpkQyLJw80vTMDXSVFT9izI13czqXe2jn95NH6.n0oxwxF7SfEqvDIQr3geU.QaCA_nWcpIUdxRXZ3HFGU.M23Wr.o4NsM6cG6JZxertMrH7w-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <4C22DBF3.5090808@callistacti.com> Date: Thu, 24 Jun 2010 00:15:47 -0400 From: Andrew Willerding Reply-To: awillerding@callistacti.com Organization: Callista Computer Telephony Inc. User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.9) Gecko/20100423 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: user Subject: DB2 and Identity column Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I am using Cayenne 3.0 and I am having trouble creating a new record with a table that has an identity column on DB2 V9.1. The PK Generation Strategy has been set to Database-generated and the correct field (named ID), however when I first attempted to create a record on this table I kept getting commit errors when cayenne was executing SELECT NEXTVAL FOR ADMINISTRATOR.S_PPVSPECIAL FROM SYSIBM.SYSDUMMY1. I realized that Cayenne was trying to generate a value from the sequence so I created the appropriate S_PPVSPECIAL sequence table which did get past the problem but now I'm getting errors with the actual identity column. Here's the dump: Also why are there two columns for STARTDATE in the Insert/Bind statements? Thanks, Andrew 2010-06-23 23:46:51,977 [http-8084-7] INFO org.apache.cayenne.access.QueryLogger - SELECT NEXTVAL FOR ADMINISTRATOR.S_PPVSPECIAL FROM SYSIBM.SYSDUMMY1 2010-06-23 23:46:51,980 [http-8084-7] INFO org.apache.cayenne.access.QueryLogger - --- will run 1 query. 2010-06-23 23:46:51,980 [http-8084-7] INFO org.apache.cayenne.access.QueryLogger - INSERT INTO ADMINISTRATOR.PPVSPECIAL (ACTIVE, ENDDATE, EVENTID, EXPIRYDT, ID, LANGUAGE, MENUMSGNUM, PROMOMSGNUM, REGION, SLOT, STARTDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2010-06-23 23:46:51,980 [http-8084-7] INFO org.apache.cayenne.access.QueryLogger - [bind: 1->ACTIVE:'Y', 2->ENDDATE:'2010-06-30 23:46:42.664', 3->EVENTID:9036, 4->EXPIRYDT:NULL, 5->LANGUAGE:220, 6->MENUMSGNUM:'E', 7->PROMOMSGNUM:4001, 8->REGION:4000, 9->SLOT:'N', 10->STARTDATE:1, 11->STARTDATE:'2010-06-24 23:46:42.657'] 2010-06-23 23:46:51,985 [http-8084-7] INFO org.apache.cayenne.access.QueryLogger - *** error. com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-798;428C9;ID at com.ibm.db2.jcc.b.ig.e(ig.java:1594) at com.ibm.db2.jcc.b.jg.a(jg.java:1826) at com.ibm.db2.jcc.c.gb.a(gb.java:185) at com.ibm.db2.jcc.c.gb.b(gb.java:82) at com.ibm.db2.jcc.c.w.b(w.java:71) at com.ibm.db2.jcc.c.wb.c(wb.java:225) at com.ibm.db2.jcc.b.jg.bb(jg.java:1817) at com.ibm.db2.jcc.b.jg.eb(jg.java:1878) at com.ibm.db2.jcc.b.jg.jb(jg.java:1977) at com.ibm.db2.jcc.b.jg.a(jg.java:1275) at com.ibm.db2.jcc.b.jg.setObject(jg.java:1241) at org.apache.cayenne.access.types.CharType.setJdbcObject(CharType.java:169) at org.apache.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:542) at org.apache.cayenne.dba.db2.DB2Adapter.bindParameter(DB2Adapter.java:227) at org.apache.cayenne.access.trans.InsertBatchQueryBuilder.bindParameters(InsertBatchQueryBuilder.java:61) at org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:219) at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:91) at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87) at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269) at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:226) at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:144) at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824) at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791) at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850) at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788) at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1106) at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045) at com.callista.shaw.webhotgreetadmin.Windows.WindowEditPPVSpecial.clickSave(WindowEditPPVSpecial.java:362) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:497) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:161) at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1146) at com.vaadin.ui.Button.fireClick(Button.java:366) at com.vaadin.ui.Button.changeVariables(Button.java:188) at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariables(AbstractCommunicationManager.java:1087) at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleUidlRequest(AbstractCommunicationManager.java:587) at com.vaadin.terminal.gwt.server.CommunicationManager.handleUidlRequest(CommunicationManager.java:265) at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:482) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.cayenne.conf.WebApplicationContextFilter.doFilter(WebApplicationContextFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) com.vaadin.event.ListenerMethod$MethodException Cause: org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17] Commit Exception at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:507) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:161) at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1146) at com.vaadin.ui.Button.fireClick(Button.java:366) at com.vaadin.ui.Button.changeVariables(Button.java:188) at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariables(AbstractCommunicationManager.java:1087) at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleUidlRequest(AbstractCommunicationManager.java:587) at com.vaadin.terminal.gwt.server.CommunicationManager.handleUidlRequest(CommunicationManager.java:265) at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:482) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.cayenne.conf.WebApplicationContextFilter.doFilter(WebApplicationContextFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17] Commit Exception at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1134) at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045) at com.callista.shaw.webhotgreetadmin.Windows.WindowEditPPVSpecial.clickSave(WindowEditPPVSpecial.java:362) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:497) ... 27 more Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-798;428C9;ID at com.ibm.db2.jcc.b.ig.e(ig.java:1594) at com.ibm.db2.jcc.b.jg.a(jg.java:1826) at com.ibm.db2.jcc.c.gb.a(gb.java:185) at com.ibm.db2.jcc.c.gb.b(gb.java:82) at com.ibm.db2.jcc.c.w.b(w.java:71) at com.ibm.db2.jcc.c.wb.c(wb.java:225) at com.ibm.db2.jcc.b.jg.bb(jg.java:1817) at com.ibm.db2.jcc.b.jg.eb(jg.java:1878) at com.ibm.db2.jcc.b.jg.jb(jg.java:1977) at com.ibm.db2.jcc.b.jg.a(jg.java:1275) at com.ibm.db2.jcc.b.jg.setObject(jg.java:1241) at org.apache.cayenne.access.types.CharType.setJdbcObject(CharType.java:169) at org.apache.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:542) at org.apache.cayenne.dba.db2.DB2Adapter.bindParameter(DB2Adapter.java:227) at org.apache.cayenne.access.trans.InsertBatchQueryBuilder.bindParameters(InsertBatchQueryBuilder.java:61) at org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:219) at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:91) at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87) at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269) at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:226) at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:144) at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824) at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791) at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850) at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788) at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1106) ... 34 more