db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: Temporary tables don't work?
Date Sat, 02 Jul 2005 00:26:45 GMT
Hi, John,

Does Mamta's post about temp tables on June 22 help? see
http://mail-archives.apache.org/mod_mbox/db-derby-user/200506.mbox/%3cd9619e4a05062221576e4e634a@mail.gmail.com%3e

If neither of her strategies works for you, please let us know.

regards,

  -jean

John English wrote:
> My application needs to use a temporary table, but they don't seem to
> work with the embedded version. When I insert or update rows the commands
> appear to work, but when I look at the table there is sometimes some of
> the data there and somerimes (more often) not.
> 
> I tried it with ij as a sanity check...
> 
>   ij version 10.0
>   ij> connect 'foo';
>   ij> declare global temporary table t (n varchar(15), u varchar(15)) 
> not logged;
>   0 rows inserted/updated/deleted
>   ij> insert into session.t values('a','b');
>   1 row inserted/updated/deleted
>   ij> select * from session.t;
>   N              |U
>   -------------------------------
> 
>   0 rows selected
>   ij>
> 
> Is this a bug, or am I doing something stupid? Can'y find anything
> like this in the buglist...
> 
> -----------------------------------------------------------------
>  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
> -----------------------------------------------------------------
> 


Mime
View raw message