Bug extracting bit value
От | Holger Schulz |
---|---|
Тема | Bug extracting bit value |
Дата | |
Msg-id | bKGiHoZKhuw0FF0vBDRcMjj7JmqBR4ufH7XEELpMhkV@akmail обсуждение исходный текст |
Ответы |
Re: Bug extracting bit value
|
Список | pgsql-jdbc |
Hello! When I extract a bit value by JDBC I get an Boolean Object - even for bit(3)! CREATE TABLE testbits ( cbitone bit(1), cbitthree bit(3), cvarbit varbit, cboolean bool ) INSERT INTO testbits ("cbitone", "cbitthree", "cvarbit", "cboolean") values ( B'1', B'101', B'0101', true ) ------------------ In Java: select * from testbits Object oValue = m_resultSet.getObject(i); returns: | cbitone | cbitthree | cvarbit | cboolean | -|---------------------|---------------------|--------------------------------|---------------------|- | true | false | 0101 | true | | 'java.lang.Boolean' | 'java.lang.Boolean' | 'org.postgresql.util.PGobject' | 'java.lang.Boolean' | ------------------ When I use getString() instead of getObject() I get this result: Object oValue = m_resultSet.getObject(i); | cbitone | cbitthree | cvarbit | cboolean | -|--------------------|--------------------|--------------------|--------------------|- | '1' | '101' | '0101' | 't' | | 'java.lang.String' | 'java.lang.String' | 'java.lang.String' | 'java.lang.String' | ------------------ Same statement in pgAdmin III returns: 1;101;"0101";t ------------------ Tested with: PostgreSQL 8.1.4 on Windows 2000 JDBC driver: postgresql-8.2dev-503.jdbc3.jar AND postgresql-8.1-407.jdbc3.jar Holger
В списке pgsql-jdbc по дате отправления: