Hi,

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.