项目中使用了Postgres-XC作为关系型数据库,而应用则是部署在IBM WAS中,在WAS控制台的配置了基于postgresql-9.3-1103.jdbc4.jar的数据源,但发现一个问题,某个读取包含timestamp类型字段的查询在创建连接后前几次执行不会报错,但后续的执行就会报错。
Caused by: org.postgresql.util.PSQLException: Unsupported binary encoding of timestamp.
at org.postgresql.jdbc2.TimestampUtils.toTimestampBin(TimestampUtils.java:727)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:517)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2629)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getTimestamp(WSJdbcResultSet.java:2672)
at org.hibernate.type.descriptor.sql.TimestampTypeDescriptor$2.doExtract(TimestampTypeDescriptor.java:62)
at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasic