[jira] Commented: (IBATISNET-42) Build 1.1.458.0 doesn't automatically map .Net's bool to Sql Server 2000's Bit column type like previous builds did.

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

     [ http://issues.apache.org/jira/browse/IBATISNET-42?page=comments#action_63167 ]
     
Gilles Bayon commented on IBATISNET-42:
---------------------------------------

With the source in SVN, I haven't the bug.
Made a test 'TestJIRA42' in StatementTest to try to reproduct it.

<statement id="InsertBool" 
	parameterClass="Other">
Insert into Others
( Other_Int, Other_Long, Other_Bit )
values
( #Int#, #Long#, #Bool#)
</statement>

All is green.

I will close this issue if no more comments.

> Build 1.1.458.0 doesn't automatically map .Net's bool to Sql Server 2000's Bit column type like previous builds did.
> --------------------------------------------------------------------------------------------------------------------
>
>          Key: IBATISNET-42
>          URL: http://issues.apache.org/jira/browse/IBATISNET-42
>      Project: iBatis for .NET
>         Type: Bug
>     Versions: DataMapper 1.1
>  Environment: DataMapper: 1.1.458.0
>     Reporter: Ron Grabowski
>     Assignee: Gilles Bayon
>     Priority: Minor

>
> The last stable version of IBatis (v1.0.1.321?) automatically translated .Net's bool to a Sql Server 2000's Bit.
> // works in v1.0.1.321 but not in v1.1.458.0
> INSERT INTO Foo (IsPublished) (#IsPublished#)
> // fixed syntax for v1.1.458.0
> INSERT INTO Foo (IsPublished) (#IsPublished:Bit#)
> When I omit the :Bit inline parmaeter map, I get the following exception:
> Exception: System.Data.SqlClient.SqlException
> Message: Syntax error converting the nvarchar value 'False' to a column of data type bit.
> Source: .Net SqlClient Data Provider
>    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
>    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>    at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteInsert(IDalSession session, Object parameterObject)
>    at IBatisNet.DataMapper.SqlMapper.Insert(String statementName, Object parameterObject)
> I posted a message to the mailing list about this:
>  http://www.mail-archive.com/ibatis-user-cs@incubator.apache.org/msg00270.html
> I'll attach files when I have chance to revert back to v1.0.1.321 and verify that it was working in that version.

-- 
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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira