[ http://issues.apache.org/jira/browse/IBATISNET-20?page=history ]
Gilles Bayon closed IBATISNET-20:
---------------------------------
Resolution: Fixed
Applied patch + nunit tests
> Type problems when applying parameters
> --------------------------------------
>
> Key: IBATISNET-20
> URL: http://issues.apache.org/jira/browse/IBATISNET-20
> Project: iBatis for .NET
> Type: Bug
> Versions: DataMapper 1.1
> Reporter: Henrik Uffe Jensen
>
> I don't know if this error applies for both parameterMaps and with inline
> parameterMaps. I only used inline parameterMaps.
> When using parameterClass="Guid" in my Guid, I got an error saying "Object
> must Implement IConvertible"
> After a lot of debugging I found that no matter, what then the sql statemants
> executed against the database used nvarchar(4000) an no other type.
> I found that this is due to the changes made in
> IBatisNet.DataMapper.MappedStatements.ApplyParameterMap from version 1.0.1 to
> 1.1
> In 1.0.1 'sqlParameter.Value' is set at the top of the method. Setting
> 'Value' on sqlParameter changes the sqlParameter.DbType from String (default)
> to the correct type of the object value being set.
> In 1.1 however you use 'parameterValue =' (line 265) instead, and
> 'sqlParameter.Value' is therefore never set, which means that the
> 'sqlParmenter.DbType' never changes from the default DbType. Further down the
> method 'parameterCopy.DbType = sqlParameter.DbType;' (line 316 or 321) sets
> the DbType of the parameterCopy, however this is always String.
> I corrected the error by adding a 'sqlParameter.Value = parameterValue;'
> below the 'parameterCopy.Value = parameterValue;' (line 301)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
