The problem is that 'SELECT 1' returns an int and 'SELECT 1.2345' returns a Decimal, thus it may vary from time to time depending on the complexity of the SQL clause (ie column types may change). The way I do this now is using 'SELECT CAST(1 AS DOUBLE) as d'.
Is there some way in iBatis to convert the result to, say, a double in all cases?, ie something like <result coerceInto="double" property="d" column="d"/> ------------- From: Vincent Apesa [mailto:vincent.ap...@gmail.com] Sent: den 8 maj 2009 19:52 To: user-cs@ibatis.apache.org Subject: Re: iBatis doesn't work with doubles? Off the top of my head. You could specify the result map and define the datatype. That should work just fine. <resultMap id="Foo-result" class="Foo"> <result property="d" column="d" type="double"/> </result> <statements> <select id="getFoo" resultMap="Foo-result"> SELECT 1.2345 as d </select> </statements> </sqlMap> On Fri, May 8, 2009 at 1:42 PM, Christopher DeGuise <christopher.degu...@be-pragmatic.com> wrote: I think (at first inspection) is that you are using a resultClass of "Foo". Change the statement to return the primitive type "double" as the resultClass. The exception is indicating a cast of double->Foo is not valid. Chris On Fri, May 8, 2009 at 9:27 AM, Martin Wickman <martin.wick...@dapresy.com> wrote: Hello I get "System.InvalidCastException: Specified cast is not valid" and the following stacktrace: at System.Data.SqlClient.SqlBuffer.get_Double() at System.Data.SqlClient.SqlDataReader.GetDouble(Int32 i) at IBatisNet.DataMapper.Commands.DataReaderDecorator.System.Data.IDataRecord.GetDouble(Int32 i) at IBatisNet.DataMapper.TypeHandlers.DoubleTypeHandler.GetValueByIndex(ResultProperty mapping, IDataReader dataReader) at IBatisNet.DataMapper.Configuration.ResultMapping.ResultProperty.GetDataBaseValue(IDataReader dataReader) at IBatisNet.DataMapper.MappedStatements.ResultStrategy.AutoMapStrategy.Process(RequestScope request, IDataReader& reader, Object resultObject) at IBatisNet.DataMapper.MappedStatements.ResultStrategy.ResultClassStrategy.Process(RequestScope request, IDataReader& reader, Object resultObject) at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForList[T](RequestScope request, ISqlMapSession session, Object parameterObject, IList`1 resultObject, RowDelegate`1 rowDelegate) at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForList[T](ISqlMapSession session, Object parameterObject) at IBatisNet.DataMapper.SqlMapper.QueryForList[T](String statementName, Object parameterObject) at Dapresy.RefDB.ServiceLibrary.DB.FooHelper.select() in C:\...\DB\FooHelper.cs:line 11 at UnitTests.AttributesTest.foo() in C:\...\UnitTests\AttributesTest.cs:line 79 This is a simple as I could make the test case: Foo.xml (the sqlMap): <?xml version="1.0" encoding="UTF-8" ?> <sqlMap namespace="Foo" xmlns="http://ibatis.apache.org/mapping"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="../iBatis/SqlMap.xsd"> <statements> <select id="getFoo" resultClass="Foo"> SELECT 1.2345 as d </select> </statements> </sqlMap> Foo.cs (the test class): public class Foo { public double d = 0.0; } mapper().QueryForList<Foo>("getFoo", null); As you see, this is an extremely simple example and it should of course work. If I change the 'd' property to and int or string or whatever, it works. This is the first time I used doubles with iBats. But using 'float' or 'double' gives this error! Using iBatis .NET 1.6.[12] and SQL Server2.0. /Martin
