0 Replies Latest reply on Dec 6, 2001 5:36 AM by Christoph Jäger

    Using Timestamp fields in PostgreSQL

    Christoph Jäger Newbie

      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