Problem dropping a table

I have a java application that is trying to dynamically drop a set of 
tables.  Problem is, when it gets to a particular table and I execute 
the "drop table foo cascade" command from a prepared statement, the 
query never returns.  It just hangs indefinitely.  I presume that it is 
waiting on a lock for this table, but there is nothing that I know of 
that should be locking this table.

So, I have two issues - the first, how do I prevent myself from hanging 
indefinitely?  I tried 'setQueryTimeout' on the prepared statement, but 
it doesn't seem to have any effect.  Still hangs indefinitely.

The second, how can I track down what is locking this table?  I presume 
that it is some of my code somewhere... maybe a prepared statement that 
I didn't get closed - but I can't find it.  I've check my code twice for 
any reference to this table, and every use of it is properly closing the 
result sets and the prepared statement.

Any ideas?

Thanks,

Dan


-- 
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/