Pls help for JDBC in Servlet
Pls look into this problem when I run class as application using main method it is updating the record into table
but When I call thru the servlet Post method there is a problem.
line 55 String insStr = "Insert into G_Customer values(?, ?, ?)";
line 56 conn = getOracleConnection();
line 57 pStmnt = conn.prepareStatement(insStr);
twice it produced the error as NoClassFound, but after restarting
only the following error:
java.lang.NullPointerException
at dao.CustomerDao.CustomerInsert(CustomerDao.java:57 )
at servlet.CustomerDataInput.doPost(CustomerDataInput .java:113)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
.
.
.
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
Thanks,
Gokul
__________________
Gokulan E
|