I get the following error when trying to call a DB2 stored procedure on
OS/390 with the JDBC Type 4 driver supplied with CFMX (RVSPSEC is the stored
procedure):
-----------------------------------
An error has occured while accessing the Application.
Database
Error Executing Database Query.
[Macromedia][DB2 JDBC Driver][DB2]The Specified library "RVSPSEC" could not
be loaded.
-----------------------------------
Does this error mean anything to anyone? I've searched the CFMX references,
the Macromedia site, and I've Googled, but I'm coming up empty . . .
The application runs fine in CF5. I'm trying to migrate from CF5 to CFMX.
The Code Analyzer gave me informational warnings about the dbvarname
parameter in the cfprocparam tag saying that it is ignored (otherwise the
app is 'clean'). However the reference documentation says dbvarname is
'required for named notation', so I have left it there. I have Updater2
installed and I'm running on Win2k Adv Server, IIS5.
Here is the code that calls the stored procedure:
-----------------------------------
<cftransaction>
<cfstoredproc datasource="#datasource#" procedure="RVSPSEC">
<!--- cfprocparam tags - variables passed to security stored
procedure --->
<cfprocparam type="IN"
cfsqltype="CF_SQL_VARCHAR"
value="#pin##applicationType##applicationSource##paddingSpaces#"
dbvarname="@INPTST">
<!--- cfprocparam tags - variables passed from the security stored
procedure --->
<cfprocparam type="OUT"
cfsqltype="CF_SQL_VARCHAR"
variable="code"
dbvarname="@RTRNCD">
<cfprocparam type="OUT"
cfsqltype="CF_SQL_VARCHAR"
variable="message"
dbvarname="@RTRNMSG">
<!--- result set tag --->
<cfprocresult name = RS1>
<cfprocresult name = RS2 resultset="2">
<cfprocresult name = RS3 resultset="3">
</cfstoredproc>
</cftransaction>
-----------------------------------
cftransaction is there because in CF5 the call to the stored procedure would
not work without it. I took it out to see if it stopped the error message
but it didn't.
Thanks!
George
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
