]
Ilya Shaikovsky resolved RF-9879.
---------------------------------
Resolution: Incomplete Description
will reopen after requested info provided.
ILLEGAL SYMBOL "-" exception when filtering is used on a
datatable component
----------------------------------------------------------------------------
Key: RF-9879
URL:
https://issues.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.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: