[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-248) Incorrect syntax near ', ' with org.hibernate.dialect.SQLServerDialect

[Hardy Ferentschik (JIRA)]

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

Hardy Ferentschik commented on HSEARCH-248:
-------------------------------------------

DocumentBuilderIndexedEntity contains a flag 'safeFromTupleId' which is set when the metadata is created. This flag is the used in MultiClassesQueryLoader to determine how to load objects. So there is definitely some code which should at least take care of the scenario. Need to check if there is a test case.

> Incorrect syntax near ',' with org.hibernate.dialect.SQLServerDialect
> ---------------------------------------------------------------------
>
>                 Key: HSEARCH-248
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-248
>             Project: Hibernate Search
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 3.0.1.GA
>         Environment: Sql Server 2005, hibernate 3.2.6
>            Reporter: Isaac F
>             Fix For: 3.1.0.Beta1
>
>
> I get this exception when I make a createFullTextQuery with an Entity that have composite-id (I use TwoWayStringBridge impl to transform)
> org.hibernate.util.JDBCExceptionReporter[main] - SQL Error: 102, SQLState: S0001
> org.hibernate.util.JDBCExceptionReporter[main] - Incorrect syntax near ','.
> A generated query is this:
> /* criteria query */ select
>         this_.CE_CIF as CE1_0_0_,
>         this_.CE_FORMA_JURIDICA as CE2_0_0_,
>         this_.CE_DISCRIMINANTE as CE3_0_0_,
>         this_.CE_DELEGACION as CE4_0_0_,
>     from
>         CH_TERCEROS this_ 
>     where
>         (
>             (
>                 this_.CE_CIF, this_.CE_FORMA_JURIDICA, this_.CE_DISCRIMINANTE, this_.CE_DELEGACION
>             ) in (
>                 (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 ), (
>                     ?, ?, ?, ?
>                 )
>             )
>         )
> but this syntax is not support by Sql Server 2005
> Thanks

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira