Hi,

iirc the deleteByQuery(...) method, just produces SQL that is forwarded to the database directly without any check on auto-delete settings. This method does not even remove deleted objects from cache.

Regards
danilo

Hiller, Frank RD-PT31 wrote:
Hi,

no, I don't get an error. When using "PersistenceBroker.deleteByQuery(QueryByCriteria q)" the
"parent" object is deleted, not the referenced objects.
I didn't check the OJB code, but I guess this is normal behaviour for
"deleteByQuery".

When I read the object first with
"PersistenceBroker.getObjectByQuery(QueryByCriteria q)" and delete the
received object everything is fine.

Best regards.............Frank

-----Original Message-----
From: Alessandro Colantoni [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 12:35 PM
To: OJB Users List
Subject: Re: PersistenceBroker.deleteByQuery(QueryByCriteria q) does not
delete objects referenced by a collection-descriptor?

Hi,
right, and if it is not deleted you could get run time error due to the
FK .
Anyway it is better you set the auto-delete to "object", that is the
same, but "true" and "false" are deprecated .

Best regards
Alessandro

On 12/13/07, Hiller, Frank RD-PT31 <[EMAIL PROTECTED]> wrote:
Hi Alessandro,

thank you for the quick response.

auto-delete is set to "true".

Otherwise "PersistenceBroker.delete(obj)" wouldn't delete the referenced collections either.

Best regards.............Frank

-----Original Message-----
From: Alessandro Colantoni [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 13, 2007 11:53 AM
To: OJB Users List
Subject: Re: PersistenceBroker.deleteByQuery(QueryByCriteria q) does not delete objects referenced by a collection-descriptor?

Hi,

it depends on the auto-delete settings:

http://db.apache.org/ojb/docu/guides/basic-technique.html#1%3A1+auto-x
xx
+setting

http://db.apache.org/ojb/docu/guides/basic-technique.html#1%3An+auto-x
xx
+setting

http://db.apache.org/ojb/docu/guides/basic-technique.html#m%3An+auto-x
xx
+setting


regards
Alessandro



On 12/13/07, Hiller, Frank RD-PT31 <[EMAIL PROTECTED]>
wrote:
Hi community,

I'm using PersistenceBroker of OJB1.0.3.

Is it correct that "PersistenceBroker.deleteByQuery(QueryByCriteria
q)"
does not delete objects referenced by a collection-descriptor?

Whene I use
(1) Object obj = PersistenceBroker.getObjectByQuery(QueryByCriteria q)
(2) PersistenceBroker.delete(obj)

it works.

Thanks
Frank


Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any
attachment from your system.

Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received

this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any
attachment from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Confidentiality note:
The information in this email and any attachment may contain confidential and 
proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates 
and may be privileged or otherwise protected from disclosure. If you are not 
the intended recipient, you are hereby notified that any review, reliance or 
distribution by others or forwarding without express permission is strictly 
prohibited and may cause liability. In case you have received this message due 
to an error in transmission, we kindly ask you to notify the sender immediately 
and to delete this email and any attachment from your system.

---------------------------------------------------------------------
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]

Reply via email to