[ http://issues.apache.org/jira/browse/IBATISNET-42?page=comments#action_63212 ] Ron Grabowski commented on IBATISNET-42: ----------------------------------------
The test case looks similiar to what my code was doing. If the bug appears in the next release I'll make sure to make it as Critical :) You can close this issue. > 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
