I am using JBoss 4.x with PosrgreSQL 8.x JDBC postgresql-8.0-311.jdbc3.jar. I have a CMP EJB that has a setter:
void setCreationDate(java.sql.Date creationDate);
When I use the setter in my ejbCreate() call:
setCreationDate( new java.sql.Date( new java.util.Date().getTime() ) );
it throws an SQLException : Could not create entity:java.sql.SQLException: ERROR: column "creation_date" is of type date but expression is of type character varying.
What am i doing wrong ??
The same code works like a charm with 7.4x driver.