Skip site navigation (1) Skip section navigation (2)

Re: problem with stored procedure ,transaction and jdbc

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Jiangyi <jiangyi(at)sjtu(dot)edu(dot)cn>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: problem with stored procedure ,transaction and jdbc
Date: 2005-08-12 17:09:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-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 ?

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?

In response to


pgsql-jdbc by date

Next:From: Andres LedesmaDate: 2005-08-12 18:25:07
Subject: Re: problem with stored procedure ,transaction and jdbc
Previous:From: JiangyiDate: 2005-08-12 16:47:23
Subject: problem with stored procedure ,transaction and jdbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group