org.hibernate.QueryException: Named parameter does not appear in Query: staffs141_ [select distinct cs.CAPPLAN_SET_ID, cs.CAPPLAN_SET_NAME, ce.capplan_edition_id, fs.forecast_site_id,fs.site_name, sg.STAFF_GROUP_ID, sg. STAFF_GROUP_NAME , st.staff_type_id, st.staff_type_name,ce.IS_WORKING_EDITION from CAPPLAN_SETS cs , forecast_sites fs, staff_types st, staff_groups sg, forecast_groups fg, capplan_editions ce, capplans cp, edition_status_master esm where fs.FORECAST_SITE_ID = sg.FORECAST_SITE_ID and sg.staff_type_id = st.staff_type_id and sg.STAFF_GROUP_ID = fg.STAFF_GROUP_ID and fg.CAPPLAN_SET_ID = cs.CAPPLAN_SET_ID and cs.CAPPLAN_SET_ID = cp.CAPPLAN_SET_ID and cp.CAPPLAN_ID = ce.CAPPLAN_ID and cs.IS_ACTIVE ='Y' and ce.IS_WORKING_EDITION = 'Y' and ce.EDITION_STATUS_ID = esm.EDITION_STATUS_ID and esm.EDITION_STATUS_NAME not in ('What-if', 'Contingency','New') AND ce.mapping_effective_date BETWEEN NVL(fs.effective_start_date,ce.mapping_effective_date) AND NVL(fs.effective_end_date,ce.mapping_effective_date) AND ce.mapping_effective_date BETWEEN NVL(sg.effective_start_date,ce.mapping_effective_date) AND NVL(sg.effective_end_date,ce.mapping_effective_date) AND ce.mapping_effective_date BETWEEN NVL(fg.effective_start_date,ce.mapping_effective_date) AND NVL(fg.effective_end_date,ce.mapping_effective_date) AND ce.mapping_effective_date BETWEEN NVL(st.effective_start_date,ce.mapping_effective_date) AND NVL(st.effective_end_date,ce.mapping_effective_date) AND cs.capplan_set_id in ( ? ? ? ? and fg.STAFF_GROUP_ID in ( ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? order by cs.CAPPLAN_SET_NAME,ce.capplan_edition_id desc, fs.site_name, st.staff_type_name ]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Hibernate JIRA by Nauman Bashir, 1 year ago
,ce.IS_WORKING_EDITION from CAPPLAN_SETS cs , forecast_sites fs, staff_types st, staff_groups sg, forecast_groups fg, capplan_editions ce, capplans cp, edition_status_master esm where fs.FORECAST_SITE_ID = sg.FORECAST_SITE_ID and sg.staff_type_id
org.hibernate.QueryException: Named parameter does not appear in Query: staffs141_ [select distinct cs.CAPPLAN_SET_ID, cs.CAPPLAN_SET_NAME, ce.capplan_edition_id, fs.forecast_site_id,fs.site_name, sg.STAFF_GROUP_ID, sg. STAFF_GROUP_NAME , st.staff_type_id, st.staff_type_name,ce.IS_WORKING_EDITION from CAPPLAN_SETS cs , forecast_sites fs, staff_types st, staff_groups sg, forecast_groups fg, capplan_editions ce, capplans cp, edition_status_master esm where fs.FORECAST_SITE_ID = sg.FORECAST_SITE_ID and sg.staff_type_id = st.staff_type_id and sg.STAFF_GROUP_ID = fg.STAFF_GROUP_ID and fg.CAPPLAN_SET_ID = cs.CAPPLAN_SET_ID and cs.CAPPLAN_SET_ID = cp.CAPPLAN_SET_ID and cp.CAPPLAN_ID = ce.CAPPLAN_ID and cs.IS_ACTIVE ='Y' and ce.IS_WORKING_EDITION = 'Y' and ce.EDITION_STATUS_ID = esm.EDITION_STATUS_ID and esm.EDITION_STATUS_NAME not in ('What-if', 'Contingency','New') AND ce.mapping_effective_date BETWEEN NVL(fs.effective_start_date,ce.mapping_effective_date) AND NVL(fs.effective_end_date,ce.mapping_effective_date) AND ce.mapping_effective_date BETWEEN NVL(sg.effective_start_date,ce.mapping_effective_date) AND NVL(sg.effective_end_date,ce.mapping_effective_date) AND ce.mapping_effective_date BETWEEN NVL(fg.effective_start_date,ce.mapping_effective_date) AND NVL(fg.effective_end_date,ce.mapping_effective_date) AND ce.mapping_effective_date BETWEEN NVL(st.effective_start_date,ce.mapping_effective_date) AND NVL(st.effective_end_date,ce.mapping_effective_date) AND cs.capplan_set_id in ( ? ? ? ? and fg.STAFF_GROUP_ID in ( ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? order by cs.CAPPLAN_SET_NAME,ce.capplan_edition_id desc, fs.site_name, st.staff_type_name ]
at org.hibernate.loader.custom.CustomLoader.getNamedParameterLocs(CustomLoader.java:379)
at org.hibernate.loader.Loader.bindNamedParameters(Loader.java:1769)
at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1704)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.