openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Wisneski (JIRA)" <>
Subject [jira] Created: (OPENJPA-23) -418 sqlexception using DB2 and EJB QL with SQRT or MOD
Date Wed, 16 Aug 2006 23:37:13 GMT
-418 sqlexception using DB2 and EJB QL with SQRT or MOD

                 Key: OPENJPA-23
             Project: OpenJPA
          Issue Type: Bug
            Reporter: David Wisneski

generated SQL is missing CAST function to indicate type of ?
 EJB QL :  select e from EmpBean e where mod(e.empid,5)=0 

DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null {prepstmnt 1046232668 
SELECT t0.empid, t0.bonus, t1.deptno, t1.budget,, t0.execLevel, t0.hireDate, t0.hireTime,
t0.home, t0.isManager,, t0.salary, FROM EmpBean t0 LEFT OUTER JOIN DeptBean
t1 ON t0.dept_deptno = t1.deptno
WHERE (MOD(t0.empid, ?) = ?)

db2 sql compiler is not able to resolve type of expression (MOD(t0.empid, ?) = ?.  This expression
should be 
MOD(t0.empid, cast((?) as integer) ) = ?.    or 
MOD(t0.empid, 5) = 0 

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:


View raw message