SQLException on con.prepareStatement()

[Aravind Ramanujam]

Hi

I'm getting the following exception when i try to create the PreparedStatement.

com.ibm.db2.jcc.b.SQLException: invalid operation: connection closed

I'm using a DB2 Universal JDBC Driver Provider Datasource. Connection is getting created successfully but the preparedStatement is not getting created. I've given my code snippet below:

  
String olQry = "select count(*) from employee";
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
DataSource ds = (javax.sql.DataSource) ctx.lookup("olDS");
System.out.println("1");
Connection conn = ds.getConnection();
System.out.println("2");
PreparedStatement pstmt = conn.prepareStatement(olQry);
System.out.println("3");
ResultSet olRS = pstmt.executeQuery();
System.out.println("4");

The above code is failing after "2" and giving the following Exception

&&&&&&&& EXCEPTION STACK TRACE &&&&&&&&&

com.ibm.db2.jcc.b.SQLException: invalid operation: connection closed
at com.ibm.db2.jcc.b.l.K(l.java(Compiled Code))
at com.ibm.db2.jcc.b.l.b(l.java:918)
at com.ibm.db2.jcc.b.l.prepareStatement(l.java:764)
at com.ibm.db2.jcc.b.bn.prepareStatement(bn.java:276)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareStatement(WSJdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at gov.ca.dmv.olinq.dao.OlDAO.getData(OlDAO.java(Compiled Code))
at gov.ca.dmv.olinq.struts.action.SearchAction.execute(SearchAction.java(Compiled Code))
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at gov.ca.dmv.egov.journaling.JournalFilter.doFilter(JournalFilter.java:93)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)

&&&&&&&& END EXCEPTION STACK TRACE &&&&&&&&&

I don't know what i'm doing wrong. Any help is appreciated.

Thanks
- Aravindan R -
[ December 30, 2005: Message edited by: Aravind Ramanujam ]

[Paul Clapham]

If you call the conn.isClosed() method instead of the prepareStatement() method, what result do you get?