Re: problem with stored procedure ,transaction and jdbc

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
>
>