[GENERAL] 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.
Re: [GENERAL] Issue while using PostgreSql 8.4.
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 " 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
[GENERAL] 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.