jsp tomcat http 500 error

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • oll3i
    Contributor
    • Mar 2007
    • 679
    #1

    jsp tomcat http 500 error

    i get http error 500 when trying to connect to mysql database
    i use tomcat 5.5 ,connector mysql-connector-java-5.1.6-bin.jar and i get the following error
    java.sql.SQLExc eption: Access denied for user ''@'localhost' (using password: NO)

    Thank You
    Tags: None
    • JosAH
      Recognized Expert MVP
      • Mar 2007
      • 11453
      #2
      I don't think that "@'localhos t'" is a valid user name; check your connection URL.

      kind regards,

      Jos

        Comment

        • oll3i
          Contributor
          • Mar 2007
          • 679
          #3
          yes i added to DriverManager.g etConnection username and password
          connection = DriverManager.g etConnection(co nnectionURL, "user_baza2004" , "password") ;
          and i get
          SEVERE: Servlet.service () for servlet jsp threw exception
          com.mysql.jdbc. exceptions.jdbc 4.MySQLSyntaxEr rorException: Access denied for user 'user_baza2008' @'%' to database 'baza2008'


          and my dbtest.jsp(just to test the connection to db) file displays



          type Exception report

          message

          description The server encountered an internal error () that prevented it from fulfilling this request.

          exception

          org.apache.jasp er.JasperExcept ion: Exception in JSP: /dbtest.jsp:27

          24: <body>
          25: <%
          26: Class.forName(" com.mysql.jdbc. Driver").newIns tance();
          27: connection = DriverManager.g etConnection(co nnectionURL, "user_baza2004" , "m1ssy0u");
          28: statement = connection.crea teStatement();
          29: rs = statement.execu teQuery("SELECT * FROM candidates");
          30: System.out.prin tln("DB Connected");


          Stacktrace:
          org.apache.jasp er.servlet.JspS ervletWrapper.h andleJspExcepti on(JspServletWr apper.java:451)
          org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 355)
          org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:329)
          org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :265)
          javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)


          root cause

          javax.servlet.S ervletException : Access denied for user 'user_baza2004' @'localhost' (using password: YES)
          org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:841)
          org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:774)
          org.apache.jsp. dbtest_jsp._jsp Service(dbtest_ jsp.java:91)
          org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:98)
          javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)
          org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 331)
          org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:329)
          org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :265)
          javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)


          root cause

          java.sql.SQLExc eption: Access denied for user 'user_baza2004' @'localhost' (using password: YES)
          com.mysql.jdbc. SQLError.create SQLException(SQ LError.java:105 6)
          com.mysql.jdbc. SQLError.create SQLException(SQ LError.java:957 )
          com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:2938)
          com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:855)
          com.mysql.jdbc. MysqlIO.secureA uth411(MysqlIO. java:3337)
          com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1217)
          com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:1930)
          com.mysql.jdbc. Connection.<ini t>(Connection.j ava:716)
          com.mysql.jdbc. JDBC4Connection .<init>(JDBC4Co nnection.java:4 6)
          sun.reflect.Nat iveConstructorA ccessorImpl.new Instance0(Nativ e Method)
          sun.reflect.Nat iveConstructorA ccessorImpl.new Instance(Native ConstructorAcce ssorImpl.java:3 9)
          sun.reflect.Del egatingConstruc torAccessorImpl .newInstance(De legatingConstru ctorAccessorImp l.java:27)
          java.lang.refle ct.Constructor. newInstance(Con structor.java:5 13)
          com.mysql.jdbc. Util.handleNewI nstance(Util.ja va:353)
          com.mysql.jdbc. Connection.getI nstance(Connect ion.java:295)
          com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:266)
          java.sql.Driver Manager.getConn ection(DriverMa nager.java:582)
          java.sql.Driver Manager.getConn ection(DriverMa nager.java:185)
          org.apache.jsp. dbtest_jsp._jsp Service(dbtest_ jsp.java:70)
          org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:98)
          javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)
          org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 331)
          org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:329)
          org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :265)
          javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:803)


          note The full stack trace of the root cause is available in the Apache Tomcat/5.5.26 logs.


          --------------------------------------------------------------------------------


          but when i change user to root it displays nothing
          Thank You

            Comment

            • oll3i
              Contributor
              • Mar 2007
              • 679
              #4
              hm i realized that i didnt grant prvileges to that user and that's why i got access denied
              now what's left is displaying the data from the tables still cannt get it work

              Code:
              <%
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "user_baza2008", "password");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM candidates");
System.out.println("DB Connected");
while (rs.next()) {
System.out.println(rs.getString("name")+"<br>");
}



rs.close();
%>
              displaying doesnt work or maybe even the retrieving
              Thank You

                Comment

                Previous template Next
                Working...