You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Ron Grabowski (JIRA)" <ib...@incubator.apache.org> on 2005/04/19 18:17:30 UTC
[jira] Created: (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.
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
[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.
Posted by "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
[jira] Closed: (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.
Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
[ 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/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
[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.
Posted by "Ron Grabowski (JIRA)" <ib...@incubator.apache.org>.
[ 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