Hi again,
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 12:54 PM
Subject: Re: Strange UnitTest Failure with DB2
> Thanks for the quick reply: The modified test case indeed succeeds.
>
> I played a little with the code to find out which of the changes is
the
> essential one. It turns out that assigning a group id different from 0
to
> the ProductGroup fixes the problem. The transaction demarcation
without
> assigning a group id still reproduced the error.Somehow the group id 0
> seems to interfere with another test case, although I couldn't find
one
> that also uses a group id = 0 without auto-increment set to true.
>
> Anyway, I believe this kind of thing shouldn't hit us in a production
> application.
>
Without tx-demarcation OJB use connections with autoCommit mode
'true', this could cause some side-effects when several inserts were
necessary to store one object.
By the way it is recommended not to use primitive fields
in persistent objects if possible, because they can't be set 'null'
and thus OJB use 0 as 'null' value. We currently discuss to allow
user defined 'null'-values, so in future this will be full configurable
too.
regards,
Armin
> Thanks again,
> Gerhard
>
>
>
>
>
>
>
> "Armin Waibel" <[EMAIL PROTECTED]>
> 11.08.2003 11:00
> Bitte antworten an "OJB Users List"
>
>
> An: "OJB Users List" <[EMAIL PROTECTED]>
> Kopie:
> Thema: Re: Strange UnitTest Failure with DB2
>
>
> hmm strange, I checked in a modified version
> of this test case.
> Add tx-demarcation for object operations
> (this is necessary in non-managed environments).
> Give it a try ;-)
>
> regards,
> Armin
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, August 11, 2003 10:24 AM
> Subject: Strange UnitTest Failure with DB2
>
>
> > Hi all,
> >
> > We are currently evaluating OJB for use with our DB2 databases.
Trying
> to
> > run the JUnit tests we observe a rather strange behavior with the
> testcase
> >
>
org.apache.ojb.broker.OneToManyTest.testDeleteWithRemovalAwareCollection
> ():
> >
> > When running all tests (ant junit-no-compile), the testcase fails
with
> a
> > failed assertion (expeced <1> but was <0>). However, when running
just
> > OneToManyTest alone, the tests succeeds.
> >
> > We tried to track the problem down by logging the SQL with P6Spy and
> found
> > that in the failure case, OJB for some reason creates a new entry in
> > KATEGORIEN when it just should delete two ARTIKEL entries. It then
> moves
> > the ARTIKELs to this new KATEGORIEN entry (by changing the
> Kategorie_Nr
> > field) and then deletes the two ARTIKELs. The result is that there
are
> > zero ARTIKELS in the original KATEGORIEN entry (hence the testcase
> > failure) and one remaining of three with the mysterious new
KATEGORIEN
> > entry. This does not happen when running OneToManyTest alone.
> >
> > I am appending the SQL logs below. The SQL statements are condensed
> for
> > better readability and I added the Java code lines that triggererd
the
> > SQL.
> >
> > If someone could help shed a light on this, I would be most
grateful.
> (The
> > broker tests run fine when using HSQLDB).
> >
> > Gerhard Grosse
> >
> >
> > System Info:
> > JDK 1.3.1_08
> > OJB 1.0RC4 (with otm classes removed to compile with 1.3)
> > Client: Windows XP
> > Server: DB2 7.2 Linux
> >
> > SQL Log of OneToManyTest.testDeleteWithRemovalAwareCollection() when
> > running all tests:
> >
> > ProductGroupWithRemovalAwareCollection pg = new
> > ProductGroupWithRemovalAwareCollection();
> > pg.setGroupName("nice group");
> > Identity pgId = new Identity(pg, broker);
> > Article a = new Article();
> > a.setArticleName("a");
> > Article b = new Article();
> > b.setArticleName("b");
> > Article c = new Article();
> > c.setArticleName("c");
> > pg.add(a);
> > pg.add(b);
> > pg.add(c);
> > broker.store(pg);
> >
> > 1060348532390|0|1|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '0'
> > 1060348532390|0|1|statement|INSERT INTO Kategorien
> > (Kategorie_Nr,KategorieName) VALUES ('0','nice group')
> > 1060348532390|0|1|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '88894'
> >
> > 1060348532390|0|1|statement|INSERT INTO Artikel VALUES
> > ('88894','a','0','0','','0.0','0','0','0','0')
> > 1060348532390|0|1|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '88895'
> >
> > 1060348532390|0|1|statement|INSERT INTO Artikel VALUES
> > ('88895','b','0','0','','0.0','0','0','0','0')
> > 1060348532390|0|1|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '88896'
> >
> > 1060348532406| |1|statement|INSERT INTO Artikel VALUES
> > ('88896','c','0','0','','0.0','0','0','0','0')
> >
> > broker.clearCache();
> > pg = (ProductGroupWithRemovalAwareCollection)
> > broker.getObjectByIdentity(pgId);
> > assertEquals(3,pg.getAllArticles().size());
> >
> > 1060348535406|0|1|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '0'
> > 1060348535406|0|1|statement|SELECT FROM Artikel A0 WHERE
> A0.Kategorie_Nr =
> > '0'
> > 1060348535406|0|1|statement|SELECT FROM BOOKS A0 WHERE
A0.Kategorie_Nr
> =
> > '0'
> > 1060348535406|0|1|statement|SELECT FROM CDS A0 WHERE A0.Kategorie_Nr
=
> '0'
> >
> >
> > pg.getAllArticles().remove(c);
> > pg.getAllArticles().remove(0);
> > broker.store(pg);
> >
> > 1060348539406|0|1|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '88894'
> >
> > 1060348539406|0|1|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '0'
> > 1060348539406|0|1|statement|SELECT FROM Artikel A0 WHERE
> A0.Kategorie_Nr =
> > '25' ORDER BY 4 DESC
> > 1060348539406|0|1|statement|SELECT FROM BOOKS A0 WHERE
A0.Kategorie_Nr
> =
> > '25' ORDER BY 6 DESC
> > 1060348539406|0|1|statement|SELECT FROM CDS A0 WHERE A0.Kategorie_Nr
=
> > '25' ORDER BY 5 DESC
> > 1060348539421| |1|statement|UPDATE Kategorien SET
KategorieName='nice
> > group' WHERE Kategorie_Nr = '0'
> > 1060348539421|0|1|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '88895'
> >
> > 1060348539421|0|1|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '25'
> > 1060348539421|0|1|statement|INSERT INTO Kategorien VALUES
('25','nice
> > group','')
> > 1060348539421|0|1|statement|UPDATE Artikel SET Kategorie_Nr='25'
WHERE
> > Artikel_Nr = '88895'
> > 1060348539421|0|1|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '88896'
> >
> > 1060348539421|0|1|statement|UPDATE Kategorien SET
KategorieName='nice
> > group',Beschreibung='' WHERE Kategorie_Nr = '25'
> > 1060348539437|0|1|statement|UPDATE Artikel SET Kategorie_Nr='25'
WHERE
> > Artikel_Nr = '88896'
> > 1060348539437|0|1|statement|DELETE FROM Artikel WHERE Artikel_Nr =
> '88896'
> >
> > 1060348539437|0|1|statement|DELETE FROM Artikel WHERE Artikel_Nr =
> '88894'
> >
> >
> > broker.clearCache();
> > pg = (ProductGroupWithRemovalAwareCollection)
> > broker.getObjectByIdentity(pgId);
> > assertEquals(1,pg.getAllArticles().size()); // failure!
> >
> > 1060348544437|0|1|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '0'
> > 1060348544437|0|1|statement|SELECT FROM Artikel A0 WHERE
> A0.Kategorie_Nr =
> > '0'
> > 1060348544437|0|1|statement|SELECT FROM BOOKS A0 WHERE
A0.Kategorie_Nr
> =
> > '0'
> > 1060348544437|0|1|statement|SELECT FROM CDS A0 WHERE A0.Kategorie_Nr
=
> '0'
> >
> >
> > ===========================
> > SQL Log of OneToManyTest.testDeleteWithRemovalAwareCollection() when
> > running all tests:
> >
> > ProductGroupWithRemovalAwareCollection pg = new
> > ProductGroupWithRemovalAwareCollection();
> > pg.setGroupName("nice group");
> > Identity pgId = new Identity(pg, broker);
> > Article a = new Article();
> > a.setArticleName("a");
> > Article b = new Article();
> > b.setArticleName("b");
> > Article c = new Article();
> > c.setArticleName("c");
> > pg.add(a);
> > pg.add(b);
> > pg.add(c);
> > broker.store(pg);
> >
> > 1060350474953|0|0|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '0'
> > 1060350474968| |0|statement|INSERT INTO Kategorien
> > (Kategorie_Nr,KategorieName) VALUES ('0','nice group')
> > 1060350475031|0|1|statement|SELECT
> > A0.MAX_KEY,A0.TABLENAME,A0.GRAB_SIZE,A0.VERSION,A0.FIELDNAME FROM
> > OJB_HL_SEQ A0 WHERE (A0.TABLENAME LIKE ? ) AND A0.FIELDNAME LIKE ?
> > |SELECT A0.MAX_KEY,A0.TABLENAME,A0.GRAB_SIZE,A0.VERSION,A0.FIELDNAME
> FROM
> > OJB_HL_SEQ A0 WHERE (A0.TABLENAME LIKE 'SEQ_Artikel' ) AND
> A0.FIELDNAME
> > LIKE 'Artikel_Nr'
> >
> > 1060350475046|0|0|statement||SELECT MAX(Artikel_Nr) FROM Artikel
> > 1060350475046|0|0|statement||SELECT MAX(Artikel_Nr) FROM BOOKS
> > 1060350475046|0|0|statement||SELECT MAX(Artikel_Nr) FROM CDS
> > 1060350475062|0|0|statement||SELECT MAX(Artikel_Nr) FROM BOOKS
> > 1060350475062|0|0|statement||SELECT MAX(Artikel_Nr) FROM CDS
> > 1060350475062|0|1|statement|SELECT
> > MAX_KEY,TABLENAME,GRAB_SIZE,VERSION,FIELDNAME FROM OJB_HL_SEQ WHERE
> > TABLENAME = ? AND FIELDNAME = ? |SELECT
> > MAX_KEY,TABLENAME,GRAB_SIZE,VERSION,FIELDNAME FROM OJB_HL_SEQ WHERE
> > TABLENAME = 'SEQ_Artikel' AND FIELDNAME = 'Artikel_Nr'
> > 1060350475062|0|1|statement|INSERT INTO OJB_HL_SEQ
> > (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?)
> |INSERT
> > INTO OJB_HL_SEQ (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION)
VALUES
> > ('SEQ_Artikel','Artikel_Nr','222','20','1')
> > 1060350475062|0|1|commit||
> >
> > 1060350475078| |0|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '203'
> > 1060350475078|0|0|statement|INSERT INTO Artikel VALUES
> > ('203','a','0','0','','0.0','0','0','0','0')
> > 1060350475078|0|0|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '204'
> > 1060350475093|0|0|statement|INSERT INTO Artikel VALUES
> > ('204','b','0','0','','0.0','0','0','0','0')
> > 1060350475093|0|0|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '205'
> > 1060350475093|0|0|statement|INSERT INTO Artikel VALUES
> > ('205','c','0','0','','0.0','0','0','0','0')
> >
> > broker.clearCache();
> > pg = (ProductGroupWithRemovalAwareCollection)
> > broker.getObjectByIdentity(pgId);
> > assertEquals(3,pg.getAllArticles().size());
> >
> > 1060350478093|0|0|statement|SELECT Kategorien WHERE Kategorie_Nr =
'0'
> > 1060350478109|0|0|statement|SELECT FROM Artikel A0 WHERE
> A0.Kategorie_Nr =
> > '0'
> > 1060350478109|0|0|statement|SELECT FROM BOOKS A0 WHERE
A0.Kategorie_Nr
> =
> > '0'
> > 1060350478125|0|0|statement|SELECT FROM CDS A0 WHERE A0.Kategorie_Nr
=
> '0'
> >
> >
> > pg.getAllArticles().remove(c);
> > pg.getAllArticles().remove(0);
> > broker.store(pg);
> >
> > 1060350482125|0|0|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '203'
> > 1060350482125|0|0|statement|UPDATE Kategorien SET
KategorieName='nice
> > group' WHERE Kategorie_Nr = '0'
> > 1060350482125|0|0|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '204'
> > 1060350482140|0|0|statement|UPDATE Artikel SET Kategorie_Nr='0'
WHERE
> > Artikel_Nr = '204'
> > 1060350482140|0|0|statement|SELECT FROM Artikel WHERE Artikel_Nr =
> '205'
> > 1060350482140|0|0|statement|UPDATE Artikel SET Kategorie_Nr='0'
WHERE
> > Artikel_Nr = '205'
> > 1060350482156| |0|statement|DELETE FROM Artikel WHERE Artikel_Nr =
> '205'
> > 1060350482156|0|0|statement|DELETE FROM Artikel WHERE Artikel_Nr =
> '203'
> >
> > broker.clearCache();
> > pg = (ProductGroupWithRemovalAwareCollection)
> > broker.getObjectByIdentity(pgId);
> > assertEquals(1,pg.getAllArticles().size()); // ok
> >
> > 1060350487156|0|0|statement|SELECT FROM Kategorien WHERE
Kategorie_Nr
> =
> > '0'
> > 1060350487156|0|0|statement|SELECT FROM Artikel A0 WHERE
> A0.Kategorie_Nr =
> > '0'
> > 1060350487156|0|0|statement|SELECT FROM BOOKS A0 WHERE
A0.Kategorie_Nr
> =
> > '0'
> > 1060350487156|0|0|statement|SELECT FROM CDS A0 WHERE A0.Kategorie_Nr
=
> '0'
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
