Rundeck1.4.3 war with tomcat 7 and mysql 5.5

[Sridhar Srigiriraju]

Hi all,

I am following the document provided at
http://kb.dtosolutions.com/wiki/Setup_redundant_rundeck_servers#Setup_Rundeck.2FTomcat_Instances.

I am using the stack listed in the subject. I checked that I have the following property
#note, make sure this is set to "true" if you are using Oracle or Mysql
rundeck.v14.rdbsupport=true

and the mysql jdbc connector jar in webapps/rundeck/WEB-INF/lib

pwd
/usr/local/tomcat7/webapps/rundeck/WEB-INF/lib

ls -lrt mysql*
 May 15 19:21 mysql-connector-java-5.1.17-bin.jar

I am encountering the following error . What could possibly be wrong with my configuration?
Let me know if you need more information

2012-05-24 22:41:13,219 [pool-2-thread-1] ERROR context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.hsqldb.jdbcDriver' for connect URL 'jdbc:mysql://nwk1-hawk-mac07.apple.com:3306/rundeckdb'
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.springframework.beans.factory.Bean

[Greg Schueler]

Hi Sridhar,

this message: "Cannot create JDBC driver of class
'org.hsqldb.jdbcDriver' for connect URL 'jdbc:mysql://..." seems to
show that it's trying to use hsqldb driver for the mysql connect url.

maybe you can try to set the driver classname explicitly:

dataSource.driverClassName = "com.mysql.jdbc.Driver"

See this document:
http://grails.org/doc/1.3.7/guide/3.%20Configuration.html#3.3%20The%20DataSource

[Greg Schueler]

I'm sorry, the syntax I pasted is wrong for a .properties file. It would be:

dataSource.driverClassName=com.mysql.jdbc.Driver

(no quote marks)