Tomcat 5.5.7 cannot connect to mysql datasource - what changed?

[Richard Mixon (qwest)]

We have been using Sun Java 1.4.2, Tomcat 5.0.19, MySQL 4.1.7, MySQL
Connector/J 3.0.15 with Hibernate 2.1.7c with no problems. This is on
both Windows XP Pro SP2 (development) and SuSE Linux SLES9 (test and
production).

In order to get failover to work the way we wanted we upgraded to Tomcat
5.5.7 and Sun Java 1.5. The main change in our application was the new
format for data soruces in the application context. No problem on
Windows XP. We've tried to install on one of our Linux servers and are
having no end of grief getting a DB connection to properly happen.

Any help or ideas would be much appreciated. I've included the
application context and the catalina log error messages below.

Thanks in advance - Richard


***-> APPLICATION CONTEXT:
<Context path="/stars" docBase="stars" debug="99" reloadable="true"
    privileged="true" antiResourceLocking="false" antiJARLocking="true"
>
    <Logger className="org.apache.catalina.logger.FileLogger"
        prefix="stars." suffix=".log" timestamp="true"/>
    <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="com.mysql.jdbc.Driver"
       connectionURL="jdbc:mysql://192.168.11.3:3306/ltojsw?autoReconnec
t=true&amp;autoCommit=true"
      connectionName="ltojsw" connectionPassword="586579"
           userTable="PoAssociate" userNameCol="userid"
userCredCol="password"
       userRoleTable="PoUserRole" roleNameCol="roleName" />
    <Resource            name="jdbc/stars"
                         type="javax.sql.DataSource"
                         auth="Container"
                    maxActive="100"
                      maxIdle="10"
                      maxWait="10000"
            defaultAutoCommit="true"
                     userName="ltojsw"
                     password="586579"
              driverClassName="com.mysql.jdbc.Driver"
                          url="jdbc:mysql://192.168.11.3:3306/ltojsw?aut
oReconnect=true&amp;autoCommit=true"
              removeAbandoned="true"
        removeAbandonedTimeout="60"
                  logAbandoned="true"
    />
</Context>


***-> CATALINA ERROR MESSAGES:

<SNIP>
19:37:27,642  INFO [http-8080-Processor25]
DatasourceConnectionProvider:51 - Using datasource:
java:comp/env/jdbc/stars
19:37:27,648  INFO [http-8080-Processor25]
TransactionManagerLookupFactory:33 - No TransactionManagerLookup
configured (in JTA environment, use of process level read-write cache is
not recommended)
AbandonedObjectPool is used
([EMAIL PROTECTED])
   LogAbandoned: true
   RemoveAbandoned: true
   RemoveAbandonedTimeout: 60
19:37:41,696  WARN [http-8080-Processor25] SettingsFactory:107 - Could
not obtain connection metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Server connection failure during transaction.
Due to underlying exception: 'java.sql.SQLException: Access denied for
user ''@'kingfishS11' (using password: YES)'.

** BEGIN NESTED EXCEPTION **

java.sql.SQLException
MESSAGE: Access denied for user ''@'kingfishS11' (using password: YES)

STACKTRACE:

java.sql.SQLException: Access denied for user ''@'kingfishS11' (using
password: YES)
<SNIP>


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