posted 13 years ago
I recently added a screen to a small application, everything worked out fine. The Oracle data looks like this:
# Errors Description
755 MED_COV Dup Found
453 MEM_MEMB_TEFRA Dup Found
6 MEM_MEMB_WHCR Dup Found
So my next screen is to drill down on one of the above rows to display all "755 errors", with some additional detail.
The error I keep getting is "Invalid Column Name", but the two screens are using (virtually) the same sql, etc. Here's the error:
Error 500: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select et.srce_sys_cd, trunc(et.load_dt) as date_loaded, et.fld_nm, et.mtrcs_errs_linkg_id from stage3i.err_tbl et where et.mtrcs_errs_linkg_id = to_number(4413) order by et.fld_nm, et.ent_key_id ]; nested exception is java.sql.SQLException: Invalid column name
I think the spring-servlet file is wrong, that's something I don't quite understand. In the first code snippet, "summary" is my good screen but "detail" gets the error.
I "re-use" some pieces of the code but obviously I'm tripped up somewhere.
I've also provided all the components for the working screen ("summary") and the screen with the error ("detail"). Since I had just wrestled with the first screen (and got it working), I don't think it's my screen, I thing it's the spring-mvc file.
Here's a snippet from my spring-mvc file
Here's the code shared between the two sreens:
Here's the components for the screen that works :
Here are the pieces for the screen that doesn't work