Thoughts, ideas, tips, musings, and pontifications (not necessarily in that order) by Ben Forta ...
NOTE: This is my personal blog, and the opinions and statements voiced here are my own.
July 13, 2010
Posted At : 12:00 PM
Related Categories:
ColdFusion :
Title says it all. ColdFusion 9.0.1 has been released.
|
That's not worth mentioning at all????????
java.sql.SQLException: macromedia.jdbc.sqlserver.SQLServerLicense cannot be cast to macromedia.jdbc.sqlserverbase.BaseLicense
The root cause was that: java.sql.SQLException: macromedia.jdbc.sqlserver.SQLServerLicense cannot be cast to macromedia.jdbc.sqlserverbase.BaseLicense
http://www.adobe.com/support/coldfusion/downloads....
Thanks in advance :)
java.sql.SQLException: macromedia.jdbc.sqlserver.SQLServerLicense cannot be cast to macromedia.jdbc.sqlserverbase.BaseLicense
The root cause was that: java.sql.SQLException: macromedia.jdbc.sqlserver.SQLServerLicense cannot be cast to macromedia.jdbc.sqlserverbase.BaseLicense
It seems that there is an issue with the new database drivers in ColdFusion 9.0.1 and SeeFusion. The CF team is looking into and hopefully we can figure out what's going on.
In the meantime, you can easily revert back to the previous JDBC drivers by copying the backup version of macromedia_drivers.jar from /WEB-INF/cfusion/updater_backup like so:
1. Stop ColdFusion
2. Rename macromedia_drivers.jar found in the /WEB-INF/cfusion/lib directory to macromedia_drivers.bak
3. Copy macromedia_drivers.jar from the /WEB-INF/cfusion/updater_backup/lib directory to the /WEB-INF/cfusion/lib directory
4. Restart ColdFusion
http://www.coldfusionjedi.com/index.cfm/2010/7/15/...
very cool :D
We followed the procedures to revert to the older Database drivers and we are still getting the same Datasource service is not available error. Is there anything else we could try to fix the issue? If not how can we uninstall the 9.0.1 update?
The JDBC revert didn't work for me either, and I'm also not using SeeFusion on the machine with the failed upgrade.
The server that died is a win2008 VPS on Hosting.com which was upgraded from 8 to 9, and now 9.01.
My dev server was fine though, win7 going from 9 to 9.01
Copying the jar file did not help.
We downgraded to ColdFusion 9.0 and it works.
We did not use SeeFusion, but we use FusionReactor.
Is there a solution any working solution or will adobe fix this?
--- Ben
But about the recommendations above to copy the jar file from the updater_backup directory to the WEB-INF\cfusion\lib, I found that in my case, both the files were the same (did a compare).
But they were both different from that in the [cf]\lib directory. That one is mentioned by no one above, but it's long been the location where that jar had lived. So I decided to "comment out" the one in [cf]\wwwroot\WEB-INF\lib by renaming it to macromedia_drivers.jar.bak. (That required that CF be stopped to do the renaming.) I then restarted CF, and the DSN that was failing now worked (including both those that are and are not wrapped with FusionReactor/SeeFusion).
I don't know if this would be a recommended solution for others, but in case anyone hits what I did, if it may help, I wanted to share it.