Greetings all
I am having problems with a db2 stored procedure and I am guessing the
problem is on the cf server side though I am not sure.
The first time the stored procedure is run, it brings back the right result
set. After the procedure is run the first time though, it takes the first
results from the first time it was run, and them combines it with the next
newest set of returned data. It continues to do this for each time that
the procedure is ran. If I allow the cfserver to sit a couple of minutes,
and then rerun my app, I get the following error message:
ODBC Error Code = 40003 ()
[IBM][CLI Driver][DB2] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected: "11.143.234.532".
Communication function detecting the error: "recv". Protocol specific error
code(s): "*", "*", "0". SQLSTATE=08001
The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (211:1) to (211:52).
After getting this message, then running the procedure again, it brings back
the correct records the first time, then it goes back to adding the results
of each subsequent running to it.
What it seems to me is that it is caching the results somewhere and then
adding to this cache. The stored procedure, is a Cobol program that is
indexed by db2. The Cobol program creates a temporary table that the
results are stored in, before passing them back to coldfusion. The person
working on the db2 side of things has tested the procedure by using a batch
file to return the results and is unable to duplicate the errors I am
getting which leads me to believe that it is a caching problem on the
server, but if so, don't know what to do about it? any advice and words of
wisdom would be greatly appreciated.
Thanx
Bill
<cfstoredproc datasource="dbd1" procedure="procedure-name">
<!--- result set tag --->
<cfprocresult name="proc_output">
<!--- cfprocparam tags --->
<cfprocparam type="IN"
cfsqltype="CF_SQL_VARCHAR"
value="#input1##input2##input3#"
dbvarname="@INPUTCODE">
<cfprocparam type="OUT"
cfsqltype="CF_SQL_VARCHAR"
VARIABLE="code"
DBVARNAME="@RETURNCODE1">
<cfprocparam type="OUT"
cfsqltype="CF_SQL_VARCHAR"
VARIABLE="message"
DBVARNAME="@RETURNCODE2">
</cfstoredproc>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
