Yes
javadoc says that I (or database) should take care about deleting references
so I think marking foreighn key as onDelete="cascade" will be good
choice to assure that rows will be deleted even if ojb will forget about
them.
What do you think?
Armin Waibel wrote:
Maksimenko Alexander wrote:
Thank for answer
Yes I know - but in some cases this processing is skipping
for example while deleting objects by query - in such case I get
constraint violation error from database
Currently this method doesn't support cascading delete of referenced
objects, see javadoc
http://db.apache.org/ojb/api/org/apache/ojb/broker/PersistenceBroker.html#deleteByQuery(org.apache.ojb.broker.query.Query)
regards
Armin
Thomas Dudziak wrote:
On 9/15/05, Maksimenko Alexander <[EMAIL PROTECTED]> wrote:
Hi All!
I specify auto-delete=true in my collection descriptor
/**
* @ojb.collection
element-class-ref="com.esaya.webmail.datamodel.folder.mail.EmailMessage"
foreignkey="mailFolderId"
* database-foreignkey="false" proxy="true"
collection-class="org.apache.ojb.broker.util.collections.ManageableArrayList"
* auto-delete="true" auto-update="false" proxy="true"
*/
private List content;
and generate database schema using Xdoclet
<ojbdoclet destdir="${torque.output.dir}" checks="basic">
<fileset dir="${outputDatabaseOjbJava}"/>
<ojbrepository
destinationFile="OJB-repository-types.xml" verbose="true"/>
<torqueschema databaseName="${pom.groupId}"
destinationFile="${torque.project}-schema.xml"/>
</ojbdoclet>
but got the following
<foreign-key foreignTable="FOLDER">
<reference local="MAIL_FOLDER_ID" foreign="ID"/>
</foreign-key>
so attribute onDelete="cascade" isn't genereted or I miss something
can somebody help?
The auto-delete="true" setting is processed by OJB, not the database,
therefore there is no corresponding setting in the schema XML.
Tom
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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]
