Mohini Dhanaskar

Kindly provide me the steps or code for the backup of oracle database.

i want to connect java project with the oracle database.Help me out for the code.

While opening an project, my project is showing in folder form rather then
represented in glode form. and therefore its not opening.


Please help me out.

i again run the same code ,this time it's not displaying any error but
still while running whole project after feeding values and clicking submit button
it is not calling SuccessfulComplaintRegister.jsp and value is not going to the database
ConsumerRegistration table.

i am again sending you the code.


import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * * @author Miss.Mohini */ public class ConsumerRegistrationServlet extends HttpServlet { Connection con; PreparedStatement ps = null; @Override public void init(ServletConfig config) throws ServletException { con = DatabaseConnection.getConnection(); } @Override public void destroy(){ try { ps.close(); DatabaseConnection.close(con); } catch (SQLException e) { } } @Override public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException { try{ doPost(req,res); } catch(IOException e) { } } @Override public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { int con_id=Integer.parseInt(request.getParameter("con_id")); System.out.println("con_id = " + con_id); String fname=request.getParameter("fname"); System.out.println("fname = " + fname); String lname=request.getParameter("lname"); System.out.println("lname = " + lname); String password=request.getParameter("password"); System.out.println("password =" + password); String addr=request.getParameter("addr"); System.out.println("addr"); String area=request.getParameter("area"); System.out.println("area"); int phn_no=Integer.parseInt(request.getParameter("phn_no")); System.out.println("phn_no"); String wardno=request.getParameter("wardno"); System.out.println("wardno"); String zoneno=request.getParameter("zoneno"); System.out.println("zoneno"); int lon_la=Integer.parseInt(request.getParameter("lon_la")); System.out.println("lon_la= " + lon_la); String btnSubmit=request.getParameter("btnSubmit"); System.out.println("btnSubmit= " + btnSubmit); if(btnSubmit.equals("SUBMIT")) { String sql = "Insert into ConsumerRegistration Values(?,?,?,?,?,?,?,?,?,?)"; try { ps = con.prepareStatement(sql); ps.setInt(1, con_id); ps.setString(2,fname); ps.setString(3,lname); ps.setString(4,password); ps.setString(5,addr); ps.setString(6, area); ps.setInt(7,phn_no); ps.setString(8, wardno); ps.setString(9, zoneno); ps.setInt(10, lon_la); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } response.sendRedirect("SuccessfulComplaintRegister.jsp"); } } catch (Exception ex) { System.out.println(ex.getMessage()); } } }

and error is :
May 25, 2012 12:01:02 PM org.apache.catalina.core.ApplicationContext log SEVERE: Servlet ConsumerRegistrationServlet threw unload() exception javax.servlet.ServletException: Servlet.destroy() for servlet ConsumerRegistrationServlet threw exception at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1413) at org.apache.catalina.core.StandardWrapper.stop(StandardWrapper.java:1739) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4601) at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3222) at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:943) at org.apache.catalina.manager.ManagerServlet.doGet(ManagerServlet.java:361) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:199) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:662) Caused by: java.lang.NullPointerException at ConsumerRegistrationServlet.destroy(ConsumerRegistrationServlet.java:34) at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1394) ... 23 more

Tried everything ,still not getting why i am getting Null Pointer Exception.

Now the code showing the following error:

May 25, 2012 11:03:56 AM org.apache.catalina.core.ApplicationContext log SEVERE: Servlet ConsumerRegistrationServlet threw unload() exception javax.servlet.ServletException: Servlet.destroy() for servlet ConsumerRegistrationServlet threw exception at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1413) at org.apache.catalina.core.StandardWrapper.stop(StandardWrapper.java:1739) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4601) at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3222) at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:943) at org.apache.catalina.manager.ManagerServlet.doGet(ManagerServlet.java:361) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:199) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:662) Caused by: java.lang.NullPointerException at ConsumerRegistrationServlet.destroy(ConsumerRegistrationServlet.java:34) at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1394) ... 23 more

Please suggest me.

Sir, this is the code.


import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * * @author Miss.Mohini */ public class ConsumerRegistrationServlet extends HttpServlet { Connection con; PreparedStatement ps = null; public void init(ServletConfig config) throws ServletException { con = DatabaseConnection.getConnection(); } @Override public void destroy() { try { ps.close(); DatabaseConnection.close(con); } catch (SQLException e) { } } @Override public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException { try{ doPost(req,res); } catch(IOException e) { } } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { int con_id=Integer.parseInt(request.getParameter("con_id")); System.out.println("con_id = " + con_id); String fname=request.getParameter("fname"); System.out.println("fname = " + fname); String lname=request.getParameter("lname"); System.out.println("lname = " + lname); String password=request.getParameter("password"); System.out.println("password =" + password); String addr=request.getParameter("addr"); System.out.println("addr"); String area=request.getParameter("area"); System.out.println("area"); int phn_no=Integer.parseInt(request.getParameter("phn_no")); System.out.println("phn_no"); String wardno=request.getParameter("wardno"); System.out.println("wardno"); String zoneno=request.getParameter("zoneno"); System.out.println("zoneno"); int lon_la=Integer.parseInt(request.getParameter("lon_la")); System.out.println("lon_la= " + lon_la); String btnSubmit=request.getParameter("btnSubmit"); System.out.println("btnSubmit= " + btnSubmit); if(btnSubmit.equals("SUBMIT")) { String sql = "Insert into ConsumerRegistration Values(?,?,?,?,?,?,?,?,?,?)"; try { ps = con.prepareStatement(sql); ps.setInt(1, con_id); ps.setString(2,fname); ps.setString(3,lname); ps.setString(4,password); ps.setString(5,addr); ps.setString(6, area); ps.setInt(7,phn_no); ps.setString(8, wardno); ps.setString(9, zoneno); ps.setInt(10, lon_la); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } response.sendRedirect("SuccessfulComplaintRegister.jsp"); } } catch (Exception ex) { System.out.println(ex.getMessage()); } } }

Hello all,

Kindly help me out in this,what should i do ,to resolved this error.

May 24, 2012 4:54:43 PM org.apache.catalina.core.ApplicationContext log SEVERE: Servlet ConsumerRegistrationServlet threw unload() exception javax.servlet.ServletException: Servlet.destroy() for servlet ConsumerRegistrationServlet threw exception at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1413) at org.apache.catalina.core.StandardWrapper.stop(StandardWrapper.java:1739) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4601) at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3222) at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:943) at org.apache.catalina.manager.ManagerServlet.doGet(ManagerServlet.java:361) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:199) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:662) Caused by: java.lang.NullPointerException at ConsumerRegistrationServlet.destroy(ConsumerRegistrationServlet.java:33) at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1394) ... 23 more

Sir, Oracle

yes,Sir

Sir, Should i make any change in the coding also or what?