Return-Path: 
 <user-java-return-8872-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 33848 invoked from network); 5 Sep 2006 09:21:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 5 Sep 2006 09:21:10 -0000
Received: (qmail 16237 invoked by uid 500); 5 Sep 2006 09:21:04 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 16220 invoked by uid 500); 5 Sep 2006 09:21:04 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 16209 invoked by uid 99); 5 Sep 2006 09:21:04 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Sep 2006 02:21:04 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [212.27.42.35] (HELO smtp5-g19.free.fr) (212.27.42.35)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Sep 2006 02:21:02 -0700
Received: from [192.168.0.2] (bgn92-4-82-238-212-190.fbx.proxad.net
 [82.238.212.190])
	by smtp5-g19.free.fr (Postfix) with ESMTP id 96E591D211
	for <user-java@ibatis.apache.org>; Tue,  5 Sep 2006 11:20:40 +0200 (CEST)
Message-ID: <44FD4167.8080603@free.fr>
Date: Tue, 05 Sep 2006 11:20:39 +0200
From: TNO <tnodev@free.fr>
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Problem with multi-select inside a resultMap since Ibatis 2.20
 (colored...)
References: <44FC5EED.300@free.fr> <44FCA2BD.9050004@free.fr>
In-Reply-To: <44FCA2BD.9050004@free.fr>
X-Enigmail-Version: 0.94.0.0
Content-Type: multipart/alternative;
 boundary="------------000502090600050902030507"
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This is a multi-part message in MIME format.
--------------000502090600050902030507
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

The fisrt query works fine (the startTransaction, the query, the
mapping...), but the second one fails because txManager is null, so
It throws a NullPointerException...

Is-it a bug, or I need a transaction manager ?

Please help... :'(

thanks


TNO a �crit :
> This is a transaction problem... I think
> It curious to open transaction to execute some select query, isn't-it ?
>
> Class SqlMapExecutorDelegate and my txManager is null !
> A test on txManager and a good error message would be great ;-)
>
>   /**
>    * Start a transaction on the session
>    *
>    * @param session - the session
>    * @throws SQLException - if the transaction could not be started
>    */
>   public void startTransaction(SessionScope session) throws SQLException {
>     try {
>       txManager.begin(session);
>     } catch (TransactionException e) {
>       throw new NestedSQLException("Could not start transaction. 
> Cause: " + e, e);
>     }
>   }
>
> Jira or not ?
>
> TNO a �crit :
>> Hello,
>>
>> I have a new problem since we use Ibatis 2.2.0.
>> I use multi select inside a resultMap for 1-N relations :
>>
>> <select id="getPlanOptionFromIdPlan" resultMap="planOptionResult">
>>     <include refid="getPlanOptionSql"/>
>>     WHERE plan_option.i_plan = #id#
>>   </select>
>>   <select id="getEcheanceOptionFromIdPlan" resultMap="echeanceOptionResult">
>>     <include refid="getEcheanceOptionSql"/>
>>     WHERE echeance_option.i_plan = #id#
>>   </select>
>>   <select id="getEcheancePlanFromIdPlan" resultMap="echeancePlanResult">
>>     <include refid="getEcheancePlanSql"/>
>>     WHERE echeance_plan.i_plan = #id#
>>   </select>
>>
>>   <resultMap id="planResult1N" class="plan" extends="planResult">
>>     <result property="listEcheanceOption"
>> select="getEcheanceOptionFromIdPlan" column="plan_i_plan" />
>>     <result property="listEcheancePlan"
>> select="getEcheancePlanFromIdPlan" column="plan_i_plan" />
>>     <result property="listPlanOption" select="getPlanOptionFromIdPlan"
>> column="plan_i_plan" />
>>   </resultMap>
>>
>>   <select id="getPlan1N" parameterClass="string" resultMap="planResult1N">
>>     <include refid="getPlanSql"/>
>>     $whereStr$
>>   </select>
>>
>>   
>> These selects work with previous version of Ibatis but with 2.2.0, I
>> have this exception :
>>
>> org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
>> operation; uncategorized SQLException for SQL []; SQL state [null];
>> error code [0];  
>> --- The error occurred in arc/db/auto/dao/ibatis/config/PlanSQL.xml. 
>> --- The error occurred while applying a result map. 
>> --- Check the planResult1N. 
>> --- Check the result mapping for the 'listEcheanceOption' property. 
>> --- Cause: java.lang.NullPointerException; nested exception is
>> com.ibatis.common.jdbc.exception.NestedSQLException:  
>> --- The error occurred in arc/db/auto/dao/ibatis/config/PlanSQL.xml. 
>> --- The error occurred while applying a result map. 
>> --- Check the planResult1N. 
>> --- Check the result mapping for the 'listEcheanceOption' property. 
>> --- Cause: java.lang.NullPointerException
>> com.ibatis.common.jdbc.exception.NestedSQLException:  
>> --- The error occurred in arc/db/auto/dao/ibatis/config/PlanSQL.xml. 
>> --- The error occurred while applying a result map. 
>> --- Check the planResult1N. 
>> --- Check the result mapping for the 'listEcheanceOption' property. 
>> --- Cause: java.lang.NullPointerException
>> Caused by: java.lang.NullPointerException
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:614)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:231)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:190)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:229)
>>     at
>> arc.db.auto.dao.ibatis.PlanDAOiBatis.getList1N(PlanDAOiBatis.java:296)
>>     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(AopUtils.java:287)
>>     at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
>>     at $Proxy0.getList1N(Unknown Source)
>>     at
>> arc.db.auto.dao.ibatis.TestPlanDAOiBatis.testGetList1N(TestPlanDAOiBatis.java:160)
>>     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:154)
>>     at junit.framework.TestCase.runBare(TestCase.java:127)
>>     at junit.framework.TestResult$1.protect(TestResult.java:106)
>>     at junit.framework.TestResult.runProtected(TestResult.java:124)
>>     at junit.framework.TestResult.run(TestResult.java:109)
>>     at junit.framework.TestCase.run(TestCase.java:118)
>>     at junit.framework.TestSuite.runTest(TestSuite.java:208)
>>     at junit.framework.TestSuite.run(TestSuite.java:203)
>>     at
>> org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
>>     at
>> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
>> Caused by: java.lang.NullPointerException
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:780)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:170)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:149)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:880)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:621)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:96)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.loadResult(ResultLoader.java:59)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getNestedSelectMappingValue(BasicResultMap.java:504)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:340)
>>     at
>> com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:375)
>>     at
>> com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:295)
>>     at
>> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
>>     ... 35 more
>>
>> Caused by:
>> java.lang.NullPointerException
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:780)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:170)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:149)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:880)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:621)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:96)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.loadResult(ResultLoader.java:59)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getNestedSelectMappingValue(BasicResultMap.java:504)
>>     at
>> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:340)
>>     at
>> com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:375)
>>     at
>> com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:295)
>>     at
>> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
>>     at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:614)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)
>>     at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:231)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:190)
>>     at
>> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:229)
>>     at
>> arc.db.auto.dao.ibatis.PlanDAOiBatis.getList1N(PlanDAOiBatis.java:296)
>>     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(AopUtils.java:287)
>>     at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
>>     at $Proxy0.getList1N(Unknown Source)
>>     at
>> arc.db.auto.dao.ibatis.TestPlanDAOiBatis.testGetList1N(TestPlanDAOiBatis.java:160)
>>     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:154)
>>     at junit.framework.TestCase.runBare(TestCase.java:127)
>>     at junit.framework.TestResult$1.protect(TestResult.java:106)
>>     at junit.framework.TestResult.runProtected(TestResult.java:124)
>>     at junit.framework.TestResult.run(TestResult.java:109)
>>     at junit.framework.TestCase.run(TestCase.java:118)
>>     at junit.framework.TestSuite.runTest(TestSuite.java:208)
>>     at junit.framework.TestSuite.run(TestSuite.java:203)
>>     at
>> org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
>>     at
>> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
>>     at
>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 01/09/2006
>>   
>
> -- 
> Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 01/09/2006
>   

-- 
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs


--------------000502090600050902030507
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
The fisrt query works fine (the startTransaction, the query, the
mapping...), but the second one fails because txManager is null, so<br>
It throws a NullPointerException...<br>
<br>
Is-it a bug, or I need a transaction manager ?<br>
<br>
Please help... <span class="moz-smiley-s15"><span> :'( </span></span><br>
<br>
thanks<br>
<br>
<br>
TNO a &eacute;crit&nbsp;:
<blockquote cite="mid44FCA2BD.9050004@free.fr" type="cite">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
This is a transaction problem... I think<br>
It curious to open transaction to execute some select query, isn't-it ?<br>
  <br>
Class SqlMapExecutorDelegate and my txManager is null !<br>
A test on txManager and a good error message would be great <span
 class="moz-smiley-s3"><span> ;-) </span></span><br>
  <br>
&nbsp; /**<br>
&nbsp;&nbsp; * Start a transaction on the session<br>
&nbsp;&nbsp; *<br>
&nbsp;&nbsp; * @param session - the session<br>
&nbsp;&nbsp; * @throws SQLException - if the transaction could not be started<br>
&nbsp;&nbsp; */<br>
&nbsp; public void startTransaction(SessionScope session) throws
SQLException {<br>
&nbsp;&nbsp;&nbsp; try {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txManager.begin(session);<br>
&nbsp;&nbsp;&nbsp; } catch (TransactionException e) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; throw new NestedSQLException("Could not start transaction.&nbsp;
Cause: " + e, e);<br>
&nbsp;&nbsp;&nbsp; }<br>
&nbsp; }<br>
  <br>
Jira or not ?<br>
  <br>
TNO a &eacute;crit&nbsp;:
  <blockquote cite="mid44FC5EED.300@free.fr" type="cite">
    <meta content="text/html;charset=ISO-8859-1"
 http-equiv="Content-Type">
Hello,<br>
    <br>
I have a new problem since we use Ibatis 2.2.0.<br>
I use multi select inside a resultMap for 1-N relations :<br>
    <br>
    <pre wrap=""><font color="#3333ff">&lt;select id="getPlanOptionFromIdPlan" resultMap="planOptionResult"&gt;
    &lt;include refid="getPlanOptionSql"/&gt;
    WHERE plan_option.i_plan = #id#
  &lt;/select&gt;
  &lt;select id="getEcheanceOptionFromIdPlan" resultMap="echeanceOptionResult"&gt;
    &lt;include refid="getEcheanceOptionSql"/&gt;
    WHERE echeance_option.i_plan = #id#
  &lt;/select&gt;
  &lt;select id="getEcheancePlanFromIdPlan" resultMap="echeancePlanResult"&gt;
    &lt;include refid="getEcheancePlanSql"/&gt;
    WHERE echeance_plan.i_plan = #id#
  &lt;/select&gt;

  &lt;resultMap id="planResult1N" class="plan" extends="planResult"&gt;
    &lt;result property="listEcheanceOption"
select="getEcheanceOptionFromIdPlan" column="plan_i_plan" /&gt;
    &lt;result property="listEcheancePlan"
select="getEcheancePlanFromIdPlan" column="plan_i_plan" /&gt;
    &lt;result property="listPlanOption" select="getPlanOptionFromIdPlan"
column="plan_i_plan" /&gt;
  &lt;/resultMap&gt;

  &lt;select id="getPlan1N" parameterClass="string" resultMap="planResult1N"&gt;
    &lt;include refid="getPlanSql"/&gt;
    $whereStr$
  &lt;/select&gt;
</font>
  </pre>
These selects work with previous version of Ibatis but with 2.2.0, I<br>
have this exception :<br>
    <br>
    <font color="#990000">org.springframework.jdbc.UncategorizedSQLException:
SqlMapClient operation; uncategorized SQLException for SQL []; SQL
state [null]; error code [0];&nbsp;&nbsp; <br>
--- The error occurred in arc/db/auto/dao/ibatis/config/PlanSQL.xml.&nbsp; <br>
--- The error occurred while applying a result map.&nbsp; <br>
--- Check the planResult1N.&nbsp; <br>
--- Check the result mapping for the 'listEcheanceOption' property.&nbsp; <br>
--- Cause: java.lang.NullPointerException; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <br>
--- The error occurred in arc/db/auto/dao/ibatis/config/PlanSQL.xml.&nbsp; <br>
--- The error occurred while applying a result map.&nbsp; <br>
--- Check the planResult1N.&nbsp; <br>
--- Check the result mapping for the 'listEcheanceOption' property.&nbsp; <br>
--- Cause: java.lang.NullPointerException<br>
com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <br>
--- The error occurred in arc/db/auto/dao/ibatis/config/PlanSQL.xml.&nbsp; <br>
--- The error occurred while applying a result map.&nbsp; <br>
--- Check the planResult1N.&nbsp; <br>
--- Check the result mapping for the 'listEcheanceOption' property.&nbsp; <br>
--- Cause: java.lang.NullPointerException<br>
Caused by: java.lang.NullPointerException<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:614)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:231)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:190)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:229)<br>
&nbsp;&nbsp;&nbsp; at
arc.db.auto.dao.ibatis.PlanDAOiBatis.getList1N(PlanDAOiBatis.java:296)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)<br>
&nbsp;&nbsp;&nbsp; at $Proxy0.getList1N(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at
arc.db.auto.dao.ibatis.TestPlanDAOiBatis.testGetList1N(TestPlanDAOiBatis.java:160)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runTest(TestCase.java:154)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runBare(TestCase.java:127)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestResult$1.protect(TestResult.java:106)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.runProtected(TestResult.java:124)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.run(TestResult.java:109)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.run(TestCase.java:118)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.runTest(TestSuite.java:208)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.run(TestSuite.java:203)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)<br>
Caused by: java.lang.NullPointerException<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:780)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:170)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:149)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:880)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:621)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:96)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.loadResult(ResultLoader.java:59)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getNestedSelectMappingValue(BasicResultMap.java:504)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:340)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:375)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:295)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)<br>
&nbsp;&nbsp;&nbsp; ... 35 more<br>
    <br>
Caused by: <br>
java.lang.NullPointerException<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:780)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:170)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:149)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:880)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:621)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:96)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.loadResult(ResultLoader.java:59)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getNestedSelectMappingValue(BasicResultMap.java:504)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:340)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:375)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:295)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:614)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)<br>
&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:231)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:190)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:229)<br>
&nbsp;&nbsp;&nbsp; at
arc.db.auto.dao.ibatis.PlanDAOiBatis.getList1N(PlanDAOiBatis.java:296)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)<br>
&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)<br>
&nbsp;&nbsp;&nbsp; at $Proxy0.getList1N(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at
arc.db.auto.dao.ibatis.TestPlanDAOiBatis.testGetList1N(TestPlanDAOiBatis.java:160)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Unknown Source)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runTest(TestCase.java:154)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runBare(TestCase.java:127)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestResult$1.protect(TestResult.java:106)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.runProtected(TestResult.java:124)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.run(TestResult.java:109)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.run(TestCase.java:118)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.runTest(TestSuite.java:208)<br>
&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.run(TestSuite.java:203)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)<br>
&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)</font><br>
    <br>
    <br>
    <br>
    <pre wrap=""><hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 01/09/2006
  </pre>
  </blockquote>
  <br>
  <pre class="moz-signature" cols="72">-- 
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs</pre>
  <pre wrap="">
<hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 01/09/2006
  </pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs</pre>
</body>
</html>

--------------000502090600050902030507--