Thank you Myrna for an excellent reply..................... a) query that runs for a long time..............no I don't think so b) adjust timeout properties......a possibility c) multiple connections..............definitely not :)
I shall add the necessary code to the derby.properties file as suggested and see if I can nail down the problem Thanks again Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/SQL-State-40XL1-tp138053p138118.html Sent from the Apache Derby Users mailing list archive at Nabble.com.