tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject SQL Exception (same error)
Date Tue, 08 Aug 2000 08:52:02 GMT
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";
				System.out.println("In connect");
			} catch(Exception ex){

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

Thanx for ur time
Anand Raman

View raw message