[jira] Closed: (IBATISNET-20) Type problems when applying parameters

["Gilles Bayon (JIRA)" <ib...@incubator.apache.org>]

     [ 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