When I tried to insert the tuple (7, "Felis Catus", 10, 11) into the OTU table
in the ppodln Orchestra schema, the operation
failed. Here is a log extract:
Error executing SELECT "7" AS OTU_ID, R0.LABEL AS LABEL, R0.OBJ_VERSION AS
OBJ_VERSION,
R0.PPOD_VERSION AS PPOD_VERSION, 1 AS OTU_ID_LN, R0.LABEL_LN AS LABEL_LN,
R0.OBJ_VERSION_LN AS OBJ_VERSION_LN, R0.PPOD_VERSION_LN AS PPOD_VERSION_LN
FROM PPOD1.OTU AS R0
WHERE ((R0.OTU_ID = 7) AND (R0.OTU_ID_LN = 1))
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703,
SQLERRMC: 7
at com.ibm.db2.jcc.b.ig.e(ig.java:1594)
at com.ibm.db2.jcc.b.ig.a(ig.java:1204)
at com.ibm.db2.jcc.c.gb.g(gb.java:140)
at com.ibm.db2.jcc.c.gb.a(gb.java:39)
at com.ibm.db2.jcc.c.w.a(w.java:34)
at com.ibm.db2.jcc.c.vb.f(vb.java:139)
at com.ibm.db2.jcc.b.ig.n(ig.java:1175)
at com.ibm.db2.jcc.b.ig.a(ig.java:1835)
at com.ibm.db2.jcc.b.ig.a(ig.java:476)
at com.ibm.db2.jcc.b.ig.executeQuery(ig.java:460)
at edu.upenn.cis.orchestra.dbms.SqlDb.evaluateQuery(SqlDb.java:960)
at edu.upenn.cis.orchestra.dbms.SqlDb.evalQueryRule(SqlDb.java:1629)
at edu.upenn.cis.orchestra.exchange.BasicEngine.evalQueryRule(BasicEngine.java:555)
at edu.upenn.cis.orchestra.gui.schemas.RelationDataEditorUpdTrans.isKeyUsed(RelationDataEditorUpdTrans.java:266)
at edu.upenn.cis.orchestra.gui.schemas.RelationDataModel.insert(RelationDataModel.java:416)
at edu.upenn.cis.orchestra.gui.schemas.RelationDataInsertionModel.validate(RelationDataInsertionModel.java:116)
at edu.upenn.cis.orchestra.gui.schemas.RelationDataPanel$5.actionPerformed(RelationDataPanel.java:301)
Insertions straight into DB2 are handled correctly.
Original issue reported on code.google.com by jwfro...@gmail.com on 2 Mar 2010 at 8:48
Original issue reported on code.google.com by
jwfro...@gmail.com
on 2 Mar 2010 at 8:48