A couple of suggestions.
You should not have to edit the Hibernate configuration from what is
shipped with Roller. Only the roller.xml context file, following the
installation instructions step by step. Both Roller and Hibernate
lookup the datasource name using JNDI.
Make sure you have specifed the MySQL database name, database username,
and password correctly.
You have inconsistent settings of username/password pairs in the two
sections of the context xml (scott/scott v. scott/tiger), and I suspect
these aren't the username and password you actually setup. [Make sure
also that you did set up the database and grants first.]
--a.
Karen Milburn/Bill Blackmon wrote:
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&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&useUnicode=tr
ue&characterEncoding=utf-8&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&useUnicod
e=true&characterEncoding=utf-8&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
