Hello Anurag,
Wednesday, June 20, 2001, 3:05:54 PM, you wrote:
AT> Hi,
AT> I am running Tomcat 3.2 with Apache 1.3 and using MySQL database. I tried
AT> to setup JDBC Realm by following the instructions but to no avail. After
AT> making the necessary changes in server.xml file, when I start Tomcat, I get
AT> the error message "SQLException: server configuration denies access to data
AT> source". If anybody can help me figure out the what's going wrong, that
AT> would be great.
I can suggest to look at mysql database (in MySQL) to grant privelegies for your
host to access databases in mysql. In other words - JDBC driver is not
implicated in mysql priviligies. I've had that problem - because MySQL
is running at Server - and all CGI's that i've run before where executed
at Server also and it was ok - but when we run java at localhost
there were no permissons - and i've had a gread head-ache to
understand that there must be privilegies in MySQL grants.
AT> Another question is that if I want to access my database from the servlets
AT> using JDBC, is it essential to have JDBCRealm set up or it can be done
AT> without it also just by placing the JDBC drivers jar file at the
AT> appropriate place.
I'm sure it is enougph mysql_dirver.jar to be in classpath. You even may
to plase mysql_driver.jar in your-web-app/lib and it will be enougph.
And another nice way is to place mysql_driver.jar to the
%JAVA_HOME%/jre/lib/ext folder - then jvm finds all jars there you
even needn't to add them (jars) to classpath everytime you install new
jars.
But i'd like to say that i'm not sure what is JDBCRealm((((
AT> Thanks in advance,
AT> Anurag
--
Best regards,
Andrew
