Wow, thanks for all that information relating to DB2/400. I will try to give those
tests a try.
One other problem I have is that I have to journal every file that I need to insert
records into before using it with OJB, even if the file was created via JDBC. Do you
know if there is a way to avoid having to journal the file, or is it absolutely
necessary? Journaling seems to effect the performance badly too.
Thanks,
Mete
---------- Original Message ----------------------------------
From: "Jos� Puente Ferrandis" <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
Date: Wed, 18 Jun 2003 17:43:01 +0200
>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??????????????????????????????????
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
