Description
When using an EyeQL query longer than 4000 characters, the search results page fails to render for users with an Oracle database. The logs show the following error message:
avax.servlet.jsp.JspException: javax.el.ELException: Problems calling function 'cru:getStar' at org.apache.jsp.tag.web.cru.star.star_tag.doTag(star_tag.java:334) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspx_meth_star_star_0(searchresults_jsp.java:1227) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspx_meth_c_if_3(searchresults_jsp.java:1197) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp.access$1200(searchresults_jsp.java:7) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp$searchresults_jspHelper.invoke7(searchresults_jsp.java:1607) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp$searchresults_jspHelper.invoke(searchresults_jsp.java:1674) at org.apache.jsp.tag.web.cru.threePanelPageContent_tag._jspx_meth_c_if_36(threePanelPageContent_tag.java:1920) at org.apache.jsp.tag.web.cru.threePanelPageContent_tag.doTag(threePanelPageContent_tag.java:604) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspx_meth_rend_threePanelPageContent_0(searchresults_jsp.java:625) at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspService(searchresults_jsp.java:193) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) .... Caused by: org.hibernate.QueryTimeoutException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2452) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) at org.hibernate.loader.Loader.list(Loader.java:2187) .... Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) ...