tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Read" <mr...@dircon.co.uk>
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 {
        Class.forName("org.gjt.mm.mysql.Driver").newInstance();
        Connection  c =
DriverManager.getConnection("jdbc:mysql://mymachine.mydomain.com/mySqlDataba
seName?user=myUserName&password=myPassword");
    }

}


Matt.

----- Original Message -----
From: "Howler D. Wolfe" <howler@bigbadwolf.org>
To: <tomcat-user@jakarta.apache.org>
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
>


Mime
View raw message