Can't connect to MySQL using JSTL tag

maester18 · January 31st, 2004, 02:02 PM

I am trying to display data using JSTL SQL tags as instructed on page 91 (Beginning JSP 2.0), and I got the following error message :

Code:

javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Invalid authorization specification,  message from server: "Access denied for user: '[email protected]' (Using password: YES)""
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
    org.apache.jsp.pizza.bookDB_jsp._jspService(bookDB_jsp.java:91)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Below is my source code :

Code:

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql_rt" %>

<sql:setDataSource var="datasource"
                driver="com.mysql.jdbc.Driver"
                   url="jdbc:mysql://localhost/ebusiness"
                  user="gabriel" password="xxx" />

<sql:query var="books" dataSource="${datasource}">
    SELECT id, title, price FROM book
</sql:query>

<html>
    <head>
        <title>A First JSP Database</title>
    </head>
    <body>
        <table border="1">
            <tr>
                <td>id</td><td>title</td><td>price</td>
            </tr>
            <c:forEach items="${book.rows}" var="row">
            <tr>
                <td><c:out value="${row.id}" /></td>
                <td><c:out value="${row.title}" /></td>
                <td><c:out value="${row.price}" /></td>
            </tr>
            </c:forEach>
        </table>
    </body>
</html>

I have granted all privilege to "gabriel" user in mysql by:

Code:

mysql> use ebusiness
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> grant all privileges on ebusiness to [email protected]ldomain identified by 'xxx';
Query OK, 0 rows affected (0.11 sec)

Please help....

Martyn · January 31st, 2004, 03:04 PM

Try using the IP address instead of the host name. e.g. 127.0.0.1 instead of localhost.

Cheers

Martyn

maester18 · January 31st, 2004, 04:01 PM

I changed the hostname with the IP address but still having the same error message.

maester18 · January 31st, 2004, 05:04 PM

I finally got it to work. :-)

In my /etc/hosts file, I have this configuration :

Code:

127.0.0.1    localhost.localdomain    localhost

Although in the JSTL tag, I put :

Code:

url="jdbc:mysql://localhost/ebusines

Somehow, the JSTL tried to connect to user [email protected]ldomain that does not exist in mysql.
So I created a new user [email protected]ldomain, and everything works just fine... :-)

Thanks for your help, Martyn...
and