Re: [INTERFACES] Transaction support in 6.5.3/JDBC

Поиск
Список
Период
Сортировка
От Assaf Arkin
Тема Re: [INTERFACES] Transaction support in 6.5.3/JDBC
Дата
Msg-id 384FF178.FA37B01F@exoffice.com
обсуждение исходный текст
Ответ на RE: [INTERFACES] Transaction support in 6.5.3/JDBC  (Peter Mount <petermount@it.maidstone.gov.uk>)
Список pgsql-interfaces
> PM: Hmmm, in theory if a transaction is in a dead state (ie: an SQL
> statement failed, so anything else is ignored until the rollback), there
> should be a message in the notify queue. Our JDBC driver keeps these in
> the warnings queue, so you could read them prior to calling commit()
> yourself.

>From what I gather if an SQL statement failed, the CompletedResponse
will show *ABORT STATUS*. That's an easy modification. I'm not sure
about a warning being sent, I need to figure how to test this one.

The BE also returns the name of the cursor. I assume this one should be
returned from ResultSet.getCursorName()?

arkin


> 
> arkin
> 
> --
> ____________________________________________________________
> Assaf Arkin                               arkin@exoffice.com
> CTO                                  http://www.exoffice.com
> Exoffice, The ExoLab Company             tel: (650) 259-9796
> 
> ************
> 
> ************

-- 
____________________________________________________________
Assaf Arkin                               arkin@exoffice.com
CTO                                  http://www.exoffice.com
Exoffice, The ExoLab Company             tel: (650) 259-9796



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

Предыдущее
От: "Hiroki Kataoka"
Дата:
Сообщение: Re: ODBC and Large Objects, FAQ not working
Следующее
От: Assaf Arkin
Дата:
Сообщение: Re: [INTERFACES] Transaction support in 6.5.3/JDBC