[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-1011) Unable to load entities with composite id using HSQLDB

[Hardy Ferentschik (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-1011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45086#comment-45086 ] 

Hardy Ferentschik commented on HSEARCH-1011:
--------------------------------------------

Thanks

> Unable to load entities with composite id using HSQLDB
> ------------------------------------------------------
>
>                 Key: HSEARCH-1011
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-1011
>             Project: Hibernate Search
>          Issue Type: Bug
>    Affects Versions: 3.1.1.GA
>         Environment: HSQLDB 1.8.0.2
>            Reporter: Baptiste MATHUS
>
> Hi,
> Hibernate Search actually manages to find entries in the lucene index, but then it fails trying to load them.
> In fact, this issue seems to boil down to HSQLDB not supporting a query of this kind "...where (a,b) in (('x','y'))".
> {{Caused by: java.sql.SQLException: Unexpected token: , in statement}}
> This issue doesn't appear with Oracle, which is our production database. But it prevents us from unit/integration testing our code (using Arquillian/hsqldb/dbunit), which is in fact not very cool.
> After that [discussion on the forum|https://forum.hibernate.org/viewtopic.php?f=9&t=1013645&sid=3f56cef8e295dee3c15bf77e1925e269&p=2450858#p2450858], I've taken some time to create a test project (I'll host in a dedicated github repository, actually).
> As explained on the forum, I guess I'm stuck using 3.1.1.GA, since we're using JBoss EAP 5.x.
> Do you think that could be fixed?
> If you give me pointers so that I can see if I can propose a patch, would it even be possible to release a 3.x version of hsearch?
> Thanks for your answers.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira