One question about connection parameter stringtype

Поиск
Список
Период
Сортировка
От 夏 \xEFw
Тема One question about connection parameter stringtype
Дата
Msg-id AA382F9E-6710-4606-8F5C-E76B9A5F8E0F@icloud.com
обсуждение исходный текст
Ответы Re: One question about connection parameter stringtype
Список pgsql-jdbc
Hi,

When i run my program which use pgjdbc,a error happened.


my program looks like the following:

PreparedStatement pstmt = con.prepareStatement("select 1=?");
pstmt.setString(1, null);
pstmt.executeUpdate();

error message:
operator does not exist: integer = character varying

The error's resean is just as the error message said, and i known this can be avoided
by set stringtype=unspecified in url. But i still have two question。

1)when stringtype is setted to be "unspecified",is there any bad think would happen?

2)If the answer of 1)is "nothing",why pgjdbc not setting the default value of stringtype to "unspecified"

kavi314

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

Предыдущее
От: Mikko Tiihonen
Дата:
Сообщение: Re: getFastLong gets longs slowly
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: getFastLong gets longs slowly