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?
