Trying to run
delete StoredMessagePendingClient m where m.clientId = :clientid and m.message.messageId = :messageid
this generates the following SQL
Hibernate: delete from MESSAGES_PENDINGCLIENT cross join MESSAGES storedmess1_ where CLIENT_ID=? and ID=?
java.sql.SQLSyntaxErrorException: unexpected token: CROSS
Which is rejected because HSQLDB doesn't support CROSS JOIN in delete.
This is especially annoying since using DERBY will also fail due to invalid SQL (different reason thou, I've already opened a ticket for it)
|