RAG_GROUP_SUBSCRIPTIONS - further investigation needed

Thomas,

I have some time slated Thursday and Friday to deal with 3.1
issues
and (I hope) to create 3.1 RC2. I'll try to look into this
issue then.

- Dave



On 12/8/06, Thomas-W Hofmann <thomas-w.hofmanndb.com> wrote:
> Hi, I am trying to drill down the double-insert into
> RAG_GROUP_SUBSCRIPTIONS  in 3.1 RC1
> I really need some help understanding how this works.
>
>
> I dont think it is a Oracle Problem. Looking further
into the sourcecode I
> find
>
> POJO PlanetSubscriptionData :
>
>    /**
>      * hibernate.set
table="rag_group_subscription"
lazy="true"
> cascade="save-update"
>      * hibernate.collection-key
column="subscription_id"
>      * hibernate.collection-many-to-many
column="group_id"
>
class="org.apache.roller.planet.pojos.PlanetGroupData&q
uot;
>      */
>
>
> POJO PlanetGroupData :
>
>     /**
>      * hibernate.set
table="rag_group_subscription"
lazy="true"
> invert="true" cascade="save-update"
>      * hibernate.collection-key column="group_id"
>      * hibernate.collection-many-to-many
column="subscription_id"
>
class="org.apache.roller.planet.pojos.PlanetSubscriptio
nData"
>      */
>
>
> Fact  : I created a uniqe constraint across both colums
and it is
> triggered every time I try to add a new feed
(standalone or in group).
>
> Thats what is happening without constraint :
>
> Hibernate: insert into rag_subscription (feed_url,
last_updated, site_url,
> title, author, inbound_links, inbound_blogs, id) values
(?, ?, ?, ?, ?, ?,
> ?, ?)
> Hibernate: insert into rag_group_subscription
(group_id, subscription_id)
> values (?, ?)
> Hibernate: insert into rag_group_subscription
(subscription_id, group_id)
> values (?, ?)
>
> where an identical entry is created (i.e. parameters
AND values are
> switched in the query)
>
> I worked on how things are done here using the XDoclet
parameters , but I
> am far from fully understanding how this works - and I
dont think I want
> to learn Hibernate :-(
>
>
> You are trying to fill the rag_group_subscription table
by updating it if
> rag_subscription or rag_group is updated(inserted).
>
> My 2 cent on it :
>
> You are defining
> hibernate.collection-many-to-many
column="group_id"
> hibernate.collection-many-to-many
column="subscription_id"
> why do you think this are many-to-many columns ?
>
> Does  cascade="save-update"  delete entries
from the table if a group is
> delted ?
>
> - have a nice weekend
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
> Thomas Hofmann
>
>
>
>
>
> --
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich
geschuetzte Informationen. Wenn Sie nicht der richtige
Adressat sind oder diese E-Mail irrtuemlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie
diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.
>
> This e-mail may contain confidential and/or privileged
information. If you are not the intended recipient (or have
received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized
copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
>