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
