Inserts and updates causing a java.lang.ClassCastException

[mattquantic]

Hi. After latest update to bring cf up to: 7,0,2,142559
(

http://www.adobe.com/support/coldfusion/downloads_updates.html)

Now when any of my systems, on multiple sites, perform either an update or an insert the following error happens afterwards. (error at the bottom of the past)

The stange thing is that the updates or inserts do complete - but there is a error afterwards. I've tested this on a single page with an insert on it.

On the sites using trys (without transactions) this allows things to work - but this is by no means ideal and still means 1/2 my sites are screwed.

Any ideas?

M@)

----------------------------------------------------------

Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed.


The error occurred in C:\home\*******.com\httpdocs\temp\dsn.cfm: line 14

12 : username="*****"
13 : password="********"
14 : cachedwithin="#CreateTimeSpan(0, 0, 0, 0)#">
15 : INSERT INTO test
16 : (

java.lang.ClassCastException
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:689)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:496)
at cfdsn2ecfm326944604.runPage(C:\home\**********\httpdocs\temp\dsn.cfm:14)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

 

[mattquantic]

I can't believe it. It's the fact that the cachedwithin="#CreateTimeSpan(0, 0, 0, 0)#" should not be there.

I know that it technically shouldn't be there - but it's never been a problem in the past so I never adjusted my module that runs all the queries.

It still works fine with MySQL - but I'll go through and update stuff now...

Thank's so much.

Matt