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: 05B0404F-A541-4EC9-89C1-64BFE35474EF@fastcrypt.com (view raw or flat)
Thread:
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 ?

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


In response to

Responses

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-2014 The PostgreSQL Global Development Group