I don’t understand how iBATIS = thinks you’re trying to map to an array, do you have overloads for the values-property? Try setting some debug breakpoints in ResultLoader and = find out what’s going on. It definitely should be possible to map to a = List or array.

Niels

From: = Jonathan Alvarsson [mailto:jonathan.alvarsson@gmail.com]
Sent: dinsdag 11 = september 2007 15:11
To: user-java@ibatis.apache.org
Subject: Re: How to map a = list of double?

No difference. = I have tried:
<select id=3D"MoleculeDescriptor.getValueList" = resultClass=3D"Double" parameterClass=3D"String">
        SELECT
            value AS = value
        FROM
            = DescriptorValue
        WHERE
            abstractDescriptor=3D#value#
        ORDER BY
            arrayPos
</select>

and

<select id=3D"MoleculeDescriptor.getValueList" = resultClass=3D"double" parameterClass=3D"String">
        SELECT
            value AS = value
        FROM
            = DescriptorValue
        WHERE
            abstractDescriptor=3D#value#
        ORDER BY
            arrayPos
</select>

both result in ClassCastException. (It reads the file correctly though = because ouble rendered a class not found exception)

Isn't this supposed to be possible to do?

On 9/11/07, Niels Beekman = <n.beekman@wis.nl> = wrote:

Hm, your result class of = MoleculeDescriptor.getValueList is wrong, try changing it to double.

From: Jonathan Alvarsson = [mailto:jonathan.alvarsson@gmail.com]
Sent: dinsdag 11 = september 2007 13:22
To: user-java@ibatis.apache.org
Subject: Re: How to map a = list of double?

Well that's what I thought I was doing. My = field in my bean is

private List<Double> values;

with setter:
public void setValues(List<Double> values) {
this.values =3D values;
}

Does my mapping somehow not match this?

On 9/11/07, Niels Beekman < n.beekman@wis.nl> = wrote:

This seems to be a bug, iBATIS tries to cast a double = array to an Object array. A workaround would probably be to change the double = array to a Double list.

Niels

From: Jonathan Alvarsson = [mailto: jonathan.alvarsson@gmail.com]
Sent: dinsdag 11 = september 2007 11:36
To: user-java@ibatis.apache.org
Subject: How to map a = list of double?

I am trying to map a list of doubles in my bean but I keep getting a ClassCastException on it.

<resultMap class=3D"MoleculeDescriptor" = id=3D"MoleculeDescriptor">
        <result property=3D"id"     column=3D"id"   />
        <result property=3D"name"   column=3D"name" = />
        <result = property=3D"values" column=3D"id" = select=3D"MoleculeDescriptor.getValueList" />
</resultMap>

<select id=3D"MoleculeDescriptor.getValueList " resultClass=3D"List" = parameterClass=3D"String">
        SELECT
            value AS = value
        FROM
            = DescriptorValue
        WHERE
            abstractDescriptor=3D#value#
        ORDER BY
            arrayPos
</select>

CREATE TABLE DescriptorValue (
    id       BIGINT = AUTO_INCREMENT NOT NULL,
    value    DOUBLE           &= nbsp;    NOT NULL,
    arrayPos INT           &nbs= p;       NOT NULL,
    abstractDescriptor VARCHAR(36) NOT NULL,

    PRIMARY KEY (id),
    FOREIGN KEY (abstractDescriptor) REFERENCES AbstractDescriptor(id)
) ENGINE=3DInnoDB;

How can I do this?

Oh and the exception I get:

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient = operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in mapping/MoleculeDescriptor.xml.
--- The error occurred while applying a result map.
--- Check the MoleculeDescriptor.
--- Check the result mapping for the 'values' property.
--- Cause: java.lang.ClassCastException: [D; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in mapping/MoleculeDescriptor.xml.
--- The error occurred while applying a result map.
--- Check the MoleculeDescriptor.
--- Check the result mapping for the 'values' property.
--- Cause: java.lang.ClassCastException: [D
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException = :
--- The error occurred in mapping/MoleculeDescriptor.xml.
--- The error occurred while applying a result map.
--- Check the MoleculeDescriptor.
--- Check the result mapping for the 'values' property.
--- Cause: java.lang.ClassCastException: [D
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java:188)
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject (GeneralStatement.java:104)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java:566)
    at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java :541)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java:106)
    at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(Sq= lMapClientTemplate.java:243)
    at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientT= emplate.java:193)
    at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMap= ClientTemplate.java:241)
    at net.bioclipse.pcm.dao.GenericDao.getById (GenericDao.java:45)
    at = sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at = sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at = sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown = Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(A= opUtils.java:296)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpo= int (ReflectiveMethodInvocation.java:177)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl= ectiveMethodInvocation.java:144)
    at = net.bioclipse.pcm.dao.FetchIntroductionInterceptor.invoke (FetchIntroductionInterceptor.java:22)
    at = org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl= ectiveMethodInvocation.java:166)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke (JdkDynamicAopProxy.java:204)
    at $Proxy0.getById(Unknown Source)
    at = net.bioclipse.pcm.dao.GenericDaoTest.testGetById(GenericDaoTest.java:69)<= br>     at = sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at = sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at = sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown = Source)
    at junit.framework.TestCase.runTest = (TestCase.java:168)
    at = junit.framework.TestCase.runBare(TestCase.java:134)
    at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.= java:69)
    at org.springframework.test.annotation.AbstractAnnotationAwareTransactionalT= ests.access$001 (AbstractAnnotationAwareTransactionalTests.java:47)
    at org.springframework.test.annotation.AbstractAnnotationAwareTransactionalT= ests$1.run(AbstractAnnotationAwareTransactionalTests.java:115)
    at org.springframework.test.annotation.AbstractAnnotationAwareTransactionalT= ests.runTest (AbstractAnnotationAwareTransactionalTests.java:180)
    at = org.springframework.test.annotation.AbstractAnnotationAwareTransactionalT= ests.runTestTimed(AbstractAnnotationAwareTransactionalTests.java:153)
=     at org.springframework.test.annotation.AbstractAnnotationAwareTransactionalT= ests.runBare (AbstractAnnotationAwareTransactionalTests.java:111)
    at = junit.framework.TestResult$1.protect(TestResult.java:110)
    at junit.framework.TestResult.runProtected(TestResult.java:128)
    at junit.framework.TestResult.run = (TestResult.java:113)
    at = junit.framework.TestCase.run(TestCase.java:124)
    at = junit.framework.TestSuite.runTest(TestSuite.java:232)
    at = junit.framework.TestSuite.run(TestSuite.java:227)
    at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run (JUnit3TestReference.java:130)
    at = org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.jav= a:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:460)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:673)
    at = org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn= er.java:386)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main (RemoteTestRunner.java:196)
Caused by: java.lang.ClassCastException: [D
    at = com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.listToArray(R= esultLoader.java:85)
    at com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult (ResultLoader.java:75)
    at com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.loadResult(Re= sultLoader.java:59)
    at = com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getNestedSelectMap= pingValue(BasicResultMap.java :502)
    at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicRe= sultMap.java:340)
    at = com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.= java:381)
    at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults (SqlExecutor.java:301)
    at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava:190)
    at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java :205)
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java:173)
    ... 44 more

--
// Jonathan

--
// Jonathan