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