Guest User

Untitled

a guest
Jun 29th, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.54 KB | None | 0 0
  1. HTTP Status 500 – Internal Server Error
  2.  
  3. Type Exception Report
  4.  
  5. Message Error instantiating servlet class [java.Registration]
  6.  
  7. Description The server encountered an unexpected condition that prevented it from fulfilling the request.
  8.  
  9. Exception
  10.  
  11. javax.servlet.ServletException: Error instantiating servlet class [java.Registration]
  12. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
  13. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  14. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
  15. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  16. org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412)
  17. org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  18. org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
  19. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385)
  20. org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  21. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  22. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  23. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  24. java.lang.Thread.run(Thread.java:748)
  25. Root Cause
  26.  
  27. java.lang.SecurityException: Prohibited package name: java
  28. java.lang.ClassLoader.preDefineClass(ClassLoader.java:662)
  29. java.lang.ClassLoader.defineClass(ClassLoader.java:761)
  30. java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
  31. org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2320)
  32. org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:816)
  33. org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1261)
  34. org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1121)
  35. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
  36. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  37. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
  38. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  39. org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412)
  40. org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  41. org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
  42. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385)
  43. org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  44. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  45. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  46. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  47. java.lang.Thread.run(Thread.java:748)
  48. Note The full stack trace of the root cause is available in the server logs.
  49.  
  50. package java;
  51. import java.io.IOException;
  52. import javax.servlet.ServletException;
  53. import javax.servlet.annotation.WebServlet;
  54. import javax.servlet.http.HttpServlet;
  55. import javax.servlet.http.HttpServletRequest;
  56. import javax.servlet.http.HttpServletResponse;
  57. import javax.servlet.http.HttpSession;
  58.  
  59. /**
  60. * Servlet implementation class Registration
  61. */
  62. @WebServlet({ "/registration" })
  63. public class Registration extends HttpServlet {
  64. private static final long serialVersionUID = 1L;
  65.  
  66. /**
  67. * @see HttpServlet#HttpServlet()
  68. */
  69. public Registration() {
  70. super();
  71. // TODO Auto-generated constructor stub
  72. }
  73.  
  74. /**
  75. * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  76. */
  77. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  78. // TODO Auto-generated method stub
  79. DBQuery DB = new DBQuery();
  80. String login = request.getParameter("login");
  81. String password = request.getParameter("password");
  82. String firstname = request.getParameter("firstname");
  83. String lastname = request.getParameter("lastname");
  84.  
  85. HttpSession session=request.getSession();
  86. session.setAttribute("Login", login);
  87. session.setAttribute("FirstName", firstname);
  88. session.setAttribute("LastName", lastname);
  89.  
  90. if(DB.unique(login)){
  91. DB.register(login, password, firstname, lastname);
  92. session.setAttribute("Logged-in", "true");
  93. response.sendRedirect("home.jsp");
  94. } else {
  95. session.setAttribute("ErrorMessage", "Username already in use!");
  96. response.sendRedirect("registration.jsp");
  97. }
  98. }
  99.  
  100. /**
  101. * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  102. */
  103. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  104. // TODO Auto-generated method stub
  105. doGet(request, response);
  106. } }
  107.  
  108. package java;
  109.  
  110. import java.sql.*;
  111.  
  112. public class DBQuery {
  113. private String connectionURL = "jdbc:postgresql://localhost:5432/SitoDB";
  114. private Connection connection = null;
  115. private PreparedStatement statement = null;
  116. private ResultSet rs = null;
  117.  
  118. private String query = "select * from users where login=?";
  119. private String insert = "insert into users(login, firstname, lastname, password) values (?,?,?,?)";
  120.  
  121. public DBQuery() {
  122. // TODO Auto-generated constructor stub
  123. // get a DB connection
  124. try{
  125. Class.forName("com.postgresql.Driver").newInstance();
  126. connection = DriverManager.getConnection(connectionURL, "postgres", "12345");
  127. }
  128. catch(Exception e){
  129. e.printStackTrace();
  130. }
  131. }
  132.  
  133. @Override
  134. protected void finalize() {
  135. try{
  136. connection.close();
  137. }
  138. catch(SQLException e){
  139. e.printStackTrace();
  140. }
  141. }
  142.  
  143. public boolean validate(String login, String password){
  144. boolean result = false;
  145. try{
  146. statement = connection.prepareStatement(query);
  147. statement.setString(1, login);
  148. rs = statement.executeQuery();
  149.  
  150. if (rs.next() && password.equals(rs.getString("password")))
  151. result = true;
  152.  
  153. rs.close();
  154. statement.close();
  155. }
  156. catch(SQLException e){
  157. e.printStackTrace();
  158. }
  159.  
  160. return result;
  161. }
  162.  
  163. public boolean unique(String login){
  164. boolean result = false;
  165. try{
  166. statement = connection.prepareStatement(query);
  167. statement.setString(1, login);
  168. rs = statement.executeQuery();
  169.  
  170. if (rs.next())
  171. result = false;
  172. else
  173. result = true;
  174.  
  175. rs.close();
  176. statement.close();
  177. }
  178. catch(SQLException e){
  179. e.printStackTrace();
  180. }
  181.  
  182. return result;
  183. }
  184.  
  185. public void register(String login, String password, String firstname, String lastname){
  186. // should write data to DB table
  187. try{
  188. statement = connection.prepareStatement(insert);
  189. statement.setString(1, login);
  190. statement.setString(2, firstname);
  191. statement.setString(3, lastname);
  192. statement.setString(4, password);
  193. statement.executeUpdate();
  194.  
  195. statement.close();
  196. }
  197. catch(SQLException e){
  198. e.printStackTrace();
  199. }
  200. }
  201.  
  202. public String getFirstName(String login){
  203. String result="";
  204. try{
  205. statement = connection.prepareStatement(query);
  206. statement.setString(1, login);
  207. rs = statement.executeQuery();
  208.  
  209. if (rs.next())
  210. result = rs.getString("firstname");
  211. else
  212. result = "";
  213.  
  214. rs.close();
  215. statement.close();
  216. }
  217. catch(SQLException e){
  218. e.printStackTrace();
  219. }
  220.  
  221. return result;
  222. }
  223.  
  224. public String getLastName(String login){
  225. String result="";
  226. try{
  227. statement = connection.prepareStatement(query);
  228. statement.setString(1, login);
  229. rs = statement.executeQuery();
  230.  
  231. if (rs.next())
  232. result = rs.getString("lastname");
  233. else
  234. result = "";
  235.  
  236. rs.close();
  237. statement.close();
  238. }
  239. catch(SQLException e){
  240. e.printStackTrace();
  241. }
  242. return result;
  243. }
  244. }
Add Comment
Please, Sign In to add comment