Roller 1.2 JDBC problems

[Karen Milburn/Bill Blackmon]

Hi,
I'm trying to install and run Roller 1.2 under Tomcat 5.5 and I can't
get the connection pooling to work 
correctly. The JDBC driver is located in
tomcat\common\lib\mysql-connector-java-3.1.11-bin-g.jar as well as 
the jdk1.5.0_05\jre\lib\ext directory. The driver is also defined in the
system classpath. 
The roller.xml file is located in
tomcat\conf\Catalina\localhost\roller.xml, as recommended 
in the installation instructions for Tomcat 5.5 . 
 
The Hibernate.config for MySQL is defined as follows:
<!-- By default Roller uses a JNDI DataSource and the MySQLDialect -->
        <property name="show_sql">false</property>
        <property
name="connection.datasource">java:comp/env/jdbc/rollerdb</property>
        <property
name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
     
        <property
name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</proper
ty>
        <property name="hibernate.connection.url">
 
jdbc:mysql://localhost/roller?user=roller&amp;password=tiger</property>
        <property name="hibernate.connection.username">roller</property>
        <property name="hibernate.connection.password">tiger</property>
        <property
name="hibernate.dialect">net.sf.hibernate.dialect.MySQLDialect</property
>
 
<<<<<<<<<<<< END OF HIBERNATE.CFG >>>>>>>>>>>>>>>>>>
 
The roller.xml follows:
<!-- 
     Example roller context configuration file for Tomcat 5.5.X and
MySQL 4.1.X
     Place this file at CATALINA_HOME/conf/Catalina/localhost/roller.xml
and replace
     the following values:
            DBNAME - The name of your Roller database (the name you used
with 'create database')
            DBUSERNAME - A MySQL user with full access to that database
            DBPASSWORD - The password for that user
     This file assumes you are deploying Roller to the URI "/roller" and
have put it under
     "roller" in your normal Tomcat appbase (typically "webapps").  If
not, see the
     instructions for setting up Roller to run under a different URI.
-->
<Context path="/roller" docBase="roller" debug="99"
workDir="work/Catalina/localhost/roller">
            
    <Realm className="org.apache.catalina.realm.JDBCRealm"      
      driverName="com.mysql.jdbc.Driver"
      connectionURL=
 
"jdbc:mysql://localhost:3306/roller?autoReconnect=true&amp;useUnicode=tr
ue&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"      
        connectionName="scott"
      connectionPassword="scott"
      userTable="rolleruser" 
      userNameCol="username" 
      userCredCol="passphrase" 
      userRoleTable="userrole" 
      roleNameCol="rolename" debug="99" />
 
    <Resource name="jdbc/rollerdb" auth="Container"
type="javax.sql.DataSource"
      driverClassName="com.mysql.jdbc.Driver"
 
url="jdbc:mysql://localhost:3306/roller?autoReconnect=true&amp;useUnicod
e=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"
      username="scott"
      password="tiger"
      maxActive="20"
      maxIdle="3"
      removeAbandoned="true"
      maxWait="3000" />
 
    <!--
      To enable email notification of comments: uncomment the resouce
below, 
      set your mailhost, and make sure you have mail.jar and
activation.jar 
      in <tomcat>/common/lib.
    -->
    <!--
    <Resource name="mail/Session" auth="Container"
type="javax.mail.Session"
      mail.smtp.host="mailhost.example.com" />
    -->
</Context>
<<<<<<<<<<<<<<<<<<<<<< END OF ROLLER.XML >>>>>>>>>>>>>>>>>>
 
 
 
The error from roller.log follows:
 
 
ERROR 2005-11-15 22:03:35,140 JDBCExceptionReporter:logExceptions -
Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
ERROR 2005-11-15 22:03:35,156 JDBCException:<init> - Cannot open
connection
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver
class 'com.mysql.jdbc.Driver'
            at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo
urce.java:766)
            at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
e.java:554)
            at
net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(D
atasourceConnectionProvider.java:56)
            at
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
            at
net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3302)
            at
net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3282)
            at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java
:65)
            at
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
            at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
            at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:133)
            at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
            at net.sf.hibernate.loader.Loader.list(Loader.java:946)
            at
net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:121)
            at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3609)
            at
net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
            at
org.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperti
es(HibernatePropertiesManagerImpl.java:71)
            at
org.roller.business.PropertiesManagerImpl.init(PropertiesManagerImpl.jav
a:55)
            at
org.roller.business.PropertiesManagerImpl.<init>(PropertiesManagerImpl.j
ava:47)
            at
org.roller.business.hibernate.HibernatePropertiesManagerImpl.<init>(Hibe
rnatePropertiesManagerImpl.java:39)
            at
org.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager(H
ibernateRollerImpl.java:197)
            at
org.roller.presentation.RollerContext.setupRollerProperties(RollerContex
t.java:211)
            at
org.roller.presentation.RollerContext.contextInitialized(RollerContext.j
ava:176)
 
<<<<<<<<<<<< END OF ERROR MSG >>>>>>>>>>>>>>>>>>>>>>>>>>>>
 
 
I've been struggling with this for quite awhile and I'm about to give up
and select a different Blogging tool.
Any help would be GREATLY appreciated.
 
Thanks,
Bill