tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Read" <>
Subject Re: Problems with a simple JSP and mySQL connect
Date Thu, 19 Jul 2001 01:48:31 GMT
You'll need to show the code you use to establish the connection, in the
meantime here's an example of some lines of code I use to establish a
connection that works, hopefully this will help...

import java.sql.*;

public class MyClass {

    public MyClass() throws SQLException {
        Connection  c =



----- Original Message -----
From: "Howler D. Wolfe" <>
To: <>
Sent: 18 July 2001 14:19
Subject: Problems with a simple JSP and mySQL connect

> >
> Hello Everyone,
> I apologize if this has been answered in a previous post. I've been
digging through old posts and
> and searching on the net for an answer to this problem.
> I am runnin Tomcat 3.2.2 and Apache 1.3.19 and MySQL (I think the latest
version).  I am able to
> run the examples without a hitch. I am new to Java, JSP and MySQL, I have
created a database with
> two tables, when I try to use the MySQL driver to connect to the database
I get the following error.
> I think I get this error because I don't have a user other than root setup
on MySQL. In my searching
> for an answer, I read about using the URL of the MySQL db as part of
getConnection().  I tried this
> and it failed due to the MySQL port not being open on my firewall. After I
opened the appropriate
> port, I got the same error.
> What have I failed to do when setting up MySQL? I've installed it, ran the
grants, I think I've done
> what was supposed to be done.
> I've used the user id of "root" with the password I set for it.
> Partial Error Text follows:
> *
> java.sql.SQLException: Server configuration denies access to data source*
> Thanks in advance
> John Brosan

View raw message