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

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 Assignee: Hardy Ferentschik 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