"function lower(integer) does not exist" error using Hibernate
Issue
INFO [STDOUT] Hibernate:
select
exoshellmo0_.category_id as category1_97_,
exoshellmo0_.category_editor as category2_97_,
exoshellmo0_.category_image as category3_97_,
exoshellmo0_.category_meta_description as category4_97_,
exoshellmo0_.category_meta_keywords as category5_97_,
exoshellmo0_.category_url as category6_97_,
exoshellmo0_.child_category_id as child7_97_,
exoshellmo0_.content_category_name as content8_97_,
exoshellmo0_.edit_lock as edit9_97_,
exoshellmo0_.module_id as module18_97_,
exoshellmo0_.user_roles_id as user19_97_,
exoshellmo0_.expires as expires97_,
exoshellmo0_.inherit_template as inherit11_97_,
exoshellmo0_.ip_address as ip12_97_,
exoshellmo0_.last_update as last13_97_,
exoshellmo0_.page_template as page14_97_,
exoshellmo0_.parent_category_id as parent15_97_,
exoshellmo0_.post as post97_,
exoshellmo0_.visible as visible97_
from
public.exoshell_mod_content_manager_categories exoshellmo0_
where
lower(exoshellmo0_.category_editor) like (lower(?)||'%')
00:35:22,651 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42883
00:35:22,651 ERROR [JDBCExceptionReporter] ERROR: function lower(integer) does not exist
00:35:22,669 ERROR [viewhandler] Error Rendering View[/admin/adminconsole.xhtml]
javax.faces.FacesException: javax.el.ELException: /mods/exoshellcontentmanager/ExoshellModContentManagerCategoriesList.xhtml @28,92 rendered="#{exoshellModContentManagerCategoriesList.resultList.size lt 1}": Error reading 'resultList' on type com.domain.exoshellcms.session.ExoshellModContentManagerCategoriesList_$$_javassist_161
...
Caused by: javax.el.ELException: /mods/exoshellcontentmanager/ExoshellModContentManagerCategoriesList.xhtml @28,92 rendered="#{exoshellModContentManagerCategoriesList.resultList.size lt 1}": Error reading 'resultList' on type com.domain.exoshellcms.session.ExoshellModContentManagerCategoriesList_$$_javassist_161
at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:390)
... 82 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)
... 83 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
... 117 more
Caused by: org.postgresql.util.PSQLException: ERROR: function lower(integer) does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 125 more
Environment
- Hibernate
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
