I get this error and not sure where to go to troubleshoot, since the query runs fine in Oracle (I ran the query as the same user as the
jsp page)
The rest of the application runs fine.
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, count(*) as num_errors, et.fld_nm, et.mtrcs_errs_linkg_id
from stage3i.err_tbl et
where et.mtrcs_errs_linkg_id = 4413
group by et.srce_sys_cd, trunc(et.load_dt), et.mtrcs_errs_linkg_id, et.fld_nm, et.err_cd, et.err_sqlcode order by 4 ];
nested exception is java.sql.SQLException: Invalid column name
I got some questions answered yesterday on setting up the server pieces, here's all the code:
Code below is
- jsp
- Controller
- DAO Impl
- DAO
- Primary Class