Re: problem with stored procedure ,transaction and jdbc

have you considered to enclose both stored procedures in a transaction inside
another stored procedure, and call just one from the java code, something
like :

CREATE FUNCTION stored_procedure_3()....
BEGIN;
BEGIN TRANSACTION;
PERFORM .. call strored procedure 1
PERFORM .. call strored procedure 2
COMMIT;
END;
' LANGUAGE plpgsql;

and your java code would be :

set autocommit to false
call strored procedure 3

Just and idea... ok ? I'm pretty new to java and postgresql too, so ... you
know...

Hoe this help.

Andres
>On Friday 12 August 2005 05:09 pm, Dave Cramer wrote:
> Yes you can enclose two stored procedures inside a transaction.
>
> Can you call the second one on it's own without the first one without
> getting an exception ?
>
> Dave
>
> On 12-Aug-05, at 12:47 PM, Jiangyi wrote:
> > Hello everyone,
> > I have a probem with stored procedure ,transaction and JDBC.
> > i am confused with the relation between stored procedure,
> > transcation and jdbc.
> >
> > supposed I have code looks like:
> >
> > set autocommit to false
> > call strored procedure 1
> > call strored procedure 2
> > when I call the second stored procedure, exception raised
> > so I close the connection and the callable statement.
> >
> > My question is can I enclose the two stored procedure in a parent
> > transcaton
> > use JDBC ? If not , why?
> >
> > Regards
> > Jiang
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--

Andres Ledesma
=================