RE: [OJB-developers] non-decomposed m:n-mappings update problem

[Hoang, H. <Hai...@co...>]

1.	There is no exceptions
2.	Based on the generated sql statements, I only see the insert
statements even though I was trying to remove a Permission from a Role.

 

For example I've RoleId = 37, PermissionId = 1, 3, 6.  Now, I want to remove
PermissionId=1 from a Role, What I want to see is

 

1.       DELETE htg_role_permission where role_id = 37

2.       INSERT INTO htg_role_permission (role_id,permission_id) VALUES
(37,3)

3.       INSERT INTO htg_role_permission (role_id,permission_id) VALUES
(37,6)

 

Is this a bug? Is anyone out there using this feature successfully?

 

 

 

 

[ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT
htg_role.role_id,htg_role.role_name,htg_rol

e.description,htg_role.parent_id FROM htg_role,htg_role_permission WHERE
(permission_id= ? )  AND ht

g_role_permission.role_id=htg_role.role_id ORDER BY htg_role.role_name

[ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: INSERT INTO
htg_role_permission (role_id,permissio

n_id) VALUES (37,3)

[ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: INSERT INTO
htg_role_permission (role_id,permissio

n_id) VALUES (37,6)

 

 

 

-----Original Message-----
From: Jakob Braeuchi [mailto:jbr...@ho...] 
Sent: Tuesday, May 28, 2002 12:09 PM
To: Hoang, Hai; 'ojb-developer'
Subject: Re: [OJB-developers] non-decomposed m:n-mappings update problem

 

hi,

 

1./2. so you have no exceptions at all ?

3. to enable SqlGenerator logging use

 

# Loger for SqlGenerator, useful for debugging generation of SQL
ojb.broker.accesslayer.SqlGenerator.LogLevel=DEBUG

in OJB.properties.

 

4. have you tried the latest cvs

 

jakob

----- Original Message ----- 

From: Hoang, Hai <mailto:Hai...@co...>  

To: 'Jakob <mailto:jbr...@ho...>  Braeuchi' ; 'ojb-developer'
<mailto:obj...@li...>  

Sent: Tuesday, May 28, 2002 6:34 PM

Subject: RE: [OJB-developers] non-decomposed m:n-mappings update problem

 

1.      It doesn't work when I try to remove a Permission to a Role

2.      It doesn't work when I tried to update a ParentId field on the Role.
ParentId has a recursive relationship with the Id field.

3.      I don't know where to find the generated sql-statement.  Can anyone
please show me

4.      I am using the latest build (8.4)

5.      I've tested both APIs but they both not working.

 

 

-----Original Message-----
From: Hoang, Hai 
Sent: Tuesday, May 28, 2002 11:05 AM
To: 'Jakob Braeuchi'; 'ojb-developer'
Subject: RE: [OJB-developers] non-decomposed m:n-mappings update problem

 

 

-----Original Message-----
From: Jakob Braeuchi [mailto:jbr...@ho...] 
Sent: Tuesday, May 28, 2002 10:24 AM
To: Hoang, Hai; obj...@li...
Subject: Re: [OJB-developers] non-decomposed m:n-mappings update problem

 

hi,

 

what do you mean by 'does not work', was there an exception ? what version
of ojb do you use ?

what did you try to do (insert or update) ? could you please provide the
generated sql-statements ?

 

jakob