You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by Aymeric Alibert <Ay...@alliantenergy.com> on 2004/12/21 15:53:25 UTC
Re: [jira] Created: (IBATIS-33) Complex Collection Properties
& Statement Namespaces
Brandon,
I dig a little more into that issue and it appears that it is not
specific to namespaces (as I first thought)
I can reproduce the problem on a separate web application when the 3
following condition are present:
- The application is using Spring + IBATIS.
- IBATIS uses complex collection properties to retrieve data.
- The <settings> tag is present in the sql-map-config.xml file. It
actually fails even if that tag is empty (<settings/>).
I have a small web application as a test case that I tried to upload to
JIRA, but I get a 'Bad Gateway' error.
Thanks,
Aymeric.
>>> brandon.goodin@gmail.com 12/20/2004 10:24:08 AM >>>
What is the type of your roles property? It appears that you are
trying to return a List of ints? Could you please provide more
information on the underlying code?
Brandon
On Mon, 20 Dec 2004 08:07:21 -0800 (PST), Aymeric Alibert (JIRA)
<ib...@incubator.apache.org> wrote:
> Complex Collection Properties & Statement Namespaces
> ----------------------------------------------------
>
> Key: IBATIS-33
> URL: http://nagoya.apache.org/jira/browse/IBATIS-33
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.8
> Environment: Windows XP - Weblogic 8.1.4 - Oracle 8.1.7
> Spring with IBATIS 2.0.8
> Reporter: Aymeric Alibert
>
> Complex collection properties does not seem to work when statement
namespaces are enabled.
> I have a running application developped using IBATIS 2.0.8. I decided
to enable statement namespaces and did the following changes:
> sql-map.config:
> <settings useStatementNamespaces="true"/>
>
> java class:
> public AgentAccount findAccountByAgentId(String agentId) {
> return (AgentAccount)
getSqlMapClientTemplate().queryForObject("MyNameSpace.getAgentAccountById",agentId);
> }
>
> sqlmap.xml:
> <sqlMap namespace="MyNameSpace">
> <resultMap id="agentAccountResult"
class="com.alliantenergy.csi.energyassistance.business.domain.AgentAccount">
> <result property="agentId" column="AGENT_ID"/>
> <result property="roles" column="AGENT_ID"
select="MyNameSpace.getAgentRoles"/>
> </resultMap>
>
> <select id="getAgentAccountById" resultMap="agentAccountResult">
> select
> AGENT_ID
> from EAC_AGENT
> where AGENT_ID = #value#
> </select>
>
> <select id="getAgentRoles" resultClass="int">
> select ROLE_ID from EAC_AGENT_ROLE where AGENT_ID = #value#
> </select>
>
> Note that I am using 'MyNameSpace.getAgentRoles' for the sub query.
> IBATIS load the map fine but fails at runtime with the following
exception:
>
> java.io.NotSerializableException:
com.ibatis.sqlmap.engine.mapping.result.loader.LazyResultLoader
> java.rmi.UnmarshalException: cannot unmarshaling return; nested
exception is:
> java.io.NotSerializableException:
com.ibatis.sqlmap.engine.mapping.result.loader.LazyResultLoader
> at
weblogic.rmi.internal.ServerRequest.unmarshalReturn(ServerRequest.java:102)
> at
weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:285)
> at
weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:244)
> at
com.alliantenergy.csi.energyassistance.remote.ejb.AccountManagement_cqphao_EOImpl_813_WLStub.authenticate(Unknown
Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
org.springframework.remoting.rmi.RmiClientInterceptorUtils.doInvoke(RmiClientInterceptorUtils.java:103)
> at
org.springframework.ejb.access.SimpleRemoteSlsbInvokerInterceptor.doInvoke(SimpleRemoteSlsbInvokerInterceptor.java:76)
> at
org.springframework.ejb.access.AbstractRemoteSlsbInvokerInterceptor.invoke(AbstractRemoteSlsbInvokerInterceptor.java:78)
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143)
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
> at $Proxy16.authenticate(Unknown Source)
> at
com.alliantenergy.csi.ui.energyassistance.presentation.agentservice.LogonAction.doExecute(LogonAction.java:88)
> at
com.alliantenergy.csi.ui.energyassistance.framework.struts.BaseAction.execute(BaseAction.java:126)
> at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
> at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
> at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
> at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
> at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
> at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
> at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452)
> at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
> at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
> at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
> at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
> at
weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
> Caused by: java.io.NotSerializableException:
com.ibatis.sqlmap.engine.mapping.result.loader.LazyResultLoader
> at
java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1054)
> at
java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1332)
> at
java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1304)
> at
java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1247)
> at
java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052)
> at
java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1332)
> at
java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1304)
> at
java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1247)
> at
java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052)
> at
java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:278)
> at
weblogic.rmi.internal.CBVOutputStream.writeObject(CBVOutputStream.java:78)
> at
weblogic.rmi.internal.ServerRequest.unmarshalReturn(ServerRequest.java:94)
> ... 31 more
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the
administrators:
> http://nagoya.apache.org/jira/secure/Administrators.jspa
> -
> If you want more information on JIRA, or have a bug to report see:
> http://www.atlassian.com/software/jira
>
>