db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English ...@brighton.ac.uk>
Subject Re: Temporary tables don't work?
Date Sat, 02 Jul 2005 14:19:24 GMT
> 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:je@brighton.ac.uk
  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

View raw message