Derby support

[Thomas Dudziak <to...@gmail.com>]

Hi,

I've added support for Derby to the 1.0 (will port to 1.1 next week)
and it would be great if you could test it. Since the Torque version
we're using does not support Derby, I've backported (and simplified)
the database initialization from the 1.1 head to the 1.0 branch.
Basically, running the unit tests is done via

  ant -Duse-ddlutils=true junit

Btw, the default derby profile is specified against the Derby network server.
The tests currently deliver thse results:

    [junit] Running org.apache.ojb.broker.AllTests
    [junit] Tests run: 662, Failures: 4, Errors: 6, Time elapsed: 499,599 sec
    [junit] Test org.apache.ojb.broker.AllTests FAILED
    [junit] Running org.apache.ojb.odmg.AllTests
    [junit] Tests run: 215, Failures: 11, Errors: 0, Time elapsed: 101,506 sec
    [junit] Test org.apache.ojb.odmg.AllTests FAILED
    [junit] Running org.apache.ojb.soda.AllTests
    [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 5,278 sec
    [junit] Running org.apache.ojb.otm.AllTests
    [junit] Tests run: 80, Failures: 0, Errors: 0, Time elapsed: 46,056 sec

In detail, we have:


QueryTest.testDistinctMultiPk, ...:
---

* sql statement was 'SELECT count(distinct PERSON_ID || PROJECT_ID)
FROM PERSON_PROJECT A0 WHERE A0.PROJECT_ID = ?'
* Exception message is [Cannot convert types 'INTEGER' to 'VARCHAR'.]


PersistenceBrokerTest.testMultiKeyCount, ...:
---

* sql statement was 'Select * from NOT_EXIST'
* Exception message is [Table 'NOT_EXIST' does not exist.]


CharacterTest.testJavaCharacterToJdbcCharMapping:
CharacterTest.testJavaCharacterToJdbcVarcharMapping:
---

* sql statement was 'INSERT INTO CHARACTER_TEST
(ID,CHAR_1,VARCHAR_1,CHAR_10,VARCHAR_10) VALUES (?,?,?,?,?) '
* Exception message is [Invalid data conversion: Parameter instance x
is invalid for requested conversion.]


PathTest.testSubQueryExists, ...:
---

* sql statement was 'SELECT DISTINCT A0.ID,A0.A_ATTRIB FROM P_A_TABLE
A0 INNER JOIN P_B_TABLE A1 ON A0.ID=A1.A_ID INNER JOIN P_C_TABLE A2 ON
A1.ID=A2.B_ID INNER JOIN P_D_TABLE A3 ON A2.D_ID=A3.ID WHERE
(A3.D_ATTRIB = ?) AND  NOT EXISTS (SELECT B0.ID,B0.A_ATTRIB FROM
P_A_TABLE B0 INNER JOIN P_B_TABLE B1 ON B0.ID=B1.A_ID INNER JOIN
P_C_TABLE B2 ON B1.ID=B2.B_ID INNER JOIN P_D_TABLE B3 ON B2.D_ID=B3.ID
WHERE A3.D_ATTRIB = ?) '
* Exception message is [Subquery is only allowed to return a single column.]


InheritanceMultipleTableTest.testInheritedReferences:
---

* sql statement was 'SELECT A0.OBJ_ID,A0.NAME FROM
INHERITANCE_CONSORTIUM A0 INNER JOIN INHERITANCE_SHAREHOLDER A1 ON
A0.OBJ_ID=A1.FK_CONSORTIUM INNER JOIN INHERITANCE_MANAGER A2 ON
A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2 INNER JOIN
INHERITANCE_EXECUTIVE A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 INNER JOIN INHERITANCE_EMPLOYEE A4 ON
A3.OBJ_ID=A4.OBJ_ID AND A3.OBJ_ID_2=A4.OBJ_ID_2 WHERE ((A0.NAME = ?)
AND A1.SHARE_ = ?) AND A4.NAME = ?'
* Exception message is [Column 'A1.FK_CONSORTIUM' is either not in any
table in the FROM list or appears within a join specification and is
outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER
TABLE  statement then 'A1.FK_CONSORTIUM' is not a column in the target
table.]


Tom

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org