Hi

I am using xwiki which uses hibernate and MYSQL. I have changed is to use postgres and every thing works fine except I get an error. It appears that Hibernate is not generating an SQL correctly missing out a comma in the ORDER BY clause.

I have update xwiki from hibernate 2 to 3 and get the exact same error which would point to an xwiki problem. I have search the xwiki code but cant find anything.

I have spent 2 days trying to trace this and am getting no closer.

Any suggestions ?

Example Error:
Hibernate: select distinct xwikidocum0_.XWD_WEB as col_0_0_, xwikidocum0_.XWD_NAME as col_1_0_ from xwikidoc xwikidocum0_ where (xwikidocum0_.XWD_CONTENT like '%%' ) order by xwikidocum0_.XWD_DATE desc xwikidocum0_.XWD_WEB , xwikidocum0_.XWD_NAME limit ?
23:47:00,049 WARN http80-Processor23 http://xxx/xwiki/bin/view/Main/WebSearch JDBCExceptionReporter:logExceptions:57 - SQL Error: 0, SQLState: 42601
23:47:00,051 ERROR http80-Processor23 http://xxx/xwiki/bin/view/Main/WebSearch JDBCExceptionReporter:logExceptions:58 - ERROR: syntax error at or near "xwikidocum0_"