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
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |