

16:51:14,327 DEBUG net.sf. - SQL ExceptionĬom.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 2 DB2ADMIN.CONTACTĢ2007 Invalid datetime format. I know that we can change the Timestamp format but why should we have to do this, should Hibernate not be able to figure this out.Ĭontact_email Varchar(50) NOT NULL UNIQUE,Ĭode between sessionFactory.openSession() and session.close():įull stack trace of any exception that occurs: I am wondering if this is a problem with Hibernate, as it seems to be generating the incorrect Timestamp format for the DB2 database. When I go to the Confiruation Assistant it tells me that the datetime is in the format associated with the country code (DEF). 'SELECT current timestamp FROM sysibm.sysdummy1' However, when I run the following query to find out the format of the timestamp in DB2. Hibernate is generating the date in the following format. I am getting the below error when I try and insert a row in a table that has a column called modified_dt in the format of Timestamp.
