Hiya posted this earlier but no replies maybe due to lack of information,
but we can't figure it out at all:
//A User Class
<class-descriptor class="x.User" table="users" >
<field-descriptor autoincrement="true" column="u_id" id="1"
jdbc-type="INTEGER" name="id" primarykey="true" />
<field-descriptor column="u_firstname" id="2" jdbc-type="VARCHAR" />
</class-descriptor>
//Some Class Using this User
<class-descriptor class="x.Vacancy" table="vacancies" >
<field-descriptor autoincrement="true" column="v_id" id="1"
jdbc-type="INTEGER" name="id" primarykey="true" />
<field-descriptor name="userId" column="v_userId" id="2"
jdbc-type="INTEGER" />
<reference-descriptor name="user" class-ref="x.User"
auto-retrieve="true" auto-update="true" auto-delete="true">
<foreignkey field-id-ref="2"/>
</reference-descriptor>
</class-descriptor>
yet if we do
(from a retrieved (succesfully) Vacancy)
Criteria criteria = new Criteria();
criteria.addEqualTo("id", new Integer(aVacancy.getId()));
Query aQuery = new QueryByCriteria(x.Vacancy, criteria); //
mBroker.deleteByQuery(aQuery); //
765 [AWT-EventQueue-0] DEBUG
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl - Try to change
autoCommit state to 'false'
67937 [AWT-EventQueue-0] DEBUG
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl - deleteByQuery
x.Vacancy, Query from class x.Vacancy where
[EMAIL PROTECTED]
67937 [AWT-EventQueue-0] DEBUG
org.apache.ojb.broker.accesslayer.JdbcAccessImpl - executeDelete (by Query)
: Query from class x.Vacancy where
[EMAIL PROTECTED]
67937 [AWT-EventQueue-0] DEBUG
org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl - SQL: DELETE
FROM vacancies WHERE v_id = ?
68125 [AWT-EventQueue-0] DEBUG
org.apache.ojb.broker.accesslayer.StatementManager - closeResources was
called
hence it deletes the Vacancy Succesfully yet the User (whose foreignkey is
correct in the database) doesn't get deleted even with everything set to
auto-x = "true"
we tried several mBroker.delete attempts but none did a cascading delete
we are at a loss.
Onno.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
