Re: Debugging java errors in CFMX
On Monday, Oct 7, 2002, at 11:34 US/Pacific, Yexley Robert D Contr Det 1 AFRL/WSI wrote: 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? I would add cfdump var=#session.newPkg# above this code, just to double-check that all the values you are expecting to pass in are actually defined correctly. The top of the Java stack trace might also be helpful - in exception.log you should see a (long) stack trace after the exception. That will help identify what ColdFusion was actually trying to do when it hit the null pointer. 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
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
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
RE: Debugging java errors in CFMX
DOH!! I'll try that. Thanks much. ::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
RE: Debugging java errors in CFMX
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