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.
That was after changing from just TIMESTAMP which returned a class
(timestamptz.) not found error.
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)
I looked through the forum and didn't find a solution and
We have a jaws.xml file with a <datasource> and a <type-mapping> section but
rely on the type-mappings from standardjaws.xml. The datasource is declared
through an XADataSourceLoader.
I also tried 2.4.4 with the same results. There must be a solution other
than hacking the postgres driver (which was someone from the forums
solution) or adding a mapping to jaws.xml to map a timestamp to a string.
John Moore
Principal Decision Systems International
625 The City Drive
Suite 190
Orange, CA 92868
800-850-7374
------_=_NextPart_001_01C1CC4D.04870470
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Postgres Timestamps</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>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. That was after changing from just =
TIMESTAMP which returned a class (timestamptz.) not found =
error.</FONT></P>
<P><FONT SIZE=3D2>The error is: </FONT>
<BR><FONT SIZE=3D2>[JAWS] Bad Timestamp Format at 23 in 2002-03-15 =
08:53:01.462767</FONT>
<BR><FONT SIZE=3D2>[JAWS] at =
org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:517)</FONT>
<BR><FONT SIZE=3D2>[JAWS] at =
org.postgresql.jdbc2.ResultSet.getObject(ResultSet.java:825)</FONT>
<BR><FONT SIZE=3D2>[JAWS] at =
org.jboss.pool.jdbc.ResultSetInPool.getObject(ResultSetInPool.java:554)<=
/FONT>
<BR><FONT SIZE=3D2>[JAWS] at =
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.=
java:405)</FONT>
</P>
<P><FONT SIZE=3D2>I looked through the forum and didn't find a solution =
and </FONT>
</P>
<P><FONT SIZE=3D2>We have a jaws.xml file with a <datasource> and =
a <type-mapping> section but rely on the type-mappings from =
standardjaws.xml. The datasource is declared through an =
XADataSourceLoader. </FONT></P>
<P><FONT SIZE=3D2>I also tried 2.4.4 with the same results. There =
must be a solution other than hacking the postgres driver (which was =
someone from the forums solution) or adding a mapping to jaws.xml to =
map a timestamp to a string.</FONT></P>
<P><FONT SIZE=3D2>John Moore</FONT>
</P>
<P><FONT SIZE=3D2>Principal Decision Systems International</FONT>
<BR><FONT SIZE=3D2>625 The City Drive</FONT>
<BR><FONT SIZE=3D2>Suite 190</FONT>
<BR><FONT SIZE=3D2>Orange, CA 92868</FONT>
<BR><FONT SIZE=3D2>800-850-7374</FONT>
</P>
<BR>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C1CC4D.04870470--
