There are several problems with DB2 400 (release 4):
(BIGINT is not a datatype in release 4 (but it is in release 5). It is not
a big problem)
The real problem are:
* DB2 400 doesn't support nested joins (looking at your log I think that
you use release 5 and that this error isn't throwed)
For instance: testcases try to execute
SELECT DISTINCT
A1.ROLENAME, A2.TITLE, A0.FIRSTNAME
FROM
PERSON A0
INNER JOIN
(
PERSON_PROJECT A1
INNER JOIN
PROJECT A2
ON
A1.PROJECT_ID=A2.ID
)
ON
A0.ID=A1.PERSON_ID
But for DB2 400 it has to be
SELECT DISTINCT
A1.ROLENAME, A2.TITLE, A0.FIRSTNAME
FROM
PERSON A0
INNER JOIN
PERSON_PROJECT A1
ON
A0.ID=A1.PERSON_ID
INNER JOIN
PROJECT A2
ON
A1.PROJECT_ID=A2.ID
* One can't mix an aggregate function like COUNT in a SELECT without GROUP
BY (I think this is the error you get, try the query in a as400 console
and compare the errors)
For instance: testcases try to execute
SELECT
A0.ID, A0.FIRSTNAME, count(*)
FROM
PERSON A0
WHERE
A0.FIRSTNAME LIKE ?
You can check it modifying the source code (and recompiling) of
StatementsForClassImpl.java, in the prepareStatement method insert the
line:
log.error("*Mete Kural*" + sql);
before the line
throw eSql;
(the string "*Mete Kural*" will help you to find the query in the
tests-broker.txt file)
Anybody knows any solution??????????????????????????????????
