configuration help: pool problems create deadlocks

[dr_pompeii]

What I was getting at here though is what releases the ResultSet?

 String query = "SELECT * FROM CabeceraAlmacen c, DetalleAlmacen d, Articulo a, Medida m  WHERE " +
	        " c.idnumero=d.idnumero AND c.serie=d.serie AND " +
	        " d.idArticulo=a.idArticulo AND a.idMedida=m.idMedida AND " +
	        " c.serie='SAL' AND c.idnumero=?";

see bold part , 4 classes

the ResultSet should return a header with its detail used by jasper report , thats all

[karldmoore]

But if you look at your code, you get a connection, execute a query and you have an open ResultSet that you give to Jasper reports. I'm just wondering what actually releases that.

[dr_pompeii]

But if you look at your code, you get a connection, execute a query and you have an open ResultSet that you give to Jasper reports.

thats right, like the book

I'm just wondering what actually releases that

it seems that i should close the ResultSet right???


thanks for advanced

[karldmoore]

Well as I said I haven't used this bit before but I would have thought you'd have to close it once you've generated the report.

    finally
    {
      //boilerplate code to close the result set, statement, and exception
    }

http://www.ensode.net/jasperreports_database_pg3.html

[dr_pompeii]

Well as I said I haven't used this bit before but I would have thought you'd have to close it once you've generated the report.

yes, it seems, really wondered why this not appear in the book

thanks for the link, i am not in my home now so i will test this in the night

one favor,can you show an extract of your code, when you use JRBeanCollectionDataSource but with more classes to fill the object,
like my case when i use the JRResultSetDataSource???

regards

and thanks for your time

[karldmoore]

one favor,can you show an extract of your code, when you use JRBeanCollectionDataSource but with more classes to fill the object, like my case when i use the JRResultSetDataSource???

The code was from a previous closed sourced project so I can't post it here. I'm sure there are lots of good examples on the net though.

[dr_pompeii]

The code was from a previous closed sourced project so I can't post it here.

privacy code mmm

dont worry man, thanks for your time

I'm sure there are lots of good examples on the net though.

i will see

regards

[karldmoore]

I think the implementation is conceptually the same thing, it's just that you have packaged up the data in objects instead of reading it from the ResultSet.

[dr_pompeii]

hi karl

pls see this code

@Override
protected Event doExecute(RequestContext context)throws Exception{
   logger.info("\n TransaccionSalidaAlmacenJasperReportAction doExecute \n");
   Connection connection=null;
    PreparedStatement ps=null;
    ResultSet resultSet=null;
    try{
    	CabeceraSalidaAlmacen cabeceraSalidaAlmacen = 
    		(CabeceraSalidaAlmacen) (context.getFlowScope().get("cabeceraSalidaAlmacenCommand"));
    	AlmacenPK almacenPK = cabeceraSalidaAlmacen.getAlmacenPK();
	       	    
    	String query = " SELECT * FROM CabeceraAlmacen c, DetalleAlmacen d, Articulo             
                              a, Medida m  WHERE " +
	    			 " c.idnumero=d.idnumero AND c.serie=d.serie AND " +
	    			  " d.idArticulo=a.idArticulo AND a.idMedida=m.idMedida AND " +
	    			  " c.serie='SAL' AND c.idnumero=?";
	    		 
	    	connection = dataSource.getConnection();
	    	ps=connection.prepareStatement(query);
	    	ps.setString(1, almacenPK.getIdnumero());
	    	resultSet = ps.executeQuery();	    
	    
	    	JRResultSetDataSource resultSetDataSource = new JRResultSetDataSource(resultSet);
	    	context.getRequestScope().put("datasource", resultSetDataSource);
	    	
	    }
	    catch(Exception e){
		logger.info("\n TransaccionSalidaAlmacenJasperReportAction doExecute  
                                 Exception: \n"+
					e.getMessage() );
		}
		finally{
			logger.info("\n TransaccionSalidaAlmacenJasperReportAction doExecute B4 CLOSE RS");
			resultSet.close();
			logger.info("\n TransaccionSalidaAlmacenJasperReportAction doExecute A4 CLOSE RS");
		}
		return success();
	}

my log

08:23:48 INFO                    TransaccionSalidaAlmacenJasperReportAction doExecute                 
 TransaccionSalidaAlmacenJasperReportAction doExecute 

08:23:48 INFO                    TransaccionSalidaAlmacenJasperReportAction doExecute                 
 TransaccionSalidaAlmacenJasperReportAction doExecute B4 CLOSE RS
08:23:48 INFO                    TransaccionSalidaAlmacenJasperReportAction doExecute                 
 TransaccionSalidaAlmacenJasperReportAction doExecute A4 CLOSE RS
08:23:50 ERROR tainerBase.[Catalina].[localhost].[/lagranjita].[lagranjita] invoke                    Servlet.service() para servlet lagranjita lanzó excepción
net.sf.jasperreports.engine.JRException: Unable to get next record.
	at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:99)
	at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:842)
	at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:760)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1078)
	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:107)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:751)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:679)
	at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89)
	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)
	at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.fillReport(AbstractJasperReportsView.java:604)
	at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.renderMergedOutputModel(AbstractJasperReportsView.java:546)
	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247)
	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.SQLException: You can't operate on a closed ResultSet!!!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:3047)
	at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:95)
	... 54 more
Caused by: java.lang.NullPointerException
	at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:3041)
	... 55 more

i am doom, how i can resolve this karl???

thanks for advanced

[karldmoore]

I think if you need to close anything, it's going to need to be after you've built the report.