Just a guess, but try quoteing all the value attributes I.e. <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" value="#SESSION.username#">
-----Original Message----- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 11:35 AM To: CF-Talk Subject: Debugging java errors in CFMX 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
