Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Java Databases > Global tem****a...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 9 Topic 3616 of 3825
Post > Topic >>

Global tem****ary tables in Java DB -- Apache Derby

by CJ <spambox1@[EMAIL PROTECTED] > Dec 11, 2007 at 12:26 PM

I can't seem to use "declare create tem****ary 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 TEM****ARY 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
 




 9 Posts in Topic:
Global temporary tables in Java DB -- Apache Derby
CJ <spambox1@[EMAIL PR  2007-12-11 12:26:31 
Re: Global temporary tables in Java DB -- Apache Derby
Dyreatnews@[EMAIL PROTECT  2007-12-12 13:05:31 
Re: Global temporary tables in Java DB -- Apache Derby
CJ <spambox1@[EMAIL PR  2007-12-14 07:07:40 
Re: Global temporary tables in Java DB -- Apache Derby
Dyreatnews@[EMAIL PROTECT  2007-12-14 18:26:36 
Re: Global temporary tables in Java DB -- Apache Derby
CJ <spambox1@[EMAIL PR  2007-12-14 14:28:20 
Re: Global temporary tables in Java DB -- Apache Derby
Lew <lew@[EMAIL PROTEC  2007-12-14 19:17:09 
Re: Global temporary tables in Java DB -- Apache Derby
Dyreatnews@[EMAIL PROTECT  2007-12-15 20:05:10 
Re: Global temporary tables in Java DB -- Apache Derby
CJ <spambox1@[EMAIL PR  2007-12-17 12:01:55 
Re: Global temporary tables in Java DB -- Apache Derby
Dyreatnews@[EMAIL PROTECT  2007-12-18 17:21:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Sep 7 2:45:47 CDT 2008.