Bug extracting money value
От | Holger Schulz |
---|---|
Тема | Bug extracting money value |
Дата | |
Msg-id | rPIjYa0u87xbEkf7wiWlAPS3aOby2tyLTfkRCNbvOP1@akmail обсуждение исходный текст |
Ответы |
Re: Bug extracting money value
|
Список | pgsql-jdbc |
Hello! I always get an exception when I try to extract the money value I inserted this way: insert into public."dbtypes" ("cmoney") values ('7'). Java: Object oValue = m_resultSet.getObject(i); Stacktrace (postgresql-8.2dev-503.jdbc3.jar): org.postgresql.util.PSQLException: Bad value for type double : ?7,00 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toDouble(AbstractJdbc2ResultSet.java:2594) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getDouble(AbstractJdbc2ResultSet.java:1975) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.internalGetObject(AbstractJdbc2ResultSet.java:132) at org.postgresql.jdbc3.AbstractJdbc3ResultSet.internalGetObject(AbstractJdbc3ResultSet.java:39) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2291) resultSet.getDouble(i); doesn't work either. resultSet.getString(i); returns '?7,00' without exception. Tested with: PostgreSQL 8.1.4 on Windows 2000 JDBC driver: postgresql-8.2dev-503.jdbc3.jar AND postgresql-8.1-407.jdbc3.jar Thanks Holger
В списке pgsql-jdbc по дате отправления: