Data types
От | Vicente Alabau Gonzalvo |
---|---|
Тема | Data types |
Дата | |
Msg-id | 3E3A6516.6010407@capgemini.es обсуждение исходный текст |
Ответы |
Re: Data types
|
Список | pgsql-jdbc |
Hello, I'm trying to retireve some data from this table: create table types (_numeric_ numeric); _numeric_ ----------- 10 (1 row) usgin jdbc in this way: If I try to do this query: String query = "SELECT * FROM types"; I can get it as BigDecimal and gives me no problems. But with this other: String query = "SELECT * FROM types WHERE _numeric_=? "; pStmt = con.prepareStatement(query); pStmt.setBigDecimal(1, 10); and java gives this exception: java.sql.SQLException: ERROR: Unable to identify an operator '=' for types 'numeric' and 'double precision' I think it's because jdbc matches BigDecimals with 'double precision' but I want to match them with 'numeric' instead. Is there any way to do this match? How can I solve this problem? Thanks
В списке pgsql-jdbc по дате отправления: