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

Reply via email to