[Pljava-dev] java.sql.SQLException: An attempt was made to call a PostgreSQL backend function while main thread was not in the JVM

From: pmichalek at click(dot)cz ( Petr Michálek )
To:
Subject: [Pljava-dev] java.sql.SQLException: An attempt was made to call a PostgreSQL backend function while main thread was not in the JVM
Date: 2004-09-19 16:00:24
Message-ID: 414DAD18.6080405@click.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hi!

I am repeatedly calling SQL function, and trigger function fired by
"UPDATE" in sql function crashes with folowing exception. Crash is
reliable after 100 calls.

java.sql.SQLException: ERROR: java.sql.SQLException: An attempt was made
to call a PostgreSQL backend function while main thread was not in the JVM
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1130)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:933)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:139)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:346)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:294)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:285)

Exception is generated by native method in class
org.postgresql.pljava.internal.TriggerData function

public boolean isFiredAfter() throws SQLException
{
synchronized(Backend.THREADLOCK)
{
>>> return this._isFiredAfter();
}
}

Does anybody knows, what is wrong?

Petr Michalek

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2004-09-19 16:19:04 [Pljava-dev] java.sql.SQLException: An attempt was made to call a PostgreSQL backend function while main thread was not in the JVM
Previous Message Thomas Hallgren 2004-09-17 14:32:08 [Pljava-dev] Problem with jdbc driver