problem with stored procedure ,transaction and jdbc

Поиск
Список
Период
Сортировка
От Jiangyi
Тема problem with stored procedure ,transaction and jdbc
Дата
Msg-id A3A54A1E-4C84-4EC0-8709-40EB9462DF02@sjtu.edu.cn
обсуждение исходный текст
Ответы Re: problem with stored procedure ,transaction and jdbc
Список pgsql-jdbc
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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Memory leak in 8.0 JDBC driver?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: problem with stored procedure ,transaction and jdbc