From: Arnaud K. <ax...@sa...> - 2003-10-01 16:18:41
|
Hi Jonathan We've found an error with the boolean queries. It happens when a query goes over timeout. The statement is reclaimed (see code in reclaimLongRunningStatements() method of the Connection class) and the cache table is not created. But this cache table is expected to exist and we get a "table or view does not exist" exception. So every time someone is trying to do the same query again the code tries to query the cache table and as a consequence, it doesn't return any result. I don't know if I've made myself clear but I can give you the errput if you want. Do you know how to fix this ? Would it be possible to insert a rollback statement in the code when the statement is reclaimed ? cheers Arnaud |