Return-Path: 
 <user-java-return-7085-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 57219 invoked from network); 15 May 2006 03:55:02 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 15 May 2006 03:55:02 -0000
Received: (qmail 10402 invoked by uid 500); 15 May 2006 03:54:31 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 8452 invoked by uid 500); 15 May 2006 03:54:21 -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 8133 invoked by uid 99); 15 May 2006 03:54:17 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 14 May 2006 20:54:17 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Received: from [202.58.71.77] (HELO ekalifid1.ekalife.co.id) (202.58.71.77)
    by apache.org (qpsmtpd/0.29) with SMTP; Sun, 14 May 2006 20:24:44 -0700
Received: (qmail 26244 invoked from network); 15 May 2006 03:24:21 -0000
X-NetworkBox-HamSign: 0101;OUT;ekalifid1;5f112ec436bb37f8953f10f0eede22a1;
Received: from unknown (HELO ekalife.co.id) (128.21.32.2)
  by 128.21.32.27 with SMTP; 15 May 2006 03:24:20 -0000
Received: from ekamailserver.ekalife2000.com [128.21.32.15] by ekalife.co.id
 [128.21.32.2]
	with SMTP (MDaemon.v3.5.8.R)
	for <user-java@ibatis.apache.org>; Mon, 15 May 2006 10:22:04 +0700
Subject: RE: Exception net.sf.cglib.beans.BulkBeanException on resultMap with
 selects
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Mon, 15 May 2006 10:23:19 +0700
X-MimeOLE: Produced By Microsoft Exchange V6.0.4417.0
Message-ID: 
 <BBB07C847BBE5A49B3A849A8DE7E56CF01075D1C@ekamailserver.ekalife2000.com>
Content-class: urn:content-classes:message
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Exception net.sf.cglib.beans.BulkBeanException on resultMap with
 selects
Thread-Index: AcZ3yvaMX8b7/Ur/SbyJMv0f5lLJuwAA3omQ
From: "Yusuf" <Yusuf@ekalife.co.id>
To: <user-java@ibatis.apache.org>
X-MDRemoteIP: 128.21.32.15
X-Return-Path: Yusuf@ekalife.co.id
X-MDaemon-Deliver-To: user-java@ibatis.apache.org
X-Scanned-By-ekalifid1: Virus scan performed by network-box
X-Scanned-By-ekalifid1: Scanner file id is ekalifid1-1147663460.977-26241-000
X-Scanned-By-ekalifid1: No known viruses found in message (received+scanned in
 0.03/0.10 secs)
X-Scanned-By-ekalifid1: Spam-Check-Result: No,
 hits=0 required=7 tests= autolearn=no version=2.0
X-Virus-Checked: Checked by ClamAV on apache.org
X-Old-Spam-Status: No
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi, I found the solution.. sorry about this, guess I'll have to re-check
my "double checking" effort..
its only a class casting issue (i've mapped a String column to an Int)

Yusuf.


-----Original Message-----
From: Yusuf=20
Sent: Monday, May 15, 2006 9:55 AM
To: user-java@ibatis.apache.org
Subject: Exception net.sf.cglib.beans.BulkBeanException on resultMap
with selects

Hi, I have a sqlMap like this=20

<sqlMap namespace=3D"eb.proposal">

	<resultMap id=3D"selectPlanProposal.result" class=3D"planProposal">
		<result property=3D"mpps_no" column=3D"mpps_no"
javaType=3D"string" jdbcType=3D"CHAR" nullValue=3D""/>

		<result property=3D"lsbs_id" column=3D"lsbs_id"
javaType=3D"int" jdbcType=3D"NUMBER" />

		<result property=3D"lsdbs_number" column=3D"lsdbs_number"
javaType=3D"int" jdbcType=3D"NUMBER" />

		<result property=3D"flag_guna" column=3D"{mpps_no=3Dmpps_no,
lsbs_id=3Dlsbs_id, lsdbs_number=3Dlsdbs_number}" javaType=3D"int"
nullValue=3D"0" select=3D"eb.proposal.selectGunaBenefit"/>
	</resultMap>
=09
	<select id=3D"selectGunaBenefit" resultClass=3D"int">
		SELECT ...=20
		  FROM eka.mst_proposal_benefit a
		 WHERE mpps_no =3D replace(#mpps_no#,'.','')
		   AND lsbs_id =3D #lsbs_id#
		   AND lsdbs_number =3D #lsdbs_number#
	</select>
=09
=09
	<select id=3D"selectPlanProposal" parameterClass=3D"hashMap"
resultMap=3D"selectPlanProposal.result">
		select ... from eka.mst_plan_proposal
	</select>=09

</sqlMap>

and the resultClass like this :=20

	public class PlanProposal implements Serializable {
		private String mpps_no;
		private Integer lsbs_id;
		private Integer mpp_gol;
		private Integer ltp_kode_before;
		private Integer lsdbs_number_before;
		private Integer ltp_kode;
		private Integer lsdbs_number;
		private Integer lpv_kode;
		private Integer msp_ganti;
		private Integer msp_turun_limit;
		private Integer msp_rujukan;
		private String lpv_desc;
		private String rujukan;
		private String update_flag;
		private Integer msp_aktif;        =20
		private String lsdbs_lama_bayar;
		private Integer flag_guna;
		// .. getter setter..
	}
=09
before I add this last column in the resultMap (the one with the select
query) :=20

		<result property=3D"flag_guna" column=3D"{mpps_no=3Dmpps_no,
lsbs_id=3Dlsbs_id, lsdbs_number=3Dlsdbs_number}" javaType=3D"int"
nullValue=3D"0" select=3D"eb.proposal.selectGunaBenefit"/>

the query was working, but after I add that, an exception occured :=20

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation; uncategorized SQLException for SQL []; SQL state [null];
error code [0];  =20
--- The error occurred in com/ekalife/eb/dao/sql/proposal/select.xml. =20
--- The error occurred while applying a result map. =20
--- Check the selectPlanProposal.result. =20
--- The error happened while setting a property on the result object. =20
--- Cause: net.sf.cglib.beans.BulkBeanException; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error occurred in com/ekalife/eb/dao/sql/proposal/select.xml. =20
--- The error occurred while applying a result map. =20
--- Check the selectPlanProposal.result. =20
--- The error happened while setting a property on the result object. =20
--- Cause: net.sf.cglib.beans.BulkBeanException
com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error occurred in com/ekalife/eb/dao/sql/proposal/select.xml. =20
--- The error occurred while applying a result map. =20
--- Check the selectPlanProposal.result. =20
--- The error happened while setting a property on the result object. =20
--- Cause: net.sf.cglib.beans.BulkBeanException
Caused by: net.sf.cglib.beans.BulkBeanException
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:184)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:119)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:610)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:584)
	at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:105)
	at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClient
Impl.java:77)
	at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:245)
	at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:165)
	at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:204)
	at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:243)
	at com.ekalife.eb.dao.BaseDao.query(BaseDao.java:25)
	at
com.ekalife.eb.dao.ProposalDao.selectPlanProposal(ProposalDao.java:250)
	at
com.ekalife.eb.service.EbManager.selectPlanProposal(EbManager.java:96)
	at
com.ekalife.eb.service.EbManager$$FastClassByCGLIB$$aec9520a.invoke(<gen
erated>)
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
	at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.i
nvokeJoinpoint(Cglib2AopProxy.java:698)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref
lectiveMethodInvocation.java:122)
	at
org.springframework.transaction.interceptor.TransactionInterceptor.invok
e(TransactionInterceptor.java:96)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref
lectiveMethodInvocation.java:144)
	at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedIntercept
or.intercept(Cglib2AopProxy.java:643)
	at
com.ekalife.eb.service.EbManager$$EnhancerByCGLIB$$3111cbcf.selectPlanPr
oposal(<generated>)
	at
com.ekalife.eb.web.proposal.InputManfaatAsuransi.onBind(InputManfaatAsur
ansi.java:89)
	at
org.springframework.web.servlet.mvc.BaseCommandController.bindAndValidat
e(BaseCommandController.java:306)
	at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequest
Internal(AbstractFormController.java:255)
	at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abs
tractController.java:139)
	at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handl
e(SimpleControllerHandlerAdapter.java:44)
	at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS
ervlet.java:684)
	at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe
rvlet.java:625)
	at
org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor
kServlet.java:392)
	at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet
.java:357)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFi
lter.java:125)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:214)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
	at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon
textValve.java:198)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:152)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:137)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:118)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:102)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79
9)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:705)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57
7)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Thread.java:534)
Caused by: net.sf.cglib.beans.BulkBeanException
	at
com.ekalife.eb.model.PlanProposal$$BulkBeanByCGLIB$$f213aa8c.setProperty
Values(<generated>)
	at
com.ibatis.sqlmap.engine.accessplan.EnhancedPropertyAccessPlan.setProper
ties(EnhancedPropertyAccessPlan.java:33)
	at
com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanD
ataExchange.java:112)
	at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectVa
lues(BasicResultMap.java:325)
	at
com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResu
ltObject(RowHandlerCallback.java:63)
	at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor
.java:364)
	at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:184)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:201)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:169)
	... 58 more
Caused by: java.lang.ClassCastException
	... 67 more

i've double checked the result class, the sql mappings, and also in log,
i've seen the inner select already called the result is shown too,=20
is there anyone who knows the solution to this problem?=20

thank you,
Yusuf.