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 по дате отправления:

Предыдущее
От: "Timothy A. DeWees"
Дата:
Сообщение: Re: JDBC access with md5 password
Следующее
От: Khondoker Mahmud
Дата:
Сообщение: To SQL Store Procedure from Java application