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

 

 

 

 

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy