An error occurred while trying to process the Resources page:  --- The error occurred in com/novartis/website/misw/MISW-MedInfo-SQLMap.xml. --- The error occurred while executing query. --- Check the SELECT DISTINCT SUBSTR(UPPER(PN.PRODUCTNAME_TEXT), 1, 1) AS LETTER FROM RESOURCES RES, PRODUCTS PROD, PRODUCT_NAME PN, PRODUCT_CLASS_NAME PCN, RESOURCES_TITLE_NAME RTN WHERE RES.PRODUCT_ID = PN.PRODUCT_ID AND RES.LANGUAGECODE = PN.LANGUAGECODE AND RES.PRODUCT_ID = RTN.PRODUCT_ID AND PROD.PRODUCT_ID = RTN.PRODUCT_ID AND RES.LANGUAGECODE = RTN.LANGUAGECODE AND PN.PRODUCT_CLASS_ID = PCN.PRODUCT_CLASS_ID AND PN.LANGUAGECODE = PCN.LANGUAGECODE AND RTN.RESOURCES_TITLE_ID = RES.RESOURCES_TITLE_ID AND (PROD.DELETED = 0 OR PROD.DELETED IS NULL) AND( RES.LANGUAGECODE = ? AND PN.LANGUAGECODE = ? AND PCN.LANGUAGECODE = ? AND RTN.LANGUAGECODE = ? ) ORDER BY LETTER ASC . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLRecoverableException: Closed Connection