Postgres Pro
Downloads
Home   >   mailing lists

Thread: Issue while using PostgreSql 8.4.

Issue while using PostgreSql 8.4.

From
Atul Kumar
Date:

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.

Re: Issue while using PostgreSql 8.4.

From
Harald Armin Massa
Date:
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