[richfaces-issues] [JBoss JIRA] Updated: (RF-9879) ILLEGAL SYMBOL "-" exception when filtering is used on a datatable component
Timmy Storms (JIRA)
jira-events at lists.jboss.org
Tue Nov 30 10:33:09 EST 2010
[ https://jira.jboss.org/browse/RF-9879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Timmy Storms updated RF-9879:
-----------------------------
Summary: ILLEGAL SYMBOL "-" exception when filtering is used on a datatable component (was: ILLEGAL SYMBOL "-" exception when sorting is used on a datatable component)
Description:
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.
was:
When I use sorting 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.
Steps to Reproduce:
I'm using a column in a datatable as follows:
<rich:column filterEvent="onkeyup" filterBy="#{item.title}" />
was:
I'm using a column in a datatable as follows:
<rich:column sortable="true" sortBy="#{item.title}" filterEvent="onkeyup" filterBy="#{item.title}" />
> 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
>
> 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: http://www.atlassian.com/software/jira
More information about the richfaces-issues
mailing list