RE: Server denies access to resource (mysql JDBC)

[Kal Govindu]

First of all it looks like you an extra parameter tag in your xml. As
long as the mysql deamon is running on your local machine the hostname
looks correct.


-----Original Message-----
From: Adam Denenberg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 5:26 PM
To: Tomcat Users List
Subject: Server denies access to resource (mysql JDBC)


org.apache.jasper.JasperException: java.sql.SQLException: Server
configuration denies access to data source

 IS the error I am getting for my mysql JDBC Connection.  I dropped the
mysql-connector-java-3.0.6-stable-bin.jar file in common/lib as per
instructions and have the following setup as one of my contexts.

 I can log in fine from the command line to mysql, just not thru JDBC.

 here is my server.xml snippet.. Anyone have similar issues with Mysql ?
I
am wondering if it is a hostname thing.

.......

<Context path="/testDB" docBase="testDB" debug="99" reloadable="true">
 
         <Resource name="jdbc/adamtest" auth="Container"
type="javax.sql.DataSource"/>

          <ResourceParams name="jdbc/adamtest">

           <parameter>
             <name>factory</name>
 
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>

           <parameter>
           <parameter>
            <name>driverClassName</name>
            <value>com.mysql.jdbc.Driver</value>
           </parameter>

           <parameter>
            <name>url</name>
            <value>jdbc:mysql://localhost:3306/testDB</value>
           </parameter>

           <parameter>
            <name>username</name>
            <value>testDB</value>
           </parameter>

           <parameter>
            <name>password</name>
            <value>mypass</value>
           </parameter>

           <parameter>
            <name>maxActive</name>
            <value>50</value>
           </parameter>

           <parameter>
            <name>maxIdle</name>
            <value>10</value>
           </parameter>

           <parameter>
            <name>maxWait</name>
            <value>-1</value>
           </parameter>

         </ResourceParams>

      </Context>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]