Re: Global temporary tables in Java DB -- Apache Derby
- From: Dyreatnews@xxxxxxx
- Date: Wed, 12 Dec 2007 13:05:31 +0100
CJ <spambox1@xxxxxxxxxxxxxx> writes:
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?
Statement.execute(String) doesn't return a result
set. Statement.executeQuery(String) on the other hand, does.
--
dt
Questions about Derby/Java DB? Please visit
http://db.apache.org/derby/derby_mail.html
.
- Follow-Ups:
- References:
- Prev by Date: Re: What does everyone else do for graphically displaying data?
- Next by Date: Re: What does everyone else do for graphically displaying data?
- Previous by thread: Global temporary tables in Java DB -- Apache Derby
- Next by thread: Re: Global temporary tables in Java DB -- Apache Derby
- Index(es):
Relevant Pages
|
