I am using [b]Hibernate version: 2.1.6[/b] - yeah, I know, it's old, but that's the Corporate world for ya.
I'm trying to evaluate the value of DAYS(date), date = a Date value to DB2 8.1 via Hibernate (in RAD 6), and am getting the following error:
[b]Error: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: );;< > = <> <= !< !> != ^< ^> ^= >= IN NOT
which means:
SQLCODE -104, Error: ILLEGAL SYMBOL "".
[/b]
[b]The generated SQL is: select issue.appl_Id from UI_ISSUE issue where issue.applId in (?, ?, ?) and DAYS(?) - DAYS(issue.appealDueDt)) > 0[/b]
I am trying nativeSQL to get around it, but I shouldn't have to do that.
Thanks
|