Global temporary tables in Java DB -- Apache Derby
- From: CJ <spambox1@xxxxxxxxxxxxxx>
- Date: Tue, 11 Dec 2007 12:26:31 -0800 (PST)
I can't seem to use "declare create temporary table" to function in
Java DB, JVM 1.6.0_03 Linux. After starting an embedded Derby server,
I issue the following;
stmt.execute("SET SCHEMA myschema");
stmt.execute("DECLARE CREATE TEMPORARY TABLE SESSION.mytable (fld INT
NOT NULL) NOT LOGGED");
stmt.execute("INSERT INTO SESSION.mytable VALUES(1)");
System.err.println(stmt.getUpdateCount());
stmt.execute("SELECT * FROM SESSION.mytable");
The getUpdateCount after insert is one (1), however the query does not
return a resultset. What am I doing incorrectly?
cj
.
- Follow-Ups:
- Re: Global temporary tables in Java DB -- Apache Derby
- From: Dyreatnews
- Re: Global temporary tables in Java DB -- Apache Derby
- Prev by Date: [Announce] Stylus Studio 2008 Now Available
- Next by Date: Re: What does everyone else do for graphically displaying data?
- Previous by thread: [Announce] Stylus Studio 2008 Now Available
- Next by thread: Re: Global temporary tables in Java DB -- Apache Derby
- Index(es):
Relevant Pages
|
