I suspect this might be an instance of a problem that was discussed some months
back. Various things do not work if a table has no primary key. You must have a
primary key, even if you never use it.
On 04-Jul-2004 Vjeran Marcinko wrote:
> I noticed that this problem happens only in junction tables (just foreign
> keys columns), and when these columns are optional (can be null) ...
>
> -Vjeran
>
> ----- Original Message -----
> From: "T E Schmitz" <[EMAIL PROTECTED]>
> To: "Apache Torque Users List" <[EMAIL PROTECTED]>
> Sent: Sunday, July 04, 2004 6:32 PM
> Subject: Re: URGENT!! Optinanal foreign key column not deleting
>
>
>> Hello,
>> I am not quite sure why criteria / doSelect should return a result while
>> criteria / doDolete doesn't for the same values.
>>
>> But bear in mind that for doDelete and doUpdate "no hits" is not an
>> error. Therefore no exception is thrown. In fact, you don't get any
>> feedback at all. This in itself is a problem for some applications.
>>
>> You mention that you use "object" types rather than primitive. Have you
>> tried using new Integer(95) as a Criteria parameter?
>>
>>
>> > Criteria crit = new Criteria();
>> > crit.add(TmModelProfilePeer.MODEL_ID, 95);
>> > List list = TmModelProfilePeer.doSelect(crit);
>> >
>> > and eveything works fine. But when I want to delete these rows by same
>> > criteria :
>> > Criteria crit = new Criteria();
>> > crit.add(TmModelProfilePeer.MODEL_ID, 95);
>> > TmModelProfilePeer.doDelete(crit);
>> > it doesn't work. No exception, just no deletion. ??!!
>>
>> --
>>
>>
>> Regards/Gru�,
>>
>> Tarlika Elisabeth Schmitz
>>
>> ---------------------------------------------------------------------
>> 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]
>
--
Lead us not into temptation; we
can find our own way.
Raphael Mankin
----------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
