db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gmbradford <gmbradf...@alcatel-lucent.com>
Subject curious problem dropping triggers and tables
Date Tue, 13 Apr 2010 21:03:09 GMT

I have a java application that gets a copy of a Derby database that is
transferred to it over a network. (The sending end freezes the DB and then
sends the files over a socket.) The receiving jvm closes the socket and
streams when the database transfer is complete, and then connects to it to
do some sql. The sql includes delete statements, drop trigger statements,
and drop table statements. The delete statements consistently work fine, but
the drop trigger and drop table statements don't always work (sometimes they
do). When they don't, we see SqlSyntaxErrorException, with the complaint
that the trigger or table does not exist. We can't look at the DB while this
jvm is running because it's using embedded mode, but when it's stopped, ij
shows that the triggers and tables exist and from ij the drops work fine.

I'm wondering if anyone has an idea why this might be happening.
View this message in context: http://old.nabble.com/curious-problem-dropping-triggers-and-tables-tp28235584p28235584.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message