[ojb-users] Non-Decomposed N:M mappings and extents

[<Joa...@tp...>]

Hy,

I'm having a problem with non-decomposed N:M mappings (which seem to be the
source of quite some trouble) in combination with extents. I reduced it to
a simple Test case (I'll attach the repository_user.xml, the Java files and
the sql-script to create the DB (for MySQL) is available, when needed).
Basically I have one simple Class (called OneSide) that has a list of
ManySide objects. ManySide is an equally simple Class with an ID and a
value (String/VARCHAR). Additionally there is a class ManySideExtent that
extends ManySide and adds an additional attribute "anotherValue" (String as
well).

The Problem is that although the Code that handles M:N relations seems to
support extents it always breaks, 'cause it doesn't get the select
statement for the extended class correct (it fails to include the extended
class' table in the FROM-clause). The exception that is thrown is

General error: Unknown table 'manyside_extent' in field list
     at ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.java:199)
     at ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:361)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1100)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:877)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:937)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1013)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollection(PersistenceBrokerImpl.java:582)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollections(PersistenceBrokerImpl.java:626)
     at
ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:521)
     at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:289)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:880)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:925)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1013)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1000)
     at
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1170)
     at Test.ojbReadTest(Test.java:50)
     at Test.main(Test.java:24)

This occures when using the PersistenceBroker directly as well as when
using ODMG (though with ODMG it already happens at write time, OJB only
breaks when you try to read the object).

anyone got any idea? Is it just simple mis-configuration? Am I beeing blind
for something obvious? Please Help!

regards
Joachim Sauer