You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Eduardo Piva <ed...@gwe.com.br> on 2005/02/24 22:24:42 UTC

NullPointer with lazy-load.

Hello list,

I'm using iBatis with SpringFramework. I have an application that is
working fine today, but without lazy loading. If I enable lazy-load but
does not enable enhancements, it seems that lazy loading does not works,
because I can see the same number of selects going to my database.

If I enable both lazy-load and enhancements, there is just one select
going to my database, witch is correct, but when I try to access a field
of my bean, I get a NullPointerException. It seems that it's something
related to Transactions into a Session.

If I disable transaction in SpringFramework, I continue to have the same
error. Can someone help me? Here are my iBatis map and the error I get.

************** Settings ********************
<settings
		cacheModelsEnabled="true"
		enhancementEnabled="true"
		lazyLoadingEnabled="true"
		useStatementNamespaces="false"
	/>


********* User.xml Map, with some information ommited. *********
  <cacheModel id="userCache" type="MEMORY" readOnly="false">
	<flushInterval hours="24"/>
	<flushOnExecute statement="update-user-info"/>
	<flushOnExecute statement="insert-user"/>
	<property name="reference-type" value="WEAK"/>
  </cacheModel>

  <cacheModel id="roleCache" type="MEMORY" readOnly="false">
	<flushInterval hours="24"/>
	<flushOnExecute statement="insert-role"/>
	<flushOnExecute statement="remove-role"/>
	<property name="reference-type" value="WEAK"/>
  </cacheModel>

  <resultMap id="userResult" class="br.com.gwe.domain.User">
	<result property="login" column="username"/>
	<result property="name" column="name"/>
	<result property="telephone" column="telephone"/>
	<result property="celphone" column="celphone"/>
	<result property="roles" column="username" select="get-role"/>
  </resultMap>

  <resultMap id="roleResult" class="br.com.gwe.domain.Role">
	<result property="code" column="authority"/>
	<result property="description" column="description"/>
  </resultMap>

  <statement id="get-user-by-login" resultMap="userResult"
parameterClass="java.lang.String" cacheModel="userCache">
	select username, name, telephone, celphone from users where username =
#param#
  </statement>

  <statement id="get-role" resultMap="roleResult"
parameterClass="java.lang.String" cacheModel="roleCache">
	 select * from authorities, valid_authorities where username = #param#
and authorities.authority = valid_authorities.authority
  </statement>

************* Error *********************
java.lang.NullPointerException
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:776)
	com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:141)
	com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:114)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:860)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:617)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
	com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
	com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
	com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)
	com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:130)
	com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.invoke(EnhancedLazyResultLoader.java:113)
	$java.util.List$$EnhancerByCGLIB$$7e9071fc.toString(<generated>)
	java.lang.String.valueOf(String.java:2131)
	java.lang.StringBuffer.append(StringBuffer.java:370)
	br.com.gwe.web.controller.UserController.formBackingObject(UserController.java:109)
	org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:270)
	org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:240)
	org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:522)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:321)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
	com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
	net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:70)
	net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:169)
	net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
	net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter(AbstractIntegrationFilter.java:170)
	net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
	net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:333)
	net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)

If you need more information, just ask me that I can provide it. I've
ommited a lot of XML, since it is a full application and it would flood
this email.

-- 
Eduardo Piva
GWE Software
+55 (19) 3254-7633
+55 (19) 8114-9488
www.gwe.com.br



Re: NullPointer with lazy-load.

Posted by Clinton Begin <cl...@gmail.com>.
Thanks Eduardo, for finding the problem....and sharing the solution.  :-)

Clinton


On Fri, 25 Feb 2005 00:01:20 -0300, Eduardo Piva <ed...@gwe.com.br> wrote:
> 
> Found it.
> 
> I forgot to add a <transaction/> tag in my sql-map. Here it is, for
> those who eventually will have the same error:
> 
> <transactionManager type="JDBC">
> <dataSource type="DBCP">
>         <property name="JDBC.Driver" value="${jdbc.driverClassName}"/>
>         <property name="JDBC.ConnectionURL" value="${jdbc.url}"/>
>         <property name="JDBC.Username" value="${jdbc.username}"/>
>         <property name="JDBC.Password" value="${jdbc.password}"/>
> </dataSource>
> </transactionManager>
> 
> On Thu, 2005-02-24 at 18:24, Eduardo Piva wrote:
> > Hello list,
> >
> > I'm using iBatis with SpringFramework. I have an application that is
> > working fine today, but without lazy loading. If I enable lazy-load but
> > does not enable enhancements, it seems that lazy loading does not works,
> > because I can see the same number of selects going to my database.
> >
> > If I enable both lazy-load and enhancements, there is just one select
> > going to my database, witch is correct, but when I try to access a field
> > of my bean, I get a NullPointerException. It seems that it's something
> > related to Transactions into a Session.
> >
> > If I disable transaction in SpringFramework, I continue to have the same
> > error. Can someone help me? Here are my iBatis map and the error I get.
> >
> > ************** Settings ********************
> > <settings
> >               cacheModelsEnabled="true"
> >               enhancementEnabled="true"
> >               lazyLoadingEnabled="true"
> >               useStatementNamespaces="false"
> >       />
> >
> >
> > ********* User.xml Map, with some information ommited. *********
> >   <cacheModel id="userCache" type="MEMORY" readOnly="false">
> >       <flushInterval hours="24"/>
> >       <flushOnExecute statement="update-user-info"/>
> >       <flushOnExecute statement="insert-user"/>
> >       <property name="reference-type" value="WEAK"/>
> >   </cacheModel>
> >
> >   <cacheModel id="roleCache" type="MEMORY" readOnly="false">
> >       <flushInterval hours="24"/>
> >       <flushOnExecute statement="insert-role"/>
> >       <flushOnExecute statement="remove-role"/>
> >       <property name="reference-type" value="WEAK"/>
> >   </cacheModel>
> >
> >   <resultMap id="userResult" class="br.com.gwe.domain.User">
> >       <result property="login" column="username"/>
> >       <result property="name" column="name"/>
> >       <result property="telephone" column="telephone"/>
> >       <result property="celphone" column="celphone"/>
> >       <result property="roles" column="username" select="get-role"/>
> >   </resultMap>
> >
> >   <resultMap id="roleResult" class="br.com.gwe.domain.Role">
> >       <result property="code" column="authority"/>
> >       <result property="description" column="description"/>
> >   </resultMap>
> >
> >   <statement id="get-user-by-login" resultMap="userResult"
> > parameterClass="java.lang.String" cacheModel="userCache">
> >       select username, name, telephone, celphone from users where username =
> > #param#
> >   </statement>
> >
> >   <statement id="get-role" resultMap="roleResult"
> > parameterClass="java.lang.String" cacheModel="roleCache">
> >        select * from authorities, valid_authorities where username = #param#
> > and authorities.authority = valid_authorities.authority
> >   </statement>
> >
> > ************* Error *********************
> > java.lang.NullPointerException
> >       com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:776)
> >       com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:141)
> >       com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:114)
> >       com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:860)
> >       com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:617)
> >       com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >       com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >       com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >       com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)
> >       com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:130)
> >       com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.invoke(EnhancedLazyResultLoader.java:113)
> >       $java.util.List$$EnhancerByCGLIB$$7e9071fc.toString(<generated>)
> >       java.lang.String.valueOf(String.java:2131)
> >       java.lang.StringBuffer.append(StringBuffer.java:370)
> >       br.com.gwe.web.controller.UserController.formBackingObject(UserController.java:109)
> >       org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:270)
> >       org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:240)
> >       org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
> >       org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> >       org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:522)
> >       org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:321)
> >       javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >       com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
> >       com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
> >       net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:70)
> >       net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:169)
> >       net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
> >       net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter(AbstractIntegrationFilter.java:170)
> >       net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
> >       net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:333)
> >       net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
> >
> > If you need more information, just ask me that I can provide it. I've
> > ommited a lot of XML, since it is a full application and it would flood
> > this email.
> --
> Eduardo Piva
> GWE Software
> +55 (19) 3254-7633
> +55 (19) 8114-9488
> www.gwe.com.br
> 
>

Re: NullPointer with lazy-load.

Posted by Eduardo Piva <ed...@gwe.com.br>.
Found it.

I forgot to add a <transaction/> tag in my sql-map. Here it is, for
those who eventually will have the same error:

<transactionManager type="JDBC">
<dataSource type="DBCP">
	<property name="JDBC.Driver" value="${jdbc.driverClassName}"/>
	<property name="JDBC.ConnectionURL" value="${jdbc.url}"/>
	<property name="JDBC.Username" value="${jdbc.username}"/>
	<property name="JDBC.Password" value="${jdbc.password}"/>
</dataSource>
</transactionManager>

On Thu, 2005-02-24 at 18:24, Eduardo Piva wrote:
> Hello list,
> 
> I'm using iBatis with SpringFramework. I have an application that is
> working fine today, but without lazy loading. If I enable lazy-load but
> does not enable enhancements, it seems that lazy loading does not works,
> because I can see the same number of selects going to my database.
> 
> If I enable both lazy-load and enhancements, there is just one select
> going to my database, witch is correct, but when I try to access a field
> of my bean, I get a NullPointerException. It seems that it's something
> related to Transactions into a Session.
> 
> If I disable transaction in SpringFramework, I continue to have the same
> error. Can someone help me? Here are my iBatis map and the error I get.
> 
> ************** Settings ********************
> <settings
> 		cacheModelsEnabled="true"
> 		enhancementEnabled="true"
> 		lazyLoadingEnabled="true"
> 		useStatementNamespaces="false"
> 	/>
> 
> 
> ********* User.xml Map, with some information ommited. *********
>   <cacheModel id="userCache" type="MEMORY" readOnly="false">
> 	<flushInterval hours="24"/>
> 	<flushOnExecute statement="update-user-info"/>
> 	<flushOnExecute statement="insert-user"/>
> 	<property name="reference-type" value="WEAK"/>
>   </cacheModel>
> 
>   <cacheModel id="roleCache" type="MEMORY" readOnly="false">
> 	<flushInterval hours="24"/>
> 	<flushOnExecute statement="insert-role"/>
> 	<flushOnExecute statement="remove-role"/>
> 	<property name="reference-type" value="WEAK"/>
>   </cacheModel>
> 
>   <resultMap id="userResult" class="br.com.gwe.domain.User">
> 	<result property="login" column="username"/>
> 	<result property="name" column="name"/>
> 	<result property="telephone" column="telephone"/>
> 	<result property="celphone" column="celphone"/>
> 	<result property="roles" column="username" select="get-role"/>
>   </resultMap>
> 
>   <resultMap id="roleResult" class="br.com.gwe.domain.Role">
> 	<result property="code" column="authority"/>
> 	<result property="description" column="description"/>
>   </resultMap>
> 
>   <statement id="get-user-by-login" resultMap="userResult"
> parameterClass="java.lang.String" cacheModel="userCache">
> 	select username, name, telephone, celphone from users where username =
> #param#
>   </statement>
> 
>   <statement id="get-role" resultMap="roleResult"
> parameterClass="java.lang.String" cacheModel="roleCache">
> 	 select * from authorities, valid_authorities where username = #param#
> and authorities.authority = valid_authorities.authority
>   </statement>
> 
> ************* Error *********************
> java.lang.NullPointerException
> 	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:776)
> 	com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:141)
> 	com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:114)
> 	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:860)
> 	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:617)
> 	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> 	com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> 	com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> 	com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:72)
> 	com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:130)
> 	com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.invoke(EnhancedLazyResultLoader.java:113)
> 	$java.util.List$$EnhancerByCGLIB$$7e9071fc.toString(<generated>)
> 	java.lang.String.valueOf(String.java:2131)
> 	java.lang.StringBuffer.append(StringBuffer.java:370)
> 	br.com.gwe.web.controller.UserController.formBackingObject(UserController.java:109)
> 	org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:270)
> 	org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:240)
> 	org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
> 	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
> 	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:522)
> 	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:321)
> 	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> 	com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
> 	com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
> 	net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:70)
> 	net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:169)
> 	net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
> 	net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter(AbstractIntegrationFilter.java:170)
> 	net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
> 	net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:333)
> 	net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:105)
> 
> If you need more information, just ask me that I can provide it. I've
> ommited a lot of XML, since it is a full application and it would flood
> this email.
-- 
Eduardo Piva
GWE Software
+55 (19) 3254-7633
+55 (19) 8114-9488
www.gwe.com.br