Using UUID's for CFTOKEN and Database client storage

June 17, 2003

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(

5 people found this page useful, what do you think?


Can someone help? I getting a similar error as above but its to do with "Invalid precision value" which I assume is to do with integers. any ideas. Regards r Operation failed on the data source named "clientVarRepository". Reason of failure "[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value " Please try the following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Remote Address Referrer Date/Time 08-Jul-04 02:53 PM

Recent Entries


did you hack my cf?