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 Assigned to: 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