Bad value for type timestamp on production server

Posted by Juan Javaloyes on Stack Overflow See other posts from Stack Overflow or by Juan Javaloyes
Published on 2012-06-01T21:23:42Z Indexed on 2012/06/01 22:40 UTC
Read the original article Hit count: 1181

Filed under:
|
|
|
|

I'm working with: seam 2.2.2 + hibernate + richfaces + jboss 5.1 + postgres

I have an module which needs to load some data from the database. Easy. The problem is, on development it works fine, 100%, but when I deploy on my production server and try to get the data, an error rise:

could not read column value from result set: fechahor9_504_; Bad value for type timestamp : [C@122e5cf
SQL Error: 0, SQLState: 22007
Bad value for type timestamp : [C@122e5cf
javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute query

[more errors]

Caused by: org.postgresql.util.PSQLException: Bad value for type timestamp : [C@122e5cf
at org.postgresql.jdbc2.TimestampUtils.loadCalendar(TimestampUtils.java:232)

[more errors]

Caused by: java.lang.NumberFormatException: Trailing junk on timestamp: ''
at org.postgresql.jdbc2.TimestampUtils.loadCalendar(TimestampUtils.java:226)

I can't understand why it works on my machine (development) and why not on production. Any clues? Anyone gone through the same problem? Is exactly the same compilation

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about java-ee