agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] PL/Java functions and JDBC
Date: Fri, 24 Feb 2006 18:13:14 -0000
Message-ID: <44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3> (raw)

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
> 

view thread (5+ messages)  latest in thread

Message-ID: <44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3>
Permalink:  ../44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3/
Also on:    postgresql.org/message-id/44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3

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: <44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3>

* 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