Take a look at Global temporary table documentation at:
http://incubator.apache.org/derby/docs/10.0/manuals/reference/sqlj33.html#HDRDECLARETEMPTABLE
The default behavior is to DELETE rows on a commit. So, right after your
insert, a COMMIT is issued, which is deleting the rows. So, you need to
declare the temporary table with ON COMMIT PRESERVE ROWS option.
Otherway to see your insert data is by setting AUTOCOMMIT OFF in IJ,
which prevents issuing a COMMIT. (until you issue a commit)
Thanks, I obviously missed this when I was reading the manual.
-----------------------------------------------------------------
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
Dept. of Computing | ** NON-PROFIT CD FOR CS STUDENTS **
University of Brighton | -- see http://burks.bton.ac.uk
-----------------------------------------------------------------
