agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] PL/Java functions and JDBC
Date: Wed, 22 Feb 2006 18:51:48 +0100
Message-ID: <43FCA4B4.5010504@tada.se> (raw)
In-Reply-To: <802896981@web.de>
References: <802896981@web.de>
Patrick,
I'm not sure this is your problem, but each connection uses it's own
JVM. So if you use one connection to populate an in-memory queue,
there's no way you can read that queue from another connection. The only
way to accomplish that is to use a persistent queue.
Regards,
Thomas Hallgren
Patrick Peisker wrote:
> 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
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
view thread (5+ messages) latest in thread
Message-ID: <43FCA4B4.5010504@tada.se>
Permalink: ../43FCA4B4.5010504@tada.se/
Also on: postgresql.org/message-id/43FCA4B4.5010504@tada.se
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: <43FCA4B4.5010504@tada.se>
* 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