...to proceed with Closed Statement Exception

[2002 JI Open Discussion]

By: Allan Kos - theincongruent

...to proceed with Closed Statement Exception

2003-12-18 14:26

So, what can I do about the Closed Statement exception I keep getting in WAS 5.1 with jasperreports?

 

What does this exception mean? the statements were never closed before being returned to the pool?

 

-----

 

java.sql.SQLException: Closed Statement

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)

at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:66

48)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar

edStatement.java:595)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare

dStatement.java:536)

at weblogic.jdbc20.pool.PreparedStatement.executeQuery(PreparedStatement

.java:35)

at weblogic.jdbc20.rmi.internal.PreparedStatementImpl.executeQuery(Prepa

redStatementImpl.java:46)

at weblogic.jdbc20.rmi.SerialPreparedStatement.executeQuery(SerialPrepar

edStatement.java:40)

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.

java:375)

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.

java:142)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav

a:219)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav

a:159)

at com.telus.tpmt.webapp.TpmtReports.ReportGenerator.generate(ReportGene

rator.java:135)

at com.telus.tpmt.webapp.TpmtReports.GetReportServlet.doPost(GetReportSe

rvlet.java:130)

at com.telus.tpmt.webapp.TpmtReports.GetReportServlet.doGet(GetReportSer

vlet.java:45)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:120)

at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon

textImpl.java:915)

at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon

textImpl.java:879)

at weblogic.servlet.internal.ServletContextManager.invokeServlet(Servlet

ContextManager.java:269)

at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.jav

a:365)

at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:253)

 

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)

 

NESTED BY :

dori.jasper.engine.JRException: Error executing report query :

 

SELECT S_TITLE, PROJECT.S_DESCRIPTION, PROJECT.F_DEPT_ID, E3.S_FIRST_NAME S_FIRS

T_NAME, E3.S_LAST_NAME S_LAST_NAME, S_TRAFFIC_SCHEDULE, S_TRAFFIC_BUDGET, S_TRA

FFIC_RESOURCE, S_PHASE, L_PROJECT_ID, B_RELEASES, MLC_PRIORITY.S_TYPE MLCTYPE,

MLC_PRIORITY.L_PRIORITY_ID MLCPRIORITYID

 

FROM PROJECT, DEPT PROJDEPT, MLC_PRIORITY, DIVISION TOPDIV, DEPT D1, DIVISION PA

RENTDIV, DEPT D2, DIVISION DIV, DEPT D3, EMPLOYEE E3

 

WHERE DIV.L_PARENT_DIV_ID = PARENTDIV.L_DIV_ID

AND PARENTDIV.L_PARENT_DIV_ID = TOPDIV.L_DIV_ID

AND DIV.L_DEPT_ID = D3.L_DEPT_ID

AND E3.L_EMPLOYEE_ID (+)= D3.L_MANAGER_EMPLOYEE_ID

AND PARENTDIV.L_DEPT_ID = D2.L_DEPT_ID

AND TOPDIV.L_DEPT_ID = D1.L_DEPT_ID

AND PROJDEPT.L_DEPT_ID = PROJECT.L_DEPT_ID

AND PROJDEPT.L_DIVISION_ID (+)= DIV.L_DIV_ID

AND DIV.B_ACTIVE = -1

AND L_FISCAL_YEAR = 2003

AND L_PROJECT_STATUS_ID = 2

AND S_BUDGET_TYPE <> 'EXPENSE'

AND S_PHASE <> 'Rollout'

AND B_TRACKING_ONLY = 0

AND L_MLC_PRIORITY_NEW = MLC_PRIORITY.L_MLC_PRIORITY_ID

 

 

ORDER BY E3.S_FIRST_NAME, E3.S_LAST_NAME

 

 

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.

java:379)

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.

java:142)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav

a:219)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav

a:159)

at com.telus.tpmt.webapp.TpmtReports.ReportGenerator.generate(ReportGene

rator.java:135)

at com.telus.tpmt.webapp.TpmtReports.GetReportServlet.doPost(GetReportSe

rvlet.java:130)

at com.telus.tpmt.webapp.TpmtReports.GetReportServlet.doGet(GetReportSer

vlet.java:45)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:120)

at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon

textImpl.java:915)

at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon

textImpl.java:879)

at weblogic.servlet.internal.ServletContextManager.invokeServlet(Servlet

ContextManager.java:269)

at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.jav

a:365)

at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:253)

 

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)

closed conn

Thu Dec 18 16:43:57 EST 2003:<E> <WebAppServletContext-tpmt> Servlet failed with

Exception

java.lang.NullPointerException

at com.telus.tpmt.webapp.TpmtReports.GetReportServlet.doPost(GetReportSe

rvlet.java:149)

at com.telus.tpmt.webapp.TpmtReports.GetReportServlet.doGet(GetReportSer

vlet.java:45)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:120)

at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon

textImpl.java:915)

at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletCon

textImpl.java:879)

at weblogic.servlet.internal.ServletContextManager.invokeServlet(Servlet

ContextManager.java:269)

at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.jav

a:365)

at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:253)

 

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)

 

 

 

 

 

By: Teodor Danciu - teodord

RE: ...to proceed with Closed Statement Excep

2003-12-18 14:31

 

Hi,

 

The SQL query execution code has been revised

in JasperReports.

The new version is available on CVS and I suggest

you try it to see if your problem persist.

 

Thank you,

Teodor