Issue
ColdFusion 9.0.1 doesn't start and the following error appears in the server.log related to SQL Service initialization failure:
"Error","main","07/20/10","19:48:07",,"Unable to initialize SQL service: java.lang.NoSuchMethodError: coldfusion.sql.Executive.getInstance()Lcoldfusion/sql/Executive;"
When the ColdFusion server starts with this exception, the following message appears in the browser when you try to access the ColdFusion Administrator:
"The DataSource service is not available."
Solution
This exception can occur when the ColdFusion 9 Security Hot Fix 1 has been applied along with the Updater for 9.0.1. You can confirm the version by checking the <cfusion>/lib/updates directory for JAR file named shf9000001.jar.
To fix this issue, rename the shf9000001.jar file (for example, shf9000001.jar.bak) to prevent loading this ColdFusion 9.0.0 specific fix. Or, remove it completely from the <cfusion>/lib/updates directory.
Note: The mentioned Security Hotfix 1 is part of ColdFusion 9.0.1 and is no longer required.
Restart the ColdFusion server and observe the logs to ensure that the startup completes without error.
Additional information
The <cfusion>/lib/updates folder can be found at the following locations by default:
- Server Installation:
<ColdFusionInstall>/lib/updates - Multi Server Installation/JRun:
<JRun4Install>/servers/<servername>/cfusion.ear/cfusion.war/WEB-INF/cfusion/lib/updates - EAR Installation:
cfusion.ear/cfusion.war/WEB-INF/cfusion/lib/updates