EJB query UPDATE with java.sql.Timestamp ---------------------------------------- Key: HHH-3251 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3251 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.3.0.CR1 Environment: MS SQL 2005, java version "1.6.0_05", Sun Java System Application Server 9.1_01 (build b09d-fcs) Hibernate 3.3.2.GA Reporter: Ralf Alt Priority: Critical Entity bean with Timestamp field. @Version @Column(name="modtime",nullable=false,insertable=false,updatable=true) protected Timestamp getModificationtimeTS() { return myModTime; } protected void setModificationtimeTS(Timestamp timestamp) { myModTime = timestamp; } EJBQuery: "UPDATE ADRESS.class.getName() set name = :_name, modificationtimeTS = :_modtime where id = :_id" Query qry = entityMgr.createQuery( query ) .setParameter( "_name", "Newer" ) .setParameter( "_modtime", new Timestamp( System.currentTimeMillis() )) .setParameter( "_id", 1 ); The generated SQL declare @p1 int set @p1=NULL exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 datetime',N'update ADRESS set name=@P0, modtime=@P1 where id=@P2',N'Newer',''2008-04-24 16:14:17:490'',1 select @p1 The error is in the time stampformat for the sql server (syntax error in the near of '2008'). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira