Jump to content

rohanawaw

Members
 View Profile  See their activity

  • Posts

    36

  • Joined

  • Last visited

 Content Type 

Posts posted by rohanawaw

    [Solved] access denied to database

    in Customer Service

    Posted · Edited by rohanawaw

    now

    javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

    my code

     

    <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
        pageEncoding="ISO-8859-1"%>
        <%@ page import="java.sql.*"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <title>Insert title here</title>
    </head>
    <body>
    <%
    boolean ok=false;
     
     String req_pass=request.getParameter("pass");
     String req_motherboard_id=request.getParameter("mot_id");
     String req_cpu_id=request.getParameter("cpu_id");
     String req_mac_id=request.getParameter("mac_id");
       // String ProductNamez=request.getParameter("ProductName");
       Connection conn=null;
       Statement st=null;
       ResultSet rs=null;
    try
    {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
         conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/rajesha1_password","rajesha1_azhar", "pass");
         st=conn.createStatement();
         rs = st.executeQuery("SELECT * FROM machineid WHERE pass = '"+
      req_pass +"' ");
        while(rs.next()){ 
       
       
       
        if(rs.getString(3).equals(req_mac_id))
        {
       
        }
       
        if(rs.getString(2).equals(req_cpu_id))
        {
       
        }
        if(rs.getString(1).equals(req_motherboard_id))
        {
        ok=true;
       
        }
       
       
        }
        //rs.close();
       // st.close();
      //  conn.close();
       
    }
    catch(Exception e)
    {
    out.println(e.getMessage()) ;
    }
        
             %>
     
     
     
     
     
     
     
     
     
     
    <%
    if(!ok)
    {
     // String ProductNamez=request.getParameter("ProductName");
    try
    {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
       
     
    st=conn.createStatement();
    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/rajesha1_password","rajesha1_azhar", "pass");
        

     

         rs = st.executeQuery("SELECT count(*) FROM machineid WHERE pass = '"+req_pass +"' ");
        
        while(rs.next()){ 
       
        int h= rs.getInt(1);
        if(h<5)
        {
        String sql = "INSERT INTO machineid " +
                        "VALUES ('"+req_motherboard_id+"', '"+req_cpu_id+"', '"+req_mac_id+"','"+req_pass+"')";
          
        int rsu = st.executeUpdate(sql);
          
       
        }
        }
        //PrintWriter output = response.getWriter();
        out.println("yes");
        //String no="no";
        //respose.send("yes");
    }
        catch(Exception e)
        {
        out.println(e.getMessage());
        }
     
        
    }
    else
    {
    String no="no";
    out.println("no");
     
     
     
     
        rs.close();
        st.close();
        conn.close();
       
    }
     
     
     
    out.println("yes");
     
     
    %>
    </body>
    </html>
     
     
    operation not allow after resultset close

    [Solved] access denied to database

    in Customer Service

    Posted

    now

    javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

     

     

     

    i guess the same old problem of not closing the connectio in database

     

     rs.close();
        st.close();
        conn.close();
       

    where to put these lines exactly

    [Solved] access denied to database

    in Customer Service

    Posted · Edited by rohanawaw

    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'rajesha1_azhar'@'localhost' to database 'rajesha1__password'

     
     
    with this code

     

     

     Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/rajesha1__password","rajesha1_azhar", "pass");
     
     
     
    working fine on my machine

    Servlet Deploy

    in News

    Posted · Edited by rohanawaw

    deployment pending taking hour or so today.

     

    if its going to take long , please deploy my war

     

    user rajesha1

    war machine_id

    upload database .sql file and import with jsp

    in Customer Service

    Posted · Edited by rohanawaw

    can i use load inline query

     String sql= "LOAD DATA INFILE"+" 'f:/data4.txt'"
                +"INTO TABLE survey "+
               " FIELDS TERMINATED BY ',' "+
               " ENCLOSED BY '\"'"+
                "LINES TERMINATED BY '\\r\\n'"+
                "IGNORE 1 LINES";
              
     
    statement.execute(sql);

     

    from java with remote .

     

    currently iam doing this it giving me error

    access denied

    Using Mysql With Java And C#

    in Questions

    Posted

    static final String DBDriver  ="com.mysql.jdbc.Driver";
      static final String strConn   ="jdbc:mysql://localhost:3306/rajesha1_onlinebooks";
      static final String DBusername="rajesha1_food";
      static final String DBpassword="**********";
     

    iam connecting in java to mysql is that ok

    [Solved] Upload War File

    in Customer Service

    Posted · Edited by rohanawaw

    is this the correct path iam using ..\home\rajesha1\stories\post.jpg

    so in this way of relative path i can get access to my user directory

     

    is this confirmed (dont bother about slashes,tell me the relative path is correct or not )

    [Solved] Upload War File

    in Customer Service

    Posted · Edited by rohanawaw

    there are lots of places where connection is closed after the query

    only 2 or 3 places are there where connection is not closed

     

    at rajesha1_food connection is closed after the query

     

    there are other error which i need to see before uploading new war file

     

    iam from india, so i have to wait for ur reply for night

     

    i dont know if ur still awake

     

     

    its still giving maxconnection error

    just open the connection today or if u somehow close the connection how can i open it from my cpanel

×
×
  • Create New...