Ja23

September 7, 2020

3319580886

March 29, 2020

www.plantgreenpg.com

March 29, 2020

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

March 29, 2020

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

March 26, 2020

ja.1.9.0.8.2.3y@gmail.com

ja190823

and let me know what was wrong

March 21, 2020

last problem was solved i have used st.closed() method

and 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.jsp

if(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>

<body>

<%

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);

}

%>

<h1>Hello World!</h1>

</body>

</html>

March 14, 2020

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( " THIS IS EXCEPTION"+e+"" );}

%>

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

March 13, 2020

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( " THIS IS EXCEPTION"+e+"" );}

%>

Error/Exception which is occurring after closing phpmyadmin

THIS IS EXCEPTIONjava.lang.NullPointerException

March 12, 2020

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/ja190823_wp678"+"?verifyServerCertificate=false&useSSL=false&autoReconnect=true&useUnicode=true&characterEncoding=utf8","ja190823_X","<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

And my user name is ja190823

March 12, 2020

The user yo52674 doesn't exist.

My user name is ja190823 i have edited that for security reasons

March 12, 2020

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

Sign In

Ja23

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Ja23

[Solved] Account on tommy server

[Inactive] Adding Domain name error

[Inactive] Adding Domain name error

[Solved] Reactivate my Account

[Solved] Reactivate my Account

[Solved] MYSQL JDBC CONNECTION ERROR

[Solved] MYSQL JDBC CONNECTION ERROR

[Solved] MYSQL JDBC CONNECTION ERROR

[Solved] MYSQL JDBC CONNECTION ERROR

[Solved] MYSQL JDBC CONNECTION ERROR

[Solved] MYSQL JDBC CONNECTION ERROR

HelioHost

Donate

Forums

Activity