Re: Return Codes of BatchUpdateException in PostgreSql 9.6

Поиск
Список
Период
Сортировка
От Tillmann Schulz
Тема Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Дата
Msg-id 63578883.319462.1476435530742@mail.yahoo.com
обсуждение исходный текст
Ответ на Return Codes of BatchUpdateException in PostgreSql 9.6  (Tillmann Schulz <tillmann73@yahoo.de>)
Ответы Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Список pgsql-jdbc
Hello,

I made some test with different driver versions. The result seems to be that it is an issue in the newer driver
versionsand not in the postgresql database 


Postgres 9.5.0 with postgresql-jdbc41-9.4-1201.jar contains only updateCounts of first succeeded statements.

---------------------------------------------------------------------------------------------------------------

updateCounts[0]=1
updateCounts[1]=1
updateCounts[2]=1
updateCounts[3]=1
updateCounts[4]=1
-->correct



Postgres 9.6.0 with postgresql-jdbc41-9.4-1201.jar contains only updateCounts of first succeeded statements.
---------------------------------------------------------------------------------------------------------------
updateCounts[0]=1
updateCounts[1]=1
updateCounts[2]=1
updateCounts[3]=1
updateCounts[4]=1
-->correct but can't use this driver with postgressql 9.6



Postgres 9.6.0 with postgresql-jdbc41-9.4-1211.jar contains updateCounts of all elements.

---------------------------------------------------------------------------------------------------------------
updateCounts[0]=-3
updateCounts[1]=-3
updateCounts[2]=-3
updateCounts[3]=-3
updateCounts[4]=-3
updateCounts[5]=-3
updateCounts[6]=-3
updateCounts[7]=-3
updateCounts[8]=-3
updateCounts[9]=-3
-->Wrong.updateCounts[0..4] and updateCounts[6..9] contains wrong information.



> will need to set logLevel=2
How can I set the logLevel. Is it in postgresql.conf?


Bye,

Tillmann



>Hi,
>Can you check what is returned by the back end for 9.5 and 9.6. You
>will need to set
>
>logLevel=2
>
>That will help to narrow down the problem.
>
>Jeremy


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

Предыдущее
От: Jeremy Whiting
Дата:
Сообщение: Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Следующее
От: Tillmann Schulz
Дата:
Сообщение: Re: Return Codes of BatchUpdateException in PostgreSql 9.6