cfstoredproc tag (at least this is what CF debugger points to). The stored
procedure returns three very small answer sets and I get the error on the
third one. If I comment out the third one I get the same error on the second
one, etc. I'm running CFMX 6.1 on Windows 2000 Advanced Server against DB2
7.x on z/OS using IBM JDBC Type4 drivers. If I switch to ODBC_socket drivers
the call to the stored procedure works fine. This process has been
bulletproof on CF 5.0 for almost three years . . .
Here's the error that comes back to the browser:
The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
Here's the corresponding error from the exception.log file in CF Admin
(which, by the way, is not nearly as friendly as the logs in CF 5.0):
"Error","jrpp-10","05/04/04","13:33:18","RZ_LI_Workload"," The specific
sequence of files included or processed is:
E:\Inetpub\wwwroot\emis\mgmnt\rzli\rzli_security.cfm "
java.lang.NullPointerException
at coldfusion.sql.QueryTable.populate(QueryTable.java:260)
at coldfusion.sql.Executive.getRowSets(Executive.java:559)
at coldfusion.sql.Executive.executeCall(Executive.java:814)
at coldfusion.sql.Executive.executeCall(Executive.java:749)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:317)
at
coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192)
at
cfrzli_security2ecfm1061558558.runPage(E:\Inetpub\wwwroot\emis\mgmnt\rzli\rz
li_security.cfm:51)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Here's the CF markup that gets the error (on RS3 toward the bottom):
<cftransaction>
<cfstoredproc datasource="#datasource#" procedure="RVSPSEC"
returnCode="Yes">
<!--- 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>
(I have tried it without dbvarname, which is deprecated, and the result is
the same - they are back in as we try stuff.)
Any ideas what is happening here and how to correct it?
Thanks!
George
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
