You are getting this error because iBATIS does not know what the parameter type is. You need to use a parameter map to provide the type.
If you are doing inline parameters, look on page 20 in the developer guide. Larry On Fri, 14 Jan 2005 16:16:24 -0800, Srivastava, Ashish wrote: > I am trying to insert null value for date attribute in one of the table. I > can do this if I execute the insert statement in database directly, but If I > try to do so from java code, I am getting the following error as: > > --- The error occurred in > com/schwab/mftg/mfds/rcmndlist/persistence/sqlmap/RcmndListUpdate.xml. > --- The error occurred while applying a parameter map. > --- Check the createRcmndListVersion-InlineParameterMap. > --- Check the parameter mapping for the 'effectiveDate' property. > --- Cause: java.sql.SQLException: Invalid column type > at com.schwab.mftg.mfds.dao.BaseDAO.update(BaseDAO.java:121) > > Do you have any idea why we are getting this error.
