Hi all,

I've got trouble with the following request:

from ResultAnnotation ra where
ra.group.job.name='XPLE-B34' and ra.severity='FAILURE'
and not (ra.target, ra.detailTarget) in (select rb.target, rb.detailTarget from ResultAnnotation rb where rb.group.job.name='XPLE-B33' and rb.severity='FAILURE')


and I get this exception:

org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert (SQLStateConverter.java:67)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:2223)
...
Caused by: java.sql.SQLSyntaxErrorException : Syntax error: Encountered "," at line 1, column 595.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.handleException (Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
....
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException : Syntax error: Encountered "," at line 1, column 595.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA (Unknown Source)
...

What am I doing wrong ?

It seems the problem comes  from the use of tuple
Does Derby support row value constructor syntax (tuple syntax)?
If not, how can I rewrite my query to bypass this limitation?

thanks

Mathieu