[Pljava-dev] PL/Java functions and JDBC

Thomas/Patrick
May I jump in with a question on that point? If each connection uses its
own JVM then
1) Have you any idea what the approximate memory overhead is?
2) How do we force the JVM to unload when a new JAR is released? I am
having fun with that at the moment - I am dropping the connection
entirely which is a bit cumbersome. This is going to give me a problem
when I go live shortly.

Tim Clarke

> -----Original Message-----
> From: pljava-dev-bounces at gborg.postgresql.org
> [mailto:pljava-dev-bounces at gborg.postgresql.org] On Behalf Of
> Thomas Hallgren
> Sent: 22 February 2006 17:52
> To: Patrick Peisker
> Cc: pljava-dev at gborg.postgresql.org
> Subject: Re: [Pljava-dev] PL/Java functions and JDBC
>
>
> 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
> >
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>