agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

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

view thread (5+ messages)  latest in thread

Message-ID: <802896981@web.de>
Permalink:  ../802896981@web.de/
Also on:    postgresql.org/message-id/802896981@web.de

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] PL/Java functions and JDBC
  In-Reply-To: <802896981@web.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox