Mismatched JDBC and Java Type
От | Mike Finn |
---|---|
Тема | Mismatched JDBC and Java Type |
Дата | |
Msg-id | 01042711454803.01052@birch.tacticalExecutive.com обсуждение исходный текст |
Ответы |
Re: Mismatched JDBC and Java Type
|
Список | pgsql-jdbc |
I am using a short (Short) in my application for a particular data field My understanding is that this should map to the JDBC type 'smallInt' which in turn maps to the postgresql type int2. However when I retrieve data via JDBC (jdbc7.0-1.2.jar, 7.0.3-2 engine) the int2 fields are returned as java.lang.Integer instead of java.lang.Short. Is this a bug? ----------- Example code below ---------- ResultSetMetaData md = rs.getMetaData(); while (rs.next()) { for (int c=1; c <= md.getColumnCount(); c++) { Object obj = rs.getObject(c); Logger.println(c + "\tcolumnName=" + md.getColumnName(c) + "\tcolumnType=" + md.getColumnType(c) + "\tcolumnTypeName=" + md.getColumnTypeName(c) + "\tvalue=" + obj + "\tvalueClass=" + obj.getClass().getName() ); will produce ... 10 columnName=active columnType=5 columnTypeName=int2 value=8 valueClass=java.lang.Integer ... note that md.getColumnClassName() is not implemented so I don't know what it would return. =================== Mike Finn Tactical Executive Systems mike.finn@tacticalExecutive.com
В списке pgsql-jdbc по дате отправления: