Jump to content

Ja23

Members
 View Profile  See their activity

  • Posts

    11

  • Joined

  • Last visited

Ja23's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Ja23
    3319580886
  2. Ja23
    www.plantgreenpg.com
  3. Ja23
    I m trying to add my domain name to new heliohost account try29 (which was linked with ny old heliohost account ja190823) But it was giving me error domain name exist in database error
  4. Ja23
    Okay but now i have created new account and trying to add my old domain to my new account user name try29 029ccbbaa@gmail.com
  5. Ja23
    ja.1.9.0.8.2.3y@gmail.com ja190823 and let me know what was wrong
  6. Ja23
    last problem was solved i have used st.closed() methodand con.close() method thankyou very much loratadi a.jsp code is returning null value while trying to fetch session values session id of a.jsp and userregact.jsp is different like every time it creates new session in my web.xml i have specified time for session timeout web.xml <session-config> <session-timeout>3</session-timeout> </session-config> userregact.jspif(rs.next()){ request.setAttribute("s",session.getId()); email = rs.getString("email"); session.setAttribute("username",username); session.setAttribute("email",email); response.sendRedirect("a.jsp?p="+session.getId());//response.sendRedirect("userhome.jsp?msg=success"); } a.jsp <html> <head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <p><% try{%>Id OF SESSION <%= session.getId()%> username <%= (String)session.getAttribute("username")%> email <%= (String)session.getAttribute("email")%> sessionold s <%= (String)session.getAttribute("s")%>req p attribute session id <%=(String) request.getAttribute("p")%> password<%=(String) session.getAttribute("password")%><%}catch(Exception e){out.println("my error is e"+e); }%> </p> <h1>Hello World!</h1> </body></html>
  7. Ja23
    Thank You very much krydos sir and loratadi sir THIS IS DBConnection.java package Database; import java.io.PrintWriter; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.Connection; import java.sql.DriverManager; public class DbConnection { public static Connection getconnection()throws Exception { Connection con=null; try { Class.forName("com.mysql.jdbc.Driver");//load the driver //Create the connection //Connection is an interface //Drivermanager is a class and getConnetcion()is a static metod of DriverManager class whose return type is Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ja190823_wp640"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","ja190823_R","<remove>"); // con=DriverManager.getConnection("jdbc:mysql://localhost/ja190823_wp640","ja190823_R","remove "); //type iv url=jdbc:oracle:thin:@//localhost:1521/xe //user name=infinite //password=5151 } catch(Exception e){ System.out.println(e); } return con; //return the connection } public static Connection getconnection(HttpServletResponse res )throws Exception { Connection con=null; try { Class.forName("com.mysql.jdbc.Driver");//load the driver //Create the connection //Connection is an interface //Drivermanager is a class and getConnetcion()is a static metod of DriverManager class whose return type is Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ja190823_wp640"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","ja190823_R","<remove>"); // con=DriverManager.getConnection("jdbc:mysql://localhost/ja190823_wp640","ja190823_R","jay@1234"); //type iv url=jdbc:oracle:thin:@//localhost:1521/xe //user name=infinite //password=5151 } catch(Exception e){ PrintWriter out=res.getWriter(); out.println("INSIDE GET FUNCTION"+e); } return con; //return the connection } } userregact.jsp <%@page import="java.sql.PreparedStatement"%> <%@page import="Database.DbConnection"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="java.util.*,java.text.SimpleDateFormat,java.util.Date,java.io.FileInputStream,java.io.FileOutputStream,java.io.PrintStream"%> <% try{ String username= request.getParameter("username"); String password = request.getParameter("password"); String email= request.getParameter("email"); String mobile = request.getParameter("mobile"); //String brand = request.getParameter("brand"); //String feedback = request.getParameter("feedback"); Connection getconnection = DbConnection.getconnection(response); //String sql=; PreparedStatement st = getconnection.prepareStatement("insert into user values(?,?,?,?)"); st.setString(1,username); st.setString(2,password); st.setString(3,mobile); st.setString(4, email); int i=st.executeUpdate(); if(i>0){ response.sendRedirect("user.jsp?msg=success"); } } catch(Exception e) {out.println( " </br></br></br>THIS IS EXCEPTION"+e+"</br></br></br>" );} %> INSIDE GET FUNCTIONcom.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: User ja190823_R already has more than 'max_user_connections' active connections'. ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.exceptions.MySQLSyntaxErrorException MESSAGE: User ja190823_R already has more than 'max_user_connections' active connections STACKTRACE: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: User ja190823_R already has more than 'max_user_connections' active connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2772) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at Database.DbConnection.getconnection(DbConnection.java:45) at org.apache.jsp.userregact_jsp._jspService(userregact_jsp.java:145) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) ** END NESTED EXCEPTION ** Attempted reconnect 3 times. Giving up. THIS IS EXCEPTIONjava.lang.NullPointerException
  8. Ja23
    Dbconnection.java package Database; import java.sql.Connection; import java.sql.DriverManager; public class DbConnection { public static Connection getconnection()throws Exception { Connection con=null; try { Class.forName("com.mysql.jdbc.Driver");//load the driver //Create the connection //Connection is an interface //Drivermanager is a class and getConnetcion()is a static metod of DriverManager class whose return type is Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ja190823_wp640"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","ja190823_R","password "); // con=DriverManager.getConnection("jdbc:mysql://localhost/ja190823_wp640","ja190823_R","password"); //type iv url=jdbc:oracle:thin:@//localhost:1521/xe //user name=infinite //password=5151 } catch(Exception e){ System.out.println(e); } return con; //return the connection } } userregact.jsp <%@page import="java.sql.PreparedStatement"%> <%@page import="Database.DbConnection"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="java.util.*,java.text.SimpleDateFormat,java.util.Date,java.io.FileInputStream,java.io.FileOutputStream,java.io.PrintStream"%> <% try{ String username= request.getParameter("username"); String password = request.getParameter("password"); String email= request.getParameter("email"); String mobile = request.getParameter("mobile"); //String brand = request.getParameter("brand"); //String feedback = request.getParameter("feedback"); Connection getconnection = DbConnection.getconnection(); //String sql=; PreparedStatement st = getconnection.prepareStatement("insert into user values(?,?,?,?)"); st.setString(1,username); st.setString(2,password); st.setString(3,mobile); st.setString(4, email); int i=st.executeUpdate(); if(i>0){ response.sendRedirect("user.jsp?msg=success"); } } catch(Exception e) {out.println( " </br></br></br>THIS IS EXCEPTION"+e+"</br></br></br>" );} %> Error/Exception which is occurring after closing phpmyadmin THIS IS EXCEPTIONjava.lang.NullPointerException
  9. Ja23
    this is code of dbconnection.java file<br> <br>which is inside my javaee webapplicataion <br> <br>my web application is hosted on heliohost <br> <br> <br>package Database;<br>import java.sql.Connection;<br>import java.sql.DriverManager;<br> <br>public class DbConnection {<br>public static Connection getconnection() {<br>Connection con=null;<br>try {<br>Class.forName("com.mysql.jdbc.Driver");//load the driver<br> <br> <br>//Create the connection<br>//Connection is an interface<br>//Drivermanager is a class and getConnetcion()is a static metod of DriverManager class whose return type is Connection<br> con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ja190823_wp678"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","ja190823_X","<removed>"); <br> <br>}<br>catch(Exception e){<br>System.out.println(e);<br>}<br>return con; //return the connection<br>}<br>}<br> <br>my web application is trying to connect heliohost mysql database <br>but it can only connect and perform queries when my heliohost phpmyadmin page is open <br>after when i close php my admin it gives me error<br> <br><strong>e</strong> Exception Report<br><strong>Message</strong> An exception occurred processing JSP page [/userregact.jsp] at line [17]<br><strong>Description</strong> The server encountered an unexpected condition that prevented it from fulfilling the request.<br><strong>Exception</strong><br>org.apache.jasper.JasperException: An exception occurred processing JSP page [/userregact.jsp] at line [17]<br>14: //String feedback = request.getParameter("feedback");<br>15: Connection getconnection = DbConnection.getconnection();<br>16: //String sql=;<br>17: PreparedStatement st = getconnection.prepareStatement("insert into user values(?,?,?,?)");<br>18:<br>19: st.setString(1,username);<br>20: st.setString(2,password);<br>Stacktrace:<br> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:584)<br> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481)<br> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)<br> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)<br> javax.servlet.http.HttpServlet.service(HttpServlet.java:742)<br> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)<br><strong>Root Cause</strong><br>java.lang.NullPointerException<br> org.apache.jsp.userregact_jsp._jspService(userregact_jsp.java:147)<br> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br> javax.servlet.http.HttpServlet.service(HttpServlet.java:742)<br> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)<br> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)<br> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)<br> javax.servlet.http.HttpServlet.service(HttpServlet.java:742)<br> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)<br><strong>Note</strong> The full stack trace of the root cause is available in the server logs.<br>Apache Tomcat/8.5.24<br> <br>this is code of dbconnection.java file And my user name is ja190823
  10. Ja23
    My user name is ja190823 i have edited that for security reasons
  11. Ja23
    this is code of dbconnection.java file which is inside my javaee webapplicataion my web application is hosted on heliohost package Database; import java.sql.Connection; import java.sql.DriverManager; public class DbConnection { public static Connection getconnection() { Connection con=null; try { Class.forName("com.mysql.jdbc.Driver");//load the driver //Create the connection //Connection is an interface //Drivermanager is a class and getConnetcion()is a static metod of DriverManager class whose return type is Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/yo52674_wp678"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","yo52674_R","<removed>"); } catch(Exception e){ System.out.println(e); } return con; //return the connection } } my web application is trying to connect heliohost mysql database but it can only connect and perform queries when my heliohost phpmyadmin page is open after when i close php my admin it gives me error e Exception Report Message An exception occurred processing JSP page [/userregact.jsp] at line [17] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception org.apache.jasper.JasperException: An exception occurred processing JSP page [/userregact.jsp] at line [17] 14: //String feedback = request.getParameter("feedback"); 15: Connection getconnection = DbConnection.getconnection(); 16: //String sql=; 17: PreparedStatement st = getconnection.prepareStatement("insert into user values(?,?,?,?)"); 18: 19: st.setString(1,username); 20: st.setString(2,password); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:584) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Root Cause java.lang.NullPointerException org.apache.jsp.userregact_jsp._jspService(userregact_jsp.java:147) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Note The full stack trace of the root cause is available in the server logs. Apache Tomcat/8.5.24 this is code of dbconnection.java file
×
×
  • Create New...