[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=32591#action_32591 ] 

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

There is actually a bug. After the split of DocumentBuilder into DocumentBuilderIndexedEntity and documentBuilderContainedEntity line 151 should have changed to

safeFromTupleId = TwoWayString2FieldBridgeAdaptor.class.isAssignableFrom( idBridge.getClass() );

> 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