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

[Isaac F (JIRA)]

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


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