cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Willerding <awillerd...@callistacti.com>
Subject DB2 and Identity column
Date Thu, 24 Jun 2010 04:15:47 GMT
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


Mime
View raw message