On Tue, 01 Feb 2005 12:36:26 -0400, Alisa Thomson <[EMAIL PROTECTED]> wrote: > I am working on migrating our CF5 apps to CFMX and ran into a problem with > one of our stored procedure calls. It is a CFSTOREDPROC that has 3 input > parameters, 1 output parameter and returns a result set. The only error I > get is java.lang.NullPointerException - in : line -1. The exception log > shows no further information. I copied the problem call to a test page, so > that is the only code in the page. To make sure it isn't purely a driver > problem (because we have had MANY of those), I wrote a java app that makes > the same call and that works fine. None of the input parameters are null and > the output parameter is not null. The result set is also not null. For > testing, I have hard-coded everything to make sure. I am using Sybase with > the jConnect 5.5 driver. Any ideas on how to at least get a better message? > > Here is my call: > > <CFSTOREDPROC PROCEDURE="rates..ListCurve_pr" DATASOURCE="fms_DEVEL" > RETURNCODE="yes" debug="yes"> > <CFPROCPARAM TYPE="In" DBVARNAME="@TradeDate" > CFSQLTYPE="CF_SQL_TIMESTAMP" VALUE="09/02/2004 > " NULL="no" > <CFPROCPARAM TYPE="In" DBVARNAME="@SeqNbr" > CFSQLTYPE="CF_SQL_INTEGER" VALUE="1" NULL="no"> > <CFPROCPARAM TYPE="Out" DBVARNAME="@MaxBenchmarkDatetime" > CFSQLTYPE="CF_SQL_TIMESTAMP" VARIABLE="ATTRIBUTES.BenchmarkDatetime"> > <CFPROCPARAM TYPE="In" DBVARNAME="@RawTypesInd" > CFSQLTYPE="CF_SQL_CHAR" VALUE="N" NULL="no"> > <CFPROCRESULT NAME="sqlCurveQuery"> > </CFSTOREDPROC> >
I really don't know how much help I can be other than to tell you that the dbVarName attribute no longer works in CFMX because the JDBC drivers don't support it. So I would make sure that the order of your input params match one-to-one with the order defined in the stored proc. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192610 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54