Also, which API are you using?
-Brian
On Thursday, October 16, 2003, at 01:50 AM, Hiu Yen Onn wrote:
hi,
currently, i am building a m:n non-decomposing mappings. User, Role and Users_Roles (intermediary table), the repository.xml is as such,
<class-descriptor class="my.com.shinyang.eply.model.User" table="USERS">
<field-descriptor name="label" column="LABEL" jdbc-type="VARCHAR" primarykey="true" />
<field-descriptor name="password" column="PASSWORD" jdbc-type="VARCHAR" />
<field-descriptor name="fullName" column="FULLNAME" jdbc-type="VARCHAR" />
<field-descriptor name="designation" column="DESIGNATION" jdbc-type="VARCHAR" />
<collection-descriptor name="roleList" element-class-ref="my.com.shinyang.eply.model.Role" auto-retrieve="true" auto-update="false" auto-delete="false" indirection-table="USERS_ROLES"> <fk-pointing-to-this-class column="USERS_LABEL"/> <fk-pointing-to-element-class column="ROLES_LABEL"/> </collection-descriptor> </class-descriptor>
<class-descriptor class="my.com.shinyang.eply.model.Role" table="ROLES">
<field-descriptor name="label" column="LABEL" jdbc-type="VARCHAR" primarykey="true" /> <field-descriptor name="roleName" column="ROLE_NAME" jdbc-type="VARCHAR" /> <field-descriptor name="allowCreate" column="ALLOWCREATE" jdbc-type="INTEGER" /> <field-descriptor name="allowSearch" column="ALLOWSEARCH" jdbc-type="INTEGER" /> <field-descriptor name="allowEdit" column="ALLOWEDIT" jdbc-type="INTEGER" /> <field-descriptor name="allowDelete" column="ALLOWDELETE" jdbc-type="INTEGER" />
<collection-descriptor name="userList" element-class-ref="my.com.shinyang.eply.model.User" auto-retrieve="true" auto-update="false" auto-delete="false" indirection-table="USERS_ROLES"> <fk-pointing-to-this-class column="ROLES_LABEL"/> <fk-pointing-to-element-class column="USERS_LABEL"/> </collection-descriptor>
</class-descriptor>
and i have done a junit to test the tables. this is the log of the test.
2003-10-16 13:25:54,855 ERROR [STDERR] Query "SELECT
A0.LABEL,A0.PASSWORD,A0.FULLNAME,A0.DESIGNATION FROM USERS A0 WHERE A0.LABEL
= 'yenonn' " execution time: 0 result set fetch time: 0
2003-10-16 13:25:54,902 ERROR [STDERR] Query "SELECT
LABEL,PASSWORD,FULLNAME,DESIGNATION FROM USERS WHERE LABEL = 'yenonn' "
execution time: 0 result set fetch time: 0
2003-10-16 13:25:54,918 ERROR [STDERR] Query "SELECT
ROLE_NAME,ALLOWDELETE,LABEL,ALLOWCREATE,ALLOWSEARCH,ALLOWEDIT FROM ROLES
WHERE LABEL = 'role0' " execution time: 0 result set fetch time: 0
2003-10-16 13:25:54,918 ERROR [STDERR] Query "SELECT
ROLE_NAME,ALLOWDELETE,LABEL,ALLOWCREATE,ALLOWSEARCH,ALLOWEDIT FROM ROLES
WHERE LABEL = 'role1' " execution time: 0 result set fetch time: 0
2003-10-16 13:25:54,918 ERROR [STDERR] Query "SELECT
ROLE_NAME,ALLOWDELETE,LABEL,ALLOWCREATE,ALLOWSEARCH,ALLOWEDIT FROM ROLES
WHERE LABEL = 'role2' " execution time: 0 result set fetch time: 0
2003-10-16 13:25:54,933 ERROR [STDERR] Query "INSERT INTO USERS
(LABEL,PASSWORD,FULLNAME,DESIGNATION) VALUES ('yenonn','yenonn','Hiu Yen
Onn','programmer') " execution time: 0
2003-10-16 13:25:55,043 ERROR [STDERR] Query "SELECT ROLES_LABEL FROM
USERS_ROLES WHERE USERS_LABEL='yenonn'" execution time: 0 result set fetch
time: 0
2003-10-16 13:25:55,043 ERROR [STDERR] Query "INSERT INTO USERS_ROLES
(USERS_LABEL,ROLES_LABEL) VALUES ('yenonn','role0')" execution time: 0
2003-10-16 13:25:55,043 ERROR [STDERR] Query "INSERT INTO USERS_ROLES
(USERS_LABEL,ROLES_LABEL) VALUES ('yenonn','role1')" execution time: 0
2003-10-16 13:25:55,043 ERROR [STDERR] Query "INSERT INTO USERS_ROLES
(USERS_LABEL,ROLES_LABEL) VALUES ('yenonn','role2')" execution time: 0
2003-10-16 13:25:55,058 ERROR [STDERR] Query "INSERT INTO ROLES
(LABEL,ROLE_NAME,ALLOWCREATE,ALLOWSEARCH,ALLOWEDIT,ALLOWDELETE) VALUES
('role0','syl-admin',1,1,1,1) " execution time: 15
2003-10-16 13:25:55,058 ERROR [STDERR] Query "DELETE FROM USERS_ROLES WHERE
ROLES_LABEL='role0'" execution time: 0
2003-10-16 13:25:55,058 ERROR [STDERR] Query "INSERT INTO ROLES
(LABEL,ROLE_NAME,ALLOWCREATE,ALLOWSEARCH,ALLOWEDIT,ALLOWDELETE) VALUES
('role1','syl-admin',1,1,1,1) " execution time: 0
2003-10-16 13:25:55,058 ERROR [STDERR] Query "DELETE FROM USERS_ROLES WHERE
ROLES_LABEL='role1'" execution time: 0
2003-10-16 13:25:55,058 ERROR [STDERR] Query "INSERT INTO ROLES
(LABEL,ROLE_NAME,ALLOWCREATE,ALLOWSEARCH,ALLOWEDIT,ALLOWDELETE) VALUES
('role2','syl-admin',1,1,1,1) " execution time: 0
2003-10-16 13:25:55,074 ERROR [STDERR] Query "DELETE FROM USERS_ROLES WHERE
ROLES_LABEL='role2'" execution time: 16
2003-10-16 13:25:55,074 ERROR [STDERR] Query "commit" execution time: 0
2003-10-16 13:25:55,074 ERROR [STDERR] Query "SET autocommit=1" execution
time: 0
2003-10-16 13:25:55,074 ERROR [STDERR] Query "SHOW VARIABLES LIKE
'tx_isolation'" execution time: 0 result set fetch time: 0
my problem is that, why does the deletion of Users_Roles is executed after
an insertion of
Roles done? how to get rid of not having a deletion of Users_Roles? what is
the setting that i should do? pls help....
--------------------------------------------------------------------- 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]
