Well, when I first saw your reply, I was sure that would be the fix, but evidently that's not the problem. I added quotes around all of my parameters that I pass, and am still getting the same java null pointer error. Any other thoughts? Is there any way to debug this kind of thing in order to find out what's raising the error? (No, I don't have DWMX, nor can I get it, sorry)
::YEX:: <)))>< -----Original Message----- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:26 PM To: CF-Talk Subject: RE: Debugging java errors in CFMX 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 Get the mailserver that powers this list at http://www.coolfusion.com
