Can PostgreSQL do data type automated casting in prepared statement?
От | Tjioe Ai Xin |
---|---|
Тема | Can PostgreSQL do data type automated casting in prepared statement? |
Дата | |
Msg-id | 200511211718.26679.xinxincute@gmail.com обсуждение исходный текст |
Ответы |
Re: Can PostgreSQL do data type automated casting in prepared
|
Список | pgsql-jdbc |
Dear all, I already used PostgreSQL from version 7.3.3. So far, I have no problem about using prepared statement especially in data type. From Mr. Kris Jurka I got answer that it because of different data type when I try to cast them. >I'm guessing you are using PreparedStatement.setString for a numeric >value. Do you have a query like "WHERE colname / ? " ? You need to use a >different setXXX method that takes a numeric value. My code is like this: I have query: "Select count(*) / paramPage from tblFirst where condition"; The paramPage were filled from parameter which I specified as string data type. So I using setString method for my prepared statement for passing paramPage value. When I'm using the old jdbc driver pg74jdbc3.jar, I got no problem at all. But when I try to upgrade my PostgreSQL to 8.0.3. I got problem data type error. Can PostgreSQL do data type automated casting in prepared statement again? So I do not need change my code :) Thanks in advance. Best Regards, Xin Xin
В списке pgsql-jdbc по дате отправления: