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

[Arturo Frappé (JIRA)]

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

Arturo Frappé commented on HSEARCH-248:
---------------------------------------

I found this bug again in 3.1.0.GA, then I tested with 3.1.0.Beta1 and again.

Please giveme a hint where to debug, and what to do.

Thanks

> 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