agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] pljava @ itpug (italy) 2010
5+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] pljava @ itpug (italy) 2010
@ 2010-12-13 07:34
2010-12-13 12:57 ` [Pljava-dev] pljava @ itpug (italy) 2010
0 siblings, 1 reply; 5+ messages in thread
From: @ 2010-12-13 07:34 UTC (permalink / raw)
Hi all,
during the 2010 edition of the Italian PGDay (www.pgday.it) I gave a brief
tutorial to PL/Java that reached a good success and interest. So, first of all,
thank you all PL/Java developers for this great piece of code.
Now a question that arise was if PL/Java is able to handle a distributed
transaction, let say from an application server, and to "forward" back
information about such transaction to the currently running backend. In my
opinion this is not possible, or at least it is all on the developer's
shoulder that have to deal with such details. However, I'd like to have
comments from other users.
Thanks,
Luca
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 07:34 [Pljava-dev] pljava @ itpug (italy) 2010
@ 2010-12-13 12:57 `
2010-12-13 13:37 ` [Pljava-dev] pljava @ itpug (italy) 2010
0 siblings, 1 reply; 5+ messages in thread
From: @ 2010-12-13 12:57 UTC (permalink / raw)
Hi Luca,
On Mon, Dec 13, 2010 at 7:34 AM, Luca Ferrari <fluca1978 at infinito.it> wrote:
> Hi all,
> during the 2010 edition of the Italian PGDay (www.pgday.it) I gave a brief
> tutorial to PL/Java that reached a good success and interest. So, first of all,
> thank you all PL/Java developers for this great piece of code.
You're welcome.
> Now a question that arise was if PL/Java is able to handle a distributed
> transaction, let say from an application server, and to "forward" back
> information about such transaction to the currently running backend. In my
> opinion this is not possible, or at least it is all on the developer's
> shoulder that have to deal with such details. However, I'd like to have
> comments from other users.
Could you clarify a little, I'm not following. PL/Java runs in the
backend already.
Johann
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 07:34 [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 12:57 ` [Pljava-dev] pljava @ itpug (italy) 2010
@ 2010-12-13 13:37 `
2010-12-13 14:26 ` [Pljava-dev] pljava @ itpug (italy) 2010
0 siblings, 1 reply; 5+ messages in thread
From: @ 2010-12-13 13:37 UTC (permalink / raw)
On Monday, December 13, 2010 01:57:48 pm Johann 'Myrkraverk' Oskarsson's cat
walking on the keyboard wrote:
> Could you clarify a little, I'm not following. PL/Java runs in the
> backend already.
>
Let say pl7java is executing in a transaction scope on the postgresql server,
and connects/starts a distributed transaction on another application server.
Such transaction is totally managed by the pl/java process, but the backend
does not see it at all, right? Is there a way to make the distributed
transaction started from pl/java available on the backed? So if the former
aborts the second does too. My quick answer is no, but I ask to be sure.
Thanks,
Luca
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 07:34 [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 12:57 ` [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 13:37 ` [Pljava-dev] pljava @ itpug (italy) 2010
@ 2010-12-13 14:26 `
2010-12-13 14:59 ` [Pljava-dev] pljava @ itpug (italy) 2010
0 siblings, 1 reply; 5+ messages in thread
From: @ 2010-12-13 14:26 UTC (permalink / raw)
Hi Luca,
Wouldn't it be better to manage distributed transactions in the middle tier on top of it all? After all, you are already
*in* a transaction when you execute your PL/Java code and that's a transaction that you cannot connect other resources to.
When writing PL/Java, I did not intend for distributed transactions to be orchestrated from within it for sure. That's
not a recommended use-case. In fact, I would strongly advice against it.
Regards,
Thomas Hallgren
On 2010-12-13 14:37, Luca Ferrari wrote:
> On Monday, December 13, 2010 01:57:48 pm Johann 'Myrkraverk' Oskarsson's cat
> walking on the keyboard wrote:
>
>> Could you clarify a little, I'm not following. PL/Java runs in the
>> backend already.
>>
>
> Let say pl7java is executing in a transaction scope on the postgresql server,
> and connects/starts a distributed transaction on another application server.
> Such transaction is totally managed by the pl/java process, but the backend
> does not see it at all, right? Is there a way to make the distributed
> transaction started from pl/java available on the backed? So if the former
> aborts the second does too. My quick answer is no, but I ask to be sure.
>
> Thanks,
> Luca
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 07:34 [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 12:57 ` [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 13:37 ` [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 14:26 ` [Pljava-dev] pljava @ itpug (italy) 2010
@ 2010-12-13 14:59 `
0 siblings, 0 replies; 5+ messages in thread
From: @ 2010-12-13 14:59 UTC (permalink / raw)
On Monday, December 13, 2010 03:26:42 pm Thomas Hallgren's cat walking on the
keyboard wrote:
> Hi Luca,
>
> Wouldn't it be better to manage distributed transactions in the middle tier
> on top of it all? After all, you are already *in* a transaction when you
> execute your PL/Java code and that's a transaction that you cannot connect
> other resources to.
>
> When writing PL/Java, I did not intend for distributed transactions to be
> orchestrated from within it for sure. That's not a recommended use-case.
> In fact, I would strongly advice against it.
So did I! And this is what I answered, but I was curious to know if it was
correct at all.
Thanks,
Luca
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-12-13 14:59 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-13 07:34 [Pljava-dev] pljava @ itpug (italy) 2010
2010-12-13 12:57 `
2010-12-13 13:37 `
2010-12-13 14:26 `
2010-12-13 14:59 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox