Commitment control on updateable ResultSet

Поиск
Список
Период
Сортировка
Искать
От
Flavio Palumbo
Тема
Commitment control on updateable ResultSet
Дата
Msg-id
16566495.2149901230896864322.JavaMail.root@pr004msr
Список
Дерево обсуждения
Commitment control on updateable ResultSet Flavio Palumbo <flavio.palumbo@fastwebnet.it>
Re: Commitment control on updateable ResultSet "Dave Cramer" <pg@fastcrypt.com>
Hi all,

I try to control the commitment on an updatable ResultSet but I get a strange ex
ception : 
"ERROR: current transaction is aborted, commands ignored until end of transactio
n block"

I do this :
- Connection.setAutoCommit(false);
- Connection.setSavepoint(point);
- Connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sq
l.ResultSet.CONCUR_UPDATABLE);
- Statetement.executeQuery("SELECT T1.*  FROM  public.teststrike T1 for update")

at this point a I get the above exception.

Can somebody help me to figure out why this happens ?

Thanks
Flavio

В списке pgsql-jdbc по дате отправления
От: Cromax
Дата:
От: Dave Cramer
Дата:
FAQ