DB2 and Identity column

From: Andrew Willerding (awillerdin..allistacti.com)
Date: Thu Jun 24 2010 - 04:13:58 UTC

  • Next message: Andrew Willerding: "DB2 and Identity column"

    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



    This archive was generated by hypermail 2.0.0 : Thu Jun 24 2010 - 04:14:24 UTC