Guest User

Untitled

a guest
Jul 29th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.45 KB | None | 0 0
  1. Got an exception com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException on GoogleAppEngine
  2. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
  3.  
  4. Here is the full error log that i got
  5.  
  6. [java] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
  7. [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  8. [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  9. [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  10. [java] at java.lang.reflect.Constructor.newInstance(Unknown Source)
  11. [java] at com.google.appengine.tools.development.agent.runtime.Runtime.newInstance_(Runtime.java:116)
  12. [java] at com.google.appengine.tools.development.agent.runtime.Runtime.newInstance(Runtime.java:124)
  13. [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  14. [java] at com.mysql.jdbc.Util.getInstance(Util.java:386)
  15. [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
  16. [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
  17. [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
  18. [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
  19. [java] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2412)
  20. [java] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
  21. [java] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
  22. [java] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
  23. [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  24. [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  25. [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  26. [java] at java.lang.reflect.Constructor.newInstance(Unknown Source)
  27. [java] at com.google.appengine.tools.development.agent.runtime.Runtime.newInstance_(Runtime.java:116)
  28. [java] at com.google.appengine.tools.development.agent.runtime.Runtime.newInstance(Runtime.java:124)
  29. [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  30. [java] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
  31. [java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
  32. [java] at java.sql.DriverManager.getConnection(Unknown Source)
  33. [java] at java.sql.DriverManager.getConnection(Unknown Source)
  34. [java] at com.cac.struts.InsertMethod.<init>(InsertMethod.java:19)
  35. [java] at com.cac.struts.InsertAction.execute(InsertAction.java:23)
  36. [java] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
  37. [java] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
  38. [java] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
  39. [java] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
  40. [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  41. [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  42. [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
  43. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
  44. [java] at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:35)
  45. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  46. [java] at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:60)
  47. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  48. [java] at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
  49. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  50. [java] at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:122)
  51. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  52. [java] at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)
  53. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  54. [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  55. [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  56. [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  57. [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  58. [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
  59. [java] at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:78)
  60. [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  61. [java] at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:363)
  62. [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  63. [java] at org.mortbay.jetty.Server.handle(Server.java:326)
  64. [java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  65. [java] at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923)
  66. [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)
  67. [java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
  68. [java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
  69. [java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
  70. [java] at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
  71. [java] Caused by: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve)
  72. [java] at java.security.AccessControlContext.checkPermission(Unknown Source)
  73. [java] at java.security.AccessController.checkPermission(Unknown Source)
  74. [java] at java.lang.SecurityManager.checkPermission(Unknown Source)
  75. [java] at com.google.appengine.tools.development.DevAppServerFactory$CustomSecurityManager.checkPermission(DevAppServerFactory.java:252)
  76. [java] at java.lang.SecurityManager.checkConnect(Unknown Source)
  77. [java] at java.net.InetAddress.getAllByName0(Unknown Source)
  78. [java] at java.net.InetAddress.getAllByName0(Unknown Source)
  79. [java] at java.net.InetAddress.getAllByName(Unknown Source)
  80. [java] at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:247)
  81. [java] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
  82. [java] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)
  83. [java] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
  84. [java] ... 51 more
  85. [java] java.lang.NullPointerException
  86. [java] at com.cac.struts.InsertMethod.insert(InsertMethod.java:33)
  87. [java] at com.cac.struts.InsertAction.execute(InsertAction.java:24)
  88. [java] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
  89. [java] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
  90. [java] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
  91. [java] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
  92. [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  93. [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  94. [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
  95. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
  96. [java] at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:35)
  97. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  98. [java] at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:60)
  99. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  100. [java] at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
  101. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  102. [java] at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:122)
  103. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  104. [java] at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)
  105. [java] at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  106. [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  107. [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  108. [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  109. [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  110. [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
  111. [java] at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:78)
  112. [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  113. [java] at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:363)
  114. [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  115. [java] at org.mortbay.jetty.Server.handle(Server.java:326)
  116. [java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  117. [java] at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923)
  118. [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)
  119. [java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
  120. [java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
  121. [java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
  122. [java] at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
  123.  
  124. package com.cac.struts;
  125. import java.sql.*;
  126. /**
  127. *
  128. * @author hablu
  129. */
  130. public class InsertMethod {
  131. Connection con=null;
  132. public InsertMethod()
  133. {
  134. try
  135. {
  136. Class.forName("com.mysql.jdbc.Driver");
  137. con=DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
  138. //Class.forName("oracle.jdbc.driver.OracleDriver");
  139. //con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","system");
  140. }
  141. catch(Exception e)
  142. {
  143. e.printStackTrace();
  144. }
  145. }
  146. public boolean insert(int regd)
  147. {
  148. boolean b=false;
  149. try
  150. {
  151. PreparedStatement ps=con.prepareStatement("select * from student where regd=?");
  152. ps.setInt(1,regd);
  153. ResultSet rs=ps.executeQuery();
  154. while(rs.next())
  155. {
  156. b=true;
  157. System.out.println("....."+rs.getString(1));
  158. }
  159. }
  160. catch(Exception e)
  161. {
  162. e.printStackTrace();
  163. }
  164. return b;
  165. }
  166. }
Add Comment
Please, Sign In to add comment