ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Barnett, Brian W." <bbarn...@scholarinc.com>
Subject null date object throwing errors
Date Thu, 13 Jan 2005 23:32:32 GMT
The use of this update statement throws an error when lastExportedDate is
null. (lastExportedDate is java.util.Date) Works fine if it's not null. I
tried using DATE instead of DATETIME, but then the time would not get
written to the db.

<update id="updateConfig" parameterClass="config">
 UPDATE config SET
  last_exported_date=#lastExportedDate:DATETIME#
 WHERE config_id = 1
</update>

This is the error:
com.ibatis.dao.client.DaoException: Error executing update.  Cause:
com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/scholar/model/map/ConfigSQL.xml.  
--- The error occurred while applying a parameter map.  
--- Check the updateConfig-InlineParameterMap.  
--- Check the parameter mapping for the 'lastExportedDate' property.  
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]The specified SQL type is not supported by this driver.

Any suggestions on how I can resolve this?

Mime
View raw message