Hi all,
My model has multiple PK (3), I'm using the Play Framework with Hibernate, and the table mapped by my Model is stored in a Sybase db.
I made a Junit where the save()/find()/delete() works very well. But the count() method don't, it throws a SqlGrammarException. By setting jpa.debugSQL=true I trapped the sql request generated by Hibernate and it's incorrect :
Code:
select count((systempara0_.interface, systempara0_.name, systempara0_.origine)) as col_0_0_ from system_parameters systempara0_
Sybase doesn't allow commas in the count statement, if I drop them and set only one column in the statement, the request runs well. I configured the dialect to SybaseASE15Dialect.
Am I wrong somewhere ?
Thanks in advance