[richfaces-issues] [JBoss JIRA] Reopened: (RF-9879) ILLEGAL SYMBOL "-" exception when filtering is used on a datatable component

ILLEGAL SYMBOL "-" exception when filtering is used on a datatable component ---------------------------------------------------------------------------- Key: RF-9879 URL: https://jira.jboss.org/browse/RF-9879 Project: RichFaces Issue Type: Bug Security Level: Public(Everyone can see) Components: component-tables Affects Versions: 3.3.3.Final Environment: DB2 8 Tomcat 6 Spring 2.5.6 Hibernate 3.3.2.GA Reporter: Timmy Storms Assignee: Nick Belaevski When I use filtering on a datatable, I'm getting the following exception when the page is rendered:" com.ibm.db2.jcc.b.SqlException: ILLEGAL SYMBOL "-". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <IDENTIFIER>". It appears that this is caused by the -1 in the following sql statement: select a.b from mytable order by upper(column) asc fetch first -1 rows only We use DB2 as database. org.hibernate.dialect.DB2390Dialect is the hibernate dialect we use. I've tried the other DB2 ones to. I'm wondering if this issue is related to hibernate/db2 or that it originates from the datatable component.