tracker issue : CF-4130252

select a category, or use search below
(searches all categories and all time range)
Title:

DB2 DBVARNAME Issue missing '=>' [SQL0104] Token = was not valid. Valid tokens: ) ,.

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/ThirdParty

Reporter/Name(from Bugbase): Nathanael Waite / Nathanael Waite (Nathanael Waite)

Created: 03/18/2016

Components: Database

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 0

Problem Description:

Fails With Error - [SQL0104] Token = was not valid. Valid tokens: ) ,.

Steps to Reproduce:
 
<cfstoredproc procedure="testProc" datasource="DB2DATAOURCE" >
   <cfprocparam cfsqltype="CF_SQL_CHAR" maxlength="10" dbvarname="VAR1" value="abcdefg" type="in">
    <cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="VAR2" value="12345" type="in">	
     <cfprocresult name="result" resultset="1" >	
</cfstoredproc>


Actual Result:

{call testProc(VAR1= (param 1) , VAR2 = (param 2) )}

Expected Result:

{call testProc(VAR1=> (param 1) , VAR2 => (param 2) )} 

Any Workarounds:

<cfquery name="result" datasource="DB2DATAOURCE">
	{call testProc(VAR1=> (param 1) , VAR2 => (param 2) )} 
</cfquery>

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4130252

External Customer Info:
External Company:  
External Customer Name: Nathanael Waite
External Customer Email:  
External Test Config: My Hardware and Environment details:

Windows Server 2012 IIS

Coldfusion 11 update 7

Attachments:

Comments:

Same stored procedure will work on CF10 not on CF11.
Comment by External U.
3267 | March 18, 2016 12:30:40 PM GMT
It was working on CF10 because CF10 ignores dbvarname attribute in cfstoredproc tag. We added the support for dbvarname in CF11 again and Database driver for DB2 does not support it. So, you have to use below mentioned JVM flag to make it work: -Dcoldfusion.ignoredbvarname=true This JVM flag is valid for ColdFusion 11 only.
Comment by Nimit S.
3268 | June 16, 2016 05:02:14 AM GMT