Server denies access to resource (mysql JDBC)

[Adam Denenberg]

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]