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