From: | Pat Pascal <pat(dot)pascal(at)networkinv(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | PL/TCLu Function Waiting for External Java/JDBC Application |
Date: | 2012-05-10 23:33:34 |
Message-ID: | 1336692814.10166.151.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am having what appears to be a deadlock in a client application
(i.e. psql) when I use it to query a PL/TCLu function that invokes a
Java application which then uses JDBC to perform a number of queries
back to the same database from where the PL/TCLu function was queried.
It may be convoluted, but is this not allowed/supported in Postgresql?
Since the invoked Java application is a separate process outside the
database, can it not have it's query request satisfied while the the
initial client's query request (which selected the PL/TCL function)
is still not complete? (Note that the Java application appears to be
hanging in it's first query on the database, so it doesn't exit to let
the PL/TCL function complete.)
I am using Postgresql 8.2 and Java 1.6.0_18.
Note that I am NOT able to use PL/Java and move the Java application
inside the database as a function (assuming that would solve the
problem).
Thanks for any help.
Pat
From | Date | Subject | |
---|---|---|---|
Next Message | Jayadevan M | 2012-05-11 03:27:00 | Re: I am NOT a programmer! |
Previous Message | Merlin Moncure | 2012-05-10 17:07:10 | Re: Geometric data type for an arc. |