Issue while using PostgreSql 8.4.
Hi,
I am using PostgreSql 8.4 for my web application also am using following technology stacks:
1> Java
2> Window XP (OS).
3> JBoss Server4.2.
My issue is, first time I am creating the table and inserting some rows of data. After doing some logic going to delete that table . I am observing application is getting hang while executing statement.execute().
Please suggest me how to fix this issue.
Thanks
Atul Kumar
DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Atul,
My issue is, first time I am creating the table and inserting some rows of
data. After doing some logic going to delete that table . I am observing
application is getting hang while executing statement.execute().Please suggest me how to fix this issue.
I am assuming your statement.execute includes something like
"drop table <yourtable>"
did you make ABSOLUTELY sure that no part of your (or any other running)
programm is still "interested" in that table?
as in "maybe some ORM-mapper still has a transaction open into that table"?
Because dropping a locked table has to wait until the lock is gone to
complete. (esp. if there is an implicit commit in your execute; which may or
may not be, depending on your connection-configuration)
Harald
--
Harald Armin Massa www.2ndQuadrant.com
PostgreSQL Training, Services and Support