On Thu, Feb 23, 2012 at 04:03:48PM +0100, Fabian Groffen wrote:
Hi George,
On 23-02-2012 16:55:31 +0200, George Garbis wrote:
PreparedStatement ps2 = con2.prepareStatement("INSERT INTO table1 (a) VALUES (CAST(? AS INTEGER))"); ps2.setInt(1,1); ps2.addBatch();
Statement s1 = con1.createStatement(); s1.execute("CREATE TABLE table2 ( a INTEGER )"); s1.close();
ps2.executeBatch();
Here is the problem. If you perform a schema update/change, MonetDB releases all prepared handles, because they possibly are no longer correct. You need to re-execute your prepare command.
Could this also be the key/asnwer to the issue reported here:
http://sourceforge.net/mailarchive/message.php?msg_id=27318820
?
Stefan
Unfortunately, I see your exception string however is broken, so it carries two SQLSTATEs instead of just one, which would indicate this exact error to you (to easily compare).
Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users