tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Richards" <ncmu...@pobox.com>
Subject Re: SQL Exception (same error) (fwd)
Date Tue, 08 Aug 2000 13:34:26 GMT
Did you flush the permissions?  "mysqladmin reload"

-Brian
----- Original Message -----
From: <araman@india-today.com>
To: "Tomcat" <tomcat-user@jakarta.apache.org>
Sent: Tuesday, August 08, 2000 6:53 AM
Subject: SQL Exception (same error) (fwd)


> Hi again
> After reading all ur mails i tried to the following
>
> 1. create a fresh user in the mysql database
>
> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON subscriptions.* to
subs@localhost identified by 'some_pass';
>
> 2. create a sample application and test connectivity to the database
>
> import java.sql.*;
>
> public class trial {
> Connection conn;
> Statement stmt;
>
> public static void main(String args[]) {
> trial tr = new trial();
> String DBURL="jdbc:mysql:localhost///subscriptions";
> try{
> Class.forName("org.gjt.mm.mysql.Driver");
> tr.conn=DriverManager.getConnection(DBURL,"subs","some_pass");
> tr.stmt=tr.conn.createStatement();
> System.out.println("In connect");
> System.out.println(tr.stmt);
> } catch(Exception ex){
> System.out.println(ex.toString());
> }
> }
> }
>
> 3. On compiling and excuting I still manage to get the following error
>
> java.sql.SQLException: Server configuration denies access to data source
>
> Why is this coming.. I have gone over the privileges table many times and
everything seems to be fine..  I am also able to connect to the database
using the mysql client and the same login and passwd..
>
> This thing is totally driving me up the wall if ay one of u could tell me
why it is happening so..
>
> Thanx for ur time
> Anand Raman
>
>
>
>
>
>


Mime
View raw message