JDBC: "transaction aborted"

Поиск
Список
Период
Сортировка
От Pif
Тема JDBC: "transaction aborted"
Дата
Msg-id 54191bbe-6765-4b1c-bbfd-8fd2d9e6024f@f25g2000yqc.googlegroups.com
обсуждение исходный текст
Список pgsql-jdbc
Hello,

I use a connection pool (autocommit disabled). In some action servlet
of my website, I have "begin" and commit/rollback commands.
All work well.

But in my JSP page, when a select fail with JDBC exception, then I
cannot retry because of this exception :
"ERROR: current transaction is aborted, commands ignored until end of
transaction block"

So, since I only do select and I do not declare a begin statement, why
is there a transaction !? how can I choose that I don't want
transactions out of a begin/commit/roolback context !?

Thanks a lot.


PG 8.4

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

Предыдущее
От: James William Pye
Дата:
Сообщение: Re: [HACKERS] Trouble with COPY IN
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Trouble with COPY IN