wood burning stoves 2.0*
The moose likes JDBC and the fly likes Null Pointer Exception on stmt = conn.prepareStatement( query); Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Null Pointer Exception on stmt = conn.prepareStatement( query);" Watch "Null Pointer Exception on stmt = conn.prepareStatement( query);" New topic
Author

Null Pointer Exception on stmt = conn.prepareStatement( query);

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
I configured the Tomcat 5.0.27 for using the connection pool feature and connecting to the Oracle. I am testing if I did the configuration correctly. Therefore, I try to retrieve some data from a table. I got the
'Null Pointer Exception" when executing the

I am not sure where the problem is from.
1. configuration is not done properly?
2. some bugs in my program?

I need your help to diagnose the problem. The messages in the Tomcat log are shown below my program coce.

The code for class where the 'Null Pointer Exception' occurred is like:


java.lang.NullPointerException
at org.dhsinfo.message.dao.OracleMemberDAO.findMembers(OracleMemberDAO.java:32)
at org.dhsinfo.message.MemberService.getMembers(MemberService.java:18)
at org.dhsinfo.message.SendMessage.execute(SendMessage.java:29)
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:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
All I can tell you is that DBConnection.getDBConnection() returns null. That suggests to me that your configuration is wrong.

Unfortunately I can't help any further as I know nothing about org.dhsinfo.ConnectionPool.DBConnection or how to configure it. I suggest you read the documentation carefully. Try and get a minimal example working first before launching into it.

Jules
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Null Pointer Exception on stmt = conn.prepareStatement( query);