1 Reply Latest reply on Mar 15, 2002 2:25 PM by John Moore

    Postgres Timestamps

    John Moore Newbie

      I am using jboss-2.4.3 w/ tc 3.2.3 and am trying to retrieve a TIMESTAMP WITHOUT TIME ZONE column from a postgres 7.2 db via the jdbc-7.1-1.2.jar.

      The error is:
      [JAWS] Bad Timestamp Format at 23 in 2002-03-15 08:53:01.462767
      [JAWS] at org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:517)
      [JAWS] at org.postgresql.jdbc2.ResultSet.getObject(ResultSet.java:825)
      [JAWS] at org.jboss.pool.jdbc.ResultSetInPool.getObject(ResultSetInPool.java:554)
      [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:405)

      We have a jaws.xml file with a and a <type-mapping> section but rely on the type-mappings from standardjaws.xml. The datasource is declared through an XADataSourceLoader not jca.

      I didn't see a change in 2.4.4 and know there must be a solution other than hacking the postgres driver or adding a mapping to jaws.xml to map a timestamp to a string.

      John Moore