I have problems using java.sql.Timestamp fields in a CMP EJB (using the JBoss-2.4.1 - Tomcat 3.2.3 bundle).
I can create an EJB, everything looks fine (data gets written into the database, I can look at it using psql).
I can also query the Timestamp field, as long as it has not been passivated. As soon as I try to access (using a finder method lik findByPrimaryKey()) an EJB, which has been passivated, I get an error and find the following in my log-files:
[pre]
[JAWS] SQL Error preloading data for key 4142
[ShipmentBean] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception is:
Bad Timestamp Format at 19 in 2001-12-06 11:14:32.77+01; nested exception is:
java.rmi.ServerException: Load failed; nested exception is:
Bad Timestamp Format at 19 in 2001-12-06 11:14:32.77+01
[/pre]
and of course lots of error following these lines.
Is this a known problem with PostgreSQL, or is it just me doing something wrong (maybe just some PostgreSQL configuration issues)?
The problem stays the same, no matter if I create the table by hand or let JAWS create the table. All other field-types (String-TEXT, int, long, double) work as expected.
I can post contents of my config-files and more details if needed, but I hoped the problem is clear with what I have posted.
Christoph