Pete Freitag Pete Freitag

Using UUID's for CFTOKEN and Database client storage


Just a heads up if your using UUID's for CFTOKEN values with database client storage when upgrading to CFMX, be sure to change the size of the cfid field in the CDATA and CGLOBAL tables. The cfid field stores both the cfid and cftoken value as follows cfid:cftoken. The cfid is usually around 7 characters, and the cftoken when using a UUID is a 35 character UUID plus a 17 character prefix. Just to be safe I changed the size to 64 characters, and changed it to a varchar type.

Below is the error message generated:

Operation failed on the data source named "yourdatasource". 

Reason of failure "[Macromedia][SQLServer JDBC Driver][SQLServer]String or 
  binary data would be truncated."
Stack Trace:

        Operation failed on the data source named "datasourcename".
        at coldfusion.runtime.JDBCHelper.Store(Unknown Source)
        at coldfusion.runtime.ClientScopeServiceImpl.PersistClientVariables(Unknown Source)
        at coldfusion.runtime.ClientScope.commitChanges(Unknown Source)
        at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
        at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
        at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
        at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
        at coldfusion.CfmServlet.service(Unknown Source)
        at jrun.servlet.ServletInvoker.invoke(
        at jrun.servlet.JRunInvokerChain.invokeNext(
        at jrun.servlet.JRunRequestDispatcher.invoke(
        at jrun.servlet.ServletEngineService.dispatch(
        at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(
        at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(
        at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(
        at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(

Like this? Follow me ↯

Using UUID's for CFTOKEN and Database client storage was first published on June 17, 2003.

FuseGuard Web App Firewall for ColdFusion

The FuseGuard Web Application Firewall for ColdFusion & CFML is a high performance, customizable engine that blocks various attacks against your ColdFusion applications.