I'm working on a template that uses <cfstoredproc> to pass form values from a struct
to a stored procedure in the database. I have debugging enabled in the CF
Administrator. Whenever I call this template by submitting the form, I simply get a
blank page, it displays nothing (which it should), but the debugging information that
does get displayed gives me the following error/exception:
java.lang.NullPointerException - in C:\CFMX\wwwroot\dids\buildPackage.cfm : line 90
Line 90 is nothing more than the line with my </cfstoredproc> on it. So it appears
obvious to me that somewhere within my stored proc call that I have something wrong or
missing or whatever. But I have no idea what to do with that, how can I debug this to
find out what it's looking for that's null? Here's the code that I have for my stored
proc call:
<cftry>
<cfstoredproc
procedure = "consultation_engine.main"
dataSource = #dataSource#
returnCode = "Yes"
debug = "Yes">
<!--- Set procedure parameters with values from the newPkg Struct --->
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" value=#SESSION.username#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.projectUsername#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.projectFolder#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" value=#SESSION.projectFile#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrFName#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrMI#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrLName#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrOrg#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrOffSym#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrPhoneNumber#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.progMgrPhoneExt#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.programTitle#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerFName#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerMI#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerLName#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerOrg#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerOffSym#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerPhoneNumber#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerPhoneExt#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.buyerEmail#>
<cfprocparam type="IN" cfSQLType="CF_SQL_INTEGER"
value=#SESSION.newPkg.months#>
<cfprocparam type="IN" cfSQLType="CF_SQL_INTEGER"
value=#SESSION.newPkg.dollarAmount#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.basicResearch#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.expDev#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.advDev#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.engDev#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.mfgTech#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.costContract#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.universityInvolved#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.sbirPhase2#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.phasedDev#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.formalReviews#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.studyProgram#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.sensitiveData#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.usingCOTS#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.modifyingCOTS#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.acceptingItems#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.testingInvolved#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.potentialHazards#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.drawingsNeeded#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.modifyingAircraft#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.developingHardware#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.developingBasicMaterials#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.developingComputerHardware#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.developingComputerSoftware#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.conceptualDrawings#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.developmentalDrawings#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.productionDrawings#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.commercialDrawings#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.chemicalHazard#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.laserHazard#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.nuclearHazard#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.propellantHazard#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.otherHazard#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.acFlightTesting#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.missileFlightTesting#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.usingAFFuel#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.testingBasicMaterials#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.testingComputerHardware#>
<cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR"
value=#SESSION.newPkg.testingComputerSoftware#>
<!--- End parameters --->
</cfstoredproc>
<cfcatch type="database">
<p class="error_title">Error building package</p>
<cfoutput>
<p>#cfcatch.message#</p>
<p>Caught an exception of type #cfcatch.type#</p>
<p>Error Stack:</p>
<cfloop index=i from=1 to=#arrayLen(cfcatch.tagContext)#>
<cfset sCurrent = #cfcatch.tagContext[i]#>
<br>#i# #sCurrent["ID"]# (#sCurrent["LINE"]#, #sCurrent["COLUMN"]#)
#sCurrent["TEMPLATE"]#
</cfloop>
</cfoutput>
</cfcatch>
</cftry>
Any thoughts or suggestions would be greatly appreciated. Thanks in advance.
::YEX::
<)))><
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Northrop Grumman IT
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| <)))><
*/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
