Re: Mail an JDBC driver

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Mail an JDBC driver
Дата
Msg-id CADK3HHJkXjjP+yf+74_nR-TzA-FR-1+ZwWzDysOtStKQ7CWw7A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Mail an JDBC driver  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-jdbc
Could be because we now cache statements. I suspect the cached statement would not like you switching the schema out from under it.

How are you changing the search path? Ideally if you use setSchema we may have to look at invalidating the cache. Vladimir ?


On 2 August 2016 at 08:27, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Aug 2, 2016 at 3:31 AM, KUNES Michael <Michael.KUNES@frequentis.com> wrote:
If you need more information, please let us know.

​Is the same DB version (and which exact versions) being used in both tests?  I strongly suspect no...

Can you turn on full statement logging and see if anything unusual shows up?

​What's in your WHERE clause on the delete - and did you use Statement or PreparedStatement?

Having a self-contained test case makes the previous two items less problematic.  Also, that general test case can be translated to psql which would help to isolate the problem to either the driver or the database.

​David J.​


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Mail an JDBC driver
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Mail an JDBC driver