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.
Tried the pgjdbc2.jar from jdbc.postgres.org and received a slightly different error; a bug on their side. Went to the devpgjdbc2.jar and it worked.