search

jeffdeville / penn-orchestra

Automatically exported from code.google.com/p/penn-orchestra
0 stars 0 forks source link

Committing an insertion or deletion via the RelationDataPanel throws SQLException #17

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The Relation panel under the local peer allows one to make an insertion 
into the selected relation. I attempted to insert ('PC444444.44.4', 5888) 
into PLASMO.GENETAX by filling in these values and clicking OK. When I then 
committed this insertion by clicking on the Apply button in the Transaction 
panel there was an SQLException popup window.

Here is the SQL being sent to DB2. It looks like the whole atom string for 
the relation is being added to the SQL instead of just the relation name:

15:28:43,250  INFO SqlDb:877 - INSERT INTO PLASMO."GENETAX(SRC_ID,TAX_ID)"
  VALUES ('PC444444.44.4', 5888)
INSERT INTO PLASMO."GENETAX(SRC_ID,TAX_ID)"
  VALUES ('PC444444.44.4', 5888)

Original issue reported on code.google.com by jwfro...@gmail.com on 27 May 2010 at 7:43

GoogleCodeExporter commented 8 years ago

Original comment by jwfro...@gmail.com on 27 May 2010 at 7:53

GoogleCodeExporter commented 8 years ago 
Bad SQL is also generated when one tries to commit a deletion (See below). In 
this 
case the SQL to do the deletion is fine, but the SQL to insert into _L_DEL is 
faulty. 
So, the tuple is deleted from the base table, but not _L resulting in an 
inconsistent 
state. 

16:17:27,984  INFO SqlDb:877 - INSERT INTO 
PLASMO."TAXNAMES_L_DEL(TAX_ID,TAX_NAME,NAME_CLASS)"
  VALUES (31271, 'Plasmodium chabaudi chabaudi', 'scientific name')
INSERT INTO PLASMO."TAXNAMES_L_DEL(TAX_ID,TAX_NAME,NAME_CLASS)"
  VALUES (31271, 'Plasmodium chabaudi chabaudi', 'scientific name')

Original comment by jwfro...@gmail.com on 27 May 2010 at 8:26

GoogleCodeExporter commented 8 years ago 
The RelationDataPanel will be made read-only in the 0.1 release.

Original comment by jwfro...@gmail.com on 29 May 2010 at 10:10

GoogleCodeExporter commented 8 years ago 
The RelationDataPanel was made read-only.

Original comment by jwfro...@gmail.com on 2 Jul 2010 at 8:12