Product: Confluence
Environment
| Operating System | |
|---|---|
| Affect Version/s | 2.6 |
| JVM | |
| Database | SQL Server |
| Application Server | Tomcat 5.5.x |
Error Message
11-28 09:26:09,977 ERROR [DefaultQuartzScheduler_Worker-4] [org.quartz.core.ErrorLogger] schedulerError Job (DEFAULT.mailPollJob threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for
transaction; nested exception is net.sf.hibernate.exception.GenericJDBCException: Cannot open connection]
at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
..
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
Symptom
Start up fails (as seen in attached logs). I know that Tomcat is running and IIS is still configured, because trying to access the wiki gives the following:
------------------------------------------------------
HTTP Status 404 - /
type Status report
message /
description The requested resource is not available.
Apache Tomcat/5.5.23
Diagnostics/Test
Logs indicate the problem is with connecting to the database. Advised the customer to bounce both Confluence and the Database and see if a connection can be established.
Root Cause
Connection Problem With the Database due to invalid/expired password for the profile used to connect to their SQL Server database.
Solution
Reset password and updated it in the confluence.cfg.xml file. Problem fixed.