db2 maps Date to Blob

[pstrotmann]

Hi

I'm using DB2 PE 8.1 as my JBOSS-Database server.
I have a CMP-Field of Java Type Date, DB2 maps it to a
Binary Large Object (BLOB (2000)), which blames, when I try to set the date, of course. Which java- type should be used to get a suitable mapping?

peter

ps. Postgres maps the same Java-Date CMP-Field to a timestamp-Collumn.

[pstrotmann]

reply to myself, maybe someone benefits from it.

With java.sql.Date instead of java.util.Date db2 maps to a fine Date-Column, and postgres too