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...
Mamta replied to your earlier e-mail on the subject, here is her reply.
http://mail-archives.apache.org/mod_mbox/db-derby-user/200506.mbox/[EMAIL
PROTECTED]
Dan.
