apache roller4.0.1 with tomcat 5.5.x and mysql5.5.11 installation problem, need help!!!!

[Jane Gu <Ja...@mhnz.co.nz>]

Dear Sir/Madam:

I try to install Apache Roller 4.0.1 on my Win 7 machine.  I am using
tomcat 5.5.X, mysql5.5.11 and JDK1.5.  

I have copied mysql-jdbc driver to $tomcat_home/common/lib and
roller-custom.properties in $tomcat_home/common/classes

Database is up running.

But i get the following exception on roller.log

Please help!!!!

 

INFO  2011-04-12 12:02:52,430 DatabaseProvider:successMessage - SUCCESS:
Got parameters. Using configuration type JNDI_NAME

INFO  2011-04-12 12:02:52,431 DatabaseProvider:successMessage - -- Using
JNDI datasource name: java:comp/env/jdbc/rollerdb

INFO  2011-04-12 12:02:52,432 DatabaseProvider:successMessage - SUCCESS:
located JNDI DataSource [java:comp/env/jdbc/rollerdb]

ERROR 2011-04-12 12:02:52,497 DatabaseProvider:errorMessage - ERROR:
unable to obtain database connection. Likely problem: bad connection
parameters or database unavailable.

FATAL 2011-04-12 12:02:52,499 RollerContext:contextInitialized - Roller
Weblogger startup failed during app preparation

org.apache.roller.weblogger.business.startup.StartupException: ERROR:
unable to obtain database connection. Likely problem: bad connection
parameters or database unavailable.

               at
org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabasePro
vider.java:148)

               at
org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(We
bloggerStartup.java:171)

               at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(Rol
lerContext.java:138)

               at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j
ava:3692)

               at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4127
)

               at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja
va:759)

               at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)

               at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

               at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9
10)

               at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java
:873)

               at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)

               at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)

               at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31
0)

               at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
pport.java:119)

               at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)

               at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)

               at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)

               at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)

               at
org.apache.catalina.core.StandardService.start(StandardService.java:450)

               at
org.apache.catalina.core.StandardServer.start(StandardServer.java:680)

               at
org.apache.catalina.startup.Catalina.start(Catalina.java:536)

               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)

               at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)

               at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

               at java.lang.reflect.Method.invoke(Method.java:592)

               at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)

               at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

--- ROOT CAUSE ---

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'

               at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo
urce.java:780)

               at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
e.java:540)

               at
org.apache.roller.weblogger.business.DatabaseProvider.getConnection(Data
baseProvider.java:179)

               at
org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabasePro
vider.java:141)

               at
org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(We
bloggerStartup.java:171)

               at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(Rol
lerContext.java:138)

               at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j
ava:3692)

               at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4127
)

               at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja
va:759)

               at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)

               at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

               at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9
10)

               at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java
:873)

               at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)

               at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)

               at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31
0)

               at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
pport.java:119)

               at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)

               at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)

               at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)

               at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)

               at
org.apache.catalina.core.StandardService.start(StandardService.java:450)

               at
org.apache.catalina.core.StandardServer.start(StandardServer.java:680)

               at
org.apache.catalina.startup.Catalina.start(Catalina.java:536)

               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)

               at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)

               at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

               at java.lang.reflect.Method.invoke(Method.java:592)

               at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)

               at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Caused by: java.sql.SQLException: No suitable driver

               at
java.sql.DriverManager.getDriver(DriverManager.java:243)

               at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo
urce.java:773)

               ... 29 more