agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Explicit transaction control
Date: Thu, 28 Nov 2013 17:18:34 -0800
Message-ID: <CDC3C3AD-42E4-49C3-973B-402083ADC014@me.com> (raw)
In-Reply-To: <15631647725E1342BFD5662917E1063AB45FC5@sydexchtmp4.au.fjanz.com>
References: <15631647725E1342BFD5662917E1063AB45FC5@sydexchtmp4.au.fjanz.com>

By definition, you?re *already* in a transaction because you?re running your Java inside of a database session.  You can use save points <http://is.gd/mQ5ytc; (haven?t tried them in pl/java).  You can save/rollback to them.  But you can?t nest transitions in PostgreSQL, irregardless of the stored procedure language, or DB driver (afaik).

On Nov 28, 2013, at 4:21 PM, Altaf, Muhammad <Muhammad.Altaf at au.fujitsu.com> wrote:

> Hi,
> Currently connection.commit/rollback in pljava throw FeatureNotSupportedException because the function call is already in a transaction so the explicit transaction control is not allowed. I was comparing this with pl/python and found that the later actually allows this by creating sub-transactions, which means technically it should be possible to handle this in pljava but there should be other reasons not to implement it.
>  
> I am willing to implement this feature if there is no philosophical reason that discourages use of explicit transaction controls in pljava, or some backend limitation that does not permit these controls without putting some *hacks*.
>  
> Thoughts?
>  
>  
> Muhammad Altaf
> Fujitsu Australia Software Technology
> www.fastware.com.au
>  
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at lists.pgfoundry.org
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20131128/3aea91c6/attachment.html;

view thread (6+ messages)  latest in thread

Message-ID: <CDC3C3AD-42E4-49C3-973B-402083ADC014@me.com>
Permalink:  ../CDC3C3AD-42E4-49C3-973B-402083ADC014@me.com/
Also on:    postgresql.org/message-id/CDC3C3AD-42E4-49C3-973B-402083ADC014@me.com

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] Explicit transaction control
  In-Reply-To: <CDC3C3AD-42E4-49C3-973B-402083ADC014@me.com>

* 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