smalldatetime to string conversion problem in sql server

[Zarar Siddiqi <za...@softbloc.com>]

Hi,

I'm having problem reading a column which stores a date as smalldatetime in SQL Server.  I can write to the column fine using a string property but when I try to read it, I get the error pasted below.    I've already tried to specify the types explicitly but that didn't work:

<result column="ShipDate" property="ShipDate" type="string" dbType="SmallDateTime"/>

The reason I know it's this column that's the problem is because as soon as I take it out, everything starts to work again.

Any help is apprecited.  

Here's the error I get:

System.InvalidCastException: Specified cast is not valid.

With the trace:
[InvalidCastException: Specified cast is not valid.]
   System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i) +46
   System.Data.SqlClient.SqlDataReader.GetString(Int32 i) +32
   IBatisNet.DataMapper.TypeHandlers.StringTypeHandler.GetValueByName(ResultProperty mapping, IDataReader dataReader) +79
   IBatisNet.DataMapper.Configuration.ResultMapping.ResultProperty.GetDataBaseValue(IDataReader dataReader) +32
   IBatisNet.DataMapper.MappedStatements.MappedStatement.SetObjectProperty(RequestScope request, ResultMap resultMap, ResultProperty mapping, Object& target, IDataReader reader) +235
   IBatisNet.DataMapper.MappedStatements.MappedStatement.ApplyResultMap(RequestScope request, IDataReader reader, Object resultObject) +241
   IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) +133
   IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) +92
   IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) +10
   IBatisNet.DataMapper.SqlMapper.QueryForObject(String statementName, Object parameterObject) +147