From: p.peisker at web.de (Patrick Peisker)
Date: Wed, 22 Feb 2006 18:46:06 +0100
Subject: [Pljava-dev] PL/Java functions and JDBC
Message-ID: <802896981@web.de>

Hi,

I hope that mail does not appear two times in the list ...

After testing PL/Java and multithreading, I try something different. My scenario:

- A PL/Java trigger is called before an update is exceuted on a table. This trigger writes something into a queue (singelton pattern)

- A PL/Java function is called from an external application using JDBC. This function should read data from the queue and do something with it

No Problems with:

- Write and read data from the queue

- Call the PL/Java function from the pgAdmin III query tool 

Problems:

- If the PL/Java function is called using JDBC (statement.execute("select functionName();")), the queue is always empty (???)


Any ideas what to do?

thx la lot,

Patrick

______________________________________________________________
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193