[ http://issues.apache.org/jira/browse/IBATISNET-42?page=all ]
Gilles Bayon closed IBATISNET-42:
---------------------------------
Resolution: Fixed
Fix Version: DataMapper 1.2
> 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
> Fix For: DataMapper 1.2
>
> 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/[email protected]/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
