Advertisement
Guest User

Untitled

a guest
Feb 9th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.94 KB | None | 0 0
  1. Fev 09, 2016 1:28:02 PM org.apache.catalina.core.StandardWrapperValve invoke
  2. GRAVE: Servlet.service() for servlet [jsp] in context with path [/TesteTemplateImport] threw exception [java.lang.NullPointerException] with root cause
  3. java.lang.NullPointerException
  4. at org.apache.jsp.main_jsp._jspService(main_jsp.java:190)
  5. at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
  6. at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  7. at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
  8. at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
  9. at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
  10. at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  11. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
  12. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  13. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  14. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  15. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  16. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  17. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  18. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  19. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
  20. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  21. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
  22. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  23. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
  24. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
  25. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
  26. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1526)
  27. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1482)
  28. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  29. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  30. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  31. at java.lang.Thread.run(Thread.java:745)
  32.  
  33. package teste;
  34. import java.sql.Connection;
  35. import java.sql.DriverManager;
  36. import java.sql.SQLException;
  37.  
  38. public class Conexao {
  39.  
  40. static final String JDBC_DRIVER = "org.firebirdsql.jdbc.FBDriver";
  41. static final String DB_URL = "jdbc:firebirdsql:192.168.1.225/3050:D:/Dados/Suporte/Sisplan/Base/Belfast.GDB?sql_dialect=3";
  42.  
  43. static final String USER = "SYSDBA";
  44. static final String PASS = "masterkey";
  45.  
  46. public static Connection getConexao() throws SQLException {
  47.  
  48. try {
  49. Class.forName(JDBC_DRIVER);
  50. } catch (ClassNotFoundException e) {
  51. e.printStackTrace();
  52. }
  53.  
  54. return DriverManager.getConnection(DB_URL, USER, PASS);
  55.  
  56. }
  57.  
  58.  
  59. }
  60.  
  61. <%@ page import="teste.Conexao" %>
  62. <%@ page import="teste.UsuarioDao" %>
  63. <%@ page import="teste.Usuario" %>
  64.  
  65. <%
  66.  
  67. Conexao.getConexao();
  68.  
  69. UsuarioDao udao = new UsuarioDao();
  70.  
  71. UsuarioDao.conectar();
  72.  
  73. Usuario usuario = (Usuario) udao.buscar(request.getParameter("passaword"));
  74.  
  75. %>
  76.  
  77. public Usuario buscar(String rg) {
  78. conectar();
  79.  
  80. String sql = "SELECT nome FROM ENTIDADE_001 WHERE CODCLI = " + rg;
  81.  
  82. try {
  83. ResultSet rs = st.executeQuery(sql);
  84.  
  85. while (rs.next()) {
  86. String rG = rs.getString("rg");
  87. String nome = rs.getString("nome");
  88.  
  89. pessoa = new Usuario(rG, nome);
  90. }
  91.  
  92. } catch (SQLException e) {
  93. // TODO Auto-generated catch block
  94. e.printStackTrace();
  95. } finally {
  96. desconectar();
  97. }
  98.  
  99. return pessoa;
  100. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement