Hibernate version: 2.1.2

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="Project" table="PROJECT">
<id name="id" unsaved-value="null" type="int" column="ID" >
<generator class="identity" />
</id>
<set name="fkUser" table="PROJECT_USER">
<key column="PROJECT_ID" /> <!-- nama baru column di tabel PROJECT_USER, key column adalah field tabel ini(project) -->
<many-to-many class="User" column="USER_ID" />
</set>
</class>
</hibernate-mapping>


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<!-- id auto generation -->
<class name="User" table="USERS">
<id name="id" unsaved-value="null" type="int" column="ID" >
<generator class="identity" />
</id>
<set name="fkProject" table="PROJECT_USER" cascade="all">
<key column="USER_ID" /> <!-- nama baru column di tabel PROJECT_USER, key column adalah field tabel ini(USER) -->
<many-to-many class="Project" column="PROJECT_ID" />
</set>
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
public void removeUser(String code, List userList) throws HibernateException
{
sess = sessFact.openSession();
User tempUser = null;
Project theProject = null;
theProject = (Project) sess.find("from Project pro where " +
"lower(pro.projectCode) = lower( :code )",code,Hibernate.STRING).get(0);

Collection userSet = theProject.getFkUser();

Iterator it = userList.iterator();
while(it.hasNext())
{
tempUser = (User)it.next();
System.out.println(tempUser);

boolean set = userSet.remove(tempUser);
System.out.println(set);
}
Transaction tx = null;
try
{
tx = sess.beginTransaction();
sess.saveOrUpdate(theProject);
tx.commit();
}
catch(HibernateException he)
{
if(tx!=null) tx.rollback();
throw he;
}
finally
{
sess.close();
}
}



Full stack trace of any exception that occurs:

Name and version of the database you are using:MSSQL SERVER 2000

Debug level Hibernate log excerpt:

User :
Name = agung.binantoro
Password =
Initial = ABI
lastLogin = java.util.GregorianCalendar[time=1090835024140,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=6,WEEK_OF_YEAR=31,WEEK_OF_MONTH=5,DAY_OF_MONTH=26,DAY_OF_YEAR=208,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=4,AM_PM=1,HOUR=4,HOUR_OF_DAY=16,MINUTE=43,SECOND=44,MILLISECOND=140,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Implementation ,Implementation, TECH-DEPLOY
Status = null
Hibernate: select fkuser0_.USER_ID as USER_ID__, fkuser0_.PROJECT_ID as PROJECT_ID__, user1_.ID as ID0_, user1_.USERNAME as USERNAME0_, user1_.PASSWORD as PASSWORD0_, user1_.INITIAL as INITIAL0_, user1_.LAST_LOGIN as LAST_LOGIN0_, user1_.POSITION_ID as POSITION6_0_, user1_.DEPARTMENT_ID as DEPARTME7_0_, user1_.PROFILE_ID as PROFILE_ID0_, user1_.SUPERIOR_ID as SUPERIOR9_0_, user1_.STATUS as STATUS0_ from PROJECT_USER fkuser0_ inner join USERS user1_ on fkuser0_.USER_ID=user1_.ID where fkuser0_.PROJECT_ID=?
Hibernate: select details0_.ID as ID1_, details0_.FIRST_NAME as FIRST_NAME1_, details0_.MID_NAME as MID_NAME1_, details0_.LAST_NAME as LAST_NAME1_, details0_.ADDRESS as ADDRESS1_, details0_.EMAIL_ADDRESS as EMAIL_AD6_1_, details0_.MOBILE_PHONE as MOBILE_P7_1_, details0_.HOME_PHONE as HOME_PHONE1_, user1_.ID as ID0_, user1_.USERNAME as USERNAME0_, user1_.PASSWORD as PASSWORD0_, user1_.INITIAL as INITIAL0_, user1_.LAST_LOGIN as LAST_LOGIN0_, user1_.POSITION_ID as POSITION6_0_, user1_.DEPARTMENT_ID as DEPARTME7_0_, user1_.PROFILE_ID as PROFILE_ID0_, user1_.SUPERIOR_ID as SUPERIOR9_0_, user1_.STATUS as STATUS0_ from DETAILS details0_ left outer join USERS user1_ on details0_.ID=user1_.ID where details0_.ID=?
Hibernate: select details0_.ID as ID1_, details0_.FIRST_NAME as FIRST_NAME1_, details0_.MID_NAME as MID_NAME1_, details0_.LAST_NAME as LAST_NAME1_, details0_.ADDRESS as ADDRESS1_, details0_.EMAIL_ADDRESS as EMAIL_AD6_1_, details0_.MOBILE_PHONE as MOBILE_P7_1_, details0_.HOME_PHONE as HOME_PHONE1_, user1_.ID as ID0_, user1_.USERNAME as USERNAME0_, user1_.PASSWORD as PASSWORD0_, user1_.INITIAL as INITIAL0_, user1_.LAST_LOGIN as LAST_LOGIN0_, user1_.POSITION_ID as POSITION6_0_, user1_.DEPARTMENT_ID as DEPARTME7_0_, user1_.PROFILE_ID as PROFILE_ID0_, user1_.SUPERIOR_ID as SUPERIOR9_0_, user1_.STATUS as STATUS0_ from DETAILS details0_ left outer join USERS user1_ on details0_.ID=user1_.ID where details0_.ID=?
Hibernate: select details0_.ID as ID1_, details0_.FIRST_NAME as FIRST_NAME1_, details0_.MID_NAME as MID_NAME1_, details0_.LAST_NAME as LAST_NAME1_, details0_.ADDRESS as ADDRESS1_, details0_.EMAIL_ADDRESS as EMAIL_AD6_1_, details0_.MOBILE_PHONE as MOBILE_P7_1_, details0_.HOME_PHONE as HOME_PHONE1_, user1_.ID as ID0_, user1_.USERNAME as USERNAME0_, user1_.PASSWORD as PASSWORD0_, user1_.INITIAL as INITIAL0_, user1_.LAST_LOGIN as LAST_LOGIN0_, user1_.POSITION_ID as POSITION6_0_, user1_.DEPARTMENT_ID as DEPARTME7_0_, user1_.PROFILE_ID as PROFILE_ID0_, user1_.SUPERIOR_ID as SUPERIOR9_0_, user1_.STATUS as STATUS0_ from DETAILS details0_ left outer join USERS user1_ on details0_.ID=user1_.ID where details0_.ID=?
Hibernate: select position0_.ID as ID0_, position0_.POSITION_NAME as POSITION2_0_, position0_.POSITION_DESCRIPTION as POSITION3_0_, position0_.COST as COST0_ from POSITION position0_ where position0_.ID=?
Hibernate: select fkprojectm0_.ID as ID__, fkprojectm0_.PROJECT_MANAGER as PROJECT_5___, client1_.ID as ID0_, client1_.CLIENT_CODE as CLIENT_C2_0_, client1_.CLIENT_NAME as CLIENT_N3_0_, contactper2_.ID as ID1_, contactper2_.BILLING_FIRST_NAME as BILLING_2_1_, contactper2_.BILLING_MID_NAME as BILLING_3_1_, contactper2_.BILLING_LAST_NAME as BILLING_4_1_, contactper2_.BILLING_ADDRESS_1 as BILLING_5_1_, contactper2_.BILLING_ADDRESS_2 as BILLING_6_1_, contactper2_.BILLING_EMAIL as BILLING_7_1_, contactper2_.BILLING_PHONE as BILLING_8_1_, contactper2_.BILLING_FAX as BILLING_9_1_, contactper2_.BILLING_MOBILE as BILLING10_1_, contactper2_.PROJECT_FIRST_NAME as PROJECT11_1_, contactper2_.PROJECT_MID_NAME as PROJECT12_1_, contactper2_.PROJECT_LAST_NAME as PROJECT13_1_, contactper2_.PROJECT_ADDRESS_1 as PROJECT14_1_, contactper2_.PROJECT_ADDRESS_2 as PROJECT15_1_, contactper2_.PROJECT_EMAIL as PROJECT16_1_, contactper2_.PROJECT_PHONE as PROJECT17_1_, contactper2_.PROJECT_FAX as PROJECT18_1_, contactper2_.PROJECT_MOBILE as PROJECT19_1_, rategroup3_.RATE_TYPE as RATE_TYPE2_, rategroup3_.POSITION_ID as POSITION2_2_, rategroup3_.RATE_VALUE as RATE_VALUE2_, payment4_.ID as ID3_, payment4_.PAYMENT_NAME as PAYMENT_2_3_, payment4_.PAYMENT_DESCRIPTION as PAYMENT_3_3_, fkprojectm0_.ID as ID4_, fkprojectm0_.PROJECT_CODE as PROJECT_2_4_, fkprojectm0_.PROJECT_NAME as PROJECT_3_4_, fkprojectm0_.PROJECT_CLIENT as PROJECT_4_4_, fkprojectm0_.PROJECT_MANAGER as PROJECT_5_4_, fkprojectm0_.RATE_TYPE as RATE_TYPE4_, fkprojectm0_.POS_ID as POS_ID4_, fkprojectm0_.EST_START_DATE as EST_STAR8_4_, fkprojectm0_.EST_END_DATE as EST_END_9_4_, fkprojectm0_.START_DATE as START_DATE4_, fkprojectm0_.END_DATE as END_DATE4_, fkprojectm0_.PROJECT_VALUE as PROJECT12_4_, fkprojectm0_.PROJECT_PAYMENT_ID as PROJECT13_4_, fkprojectm0_.SCOPE_OF_WORK as SCOPE_O14_4_, fkprojectm0_.BUDGET as BUDGET4_, fkprojectm0_.ACTIVE as ACTIVE4_ from PROJECT fkprojectm0_ left outer join CLIENTS client1_ on fkprojectm0_.PROJECT_CLIENT=client1_.ID left outer join CONTACT_PERSON contactper2_ on fkprojectm0_.ID=contactper2_.ID left outer join RATE_GROUP rategroup3_ on fkprojectm0_.RATE_TYPE=rategroup3_.RATE_TYPE and fkprojectm0_.POS_ID=rategroup3_.POSITION_ID left outer join PAYMENT payment4_ on fkprojectm0_.PROJECT_PAYMENT_ID=payment4_.ID where fkprojectm0_.PROJECT_MANAGER=?
Hibernate: select fkproject0_.PROJECT_ID as PROJECT_ID__, fkproject0_.USER_ID as USER_ID__, project1_.ID as ID0_, project1_.PROJECT_CODE as PROJECT_2_0_, project1_.PROJECT_NAME as PROJECT_3_0_, project1_.PROJECT_CLIENT as PROJECT_4_0_, project1_.PROJECT_MANAGER as PROJECT_5_0_, project1_.RATE_TYPE as RATE_TYPE0_, project1_.POS_ID as POS_ID0_, project1_.EST_START_DATE as EST_STAR8_0_, project1_.EST_END_DATE as EST_END_9_0_, project1_.START_DATE as START_DATE0_, project1_.END_DATE as END_DATE0_, project1_.PROJECT_VALUE as PROJECT12_0_, project1_.PROJECT_PAYMENT_ID as PROJECT13_0_, project1_.SCOPE_OF_WORK as SCOPE_O14_0_, project1_.BUDGET as BUDGET0_, project1_.ACTIVE as ACTIVE0_ from PROJECT_USER fkproject0_ inner join PROJECT project1_ on fkproject0_.PROJECT_ID=project1_.ID where fkproject0_.USER_ID=?
Hibernate: select fkprojectm0_.ID as ID__, fkprojectm0_.PROJECT_MANAGER as PROJECT_5___, client1_.ID as ID0_, client1_.CLIENT_CODE as CLIENT_C2_0_, client1_.CLIENT_NAME as CLIENT_N3_0_, contactper2_.ID as ID1_, contactper2_.BILLING_FIRST_NAME as BILLING_2_1_, contactper2_.BILLING_MID_NAME as BILLING_3_1_, contactper2_.BILLING_LAST_NAME as BILLING_4_1_, contactper2_.BILLING_ADDRESS_1 as BILLING_5_1_, contactper2_.BILLING_ADDRESS_2 as BILLING_6_1_, contactper2_.BILLING_EMAIL as BILLING_7_1_, contactper2_.BILLING_PHONE as BILLING_8_1_, contactper2_.BILLING_FAX as BILLING_9_1_, contactper2_.BILLING_MOBILE as BILLING10_1_, contactper2_.PROJECT_FIRST_NAME as PROJECT11_1_, contactper2_.PROJECT_MID_NAME as PROJECT12_1_, contactper2_.PROJECT_LAST_NAME as PROJECT13_1_, contactper2_.PROJECT_ADDRESS_1 as PROJECT14_1_, contactper2_.PROJECT_ADDRESS_2 as PROJECT15_1_, contactper2_.PROJECT_EMAIL as PROJECT16_1_, contactper2_.PROJECT_PHONE as PROJECT17_1_, contactper2_.PROJECT_FAX as PROJECT18_1_, contactper2_.PROJECT_MOBILE as PROJECT19_1_, rategroup3_.RATE_TYPE as RATE_TYPE2_, rategroup3_.POSITION_ID as POSITION2_2_, rategroup3_.RATE_VALUE as RATE_VALUE2_, payment4_.ID as ID3_, payment4_.PAYMENT_NAME as PAYMENT_2_3_, payment4_.PAYMENT_DESCRIPTION as PAYMENT_3_3_, fkprojectm0_.ID as ID4_, fkprojectm0_.PROJECT_CODE as PROJECT_2_4_, fkprojectm0_.PROJECT_NAME as PROJECT_3_4_, fkprojectm0_.PROJECT_CLIENT as PROJECT_4_4_, fkprojectm0_.PROJECT_MANAGER as PROJECT_5_4_, fkprojectm0_.RATE_TYPE as RATE_TYPE4_, fkprojectm0_.POS_ID as POS_ID4_, fkprojectm0_.EST_START_DATE as EST_STAR8_4_, fkprojectm0_.EST_END_DATE as EST_END_9_4_, fkprojectm0_.START_DATE as START_DATE4_, fkprojectm0_.END_DATE as END_DATE4_, fkprojectm0_.PROJECT_VALUE as PROJECT12_4_, fkprojectm0_.PROJECT_PAYMENT_ID as PROJECT13_4_, fkprojectm0_.SCOPE_OF_WORK as SCOPE_O14_4_, fkprojectm0_.BUDGET as BUDGET4_, fkprojectm0_.ACTIVE as ACTIVE4_ from PROJECT fkprojectm0_ left outer join CLIENTS client1_ on fkprojectm0_.PROJECT_CLIENT=client1_.ID left outer join CONTACT_PERSON contactper2_ on fkprojectm0_.ID=contactper2_.ID left outer join RATE_GROUP rategroup3_ on fkprojectm0_.RATE_TYPE=rategroup3_.RATE_TYPE and fkprojectm0_.POS_ID=rategroup3_.POSITION_ID left outer join PAYMENT payment4_ on fkprojectm0_.PROJECT_PAYMENT_ID=payment4_.ID where fkprojectm0_.PROJECT_MANAGER=?
Hibernate: select contactper0_.ID as ID1_, contactper0_.BILLING_FIRST_NAME as BILLING_2_1_, contactper0_.BILLING_MID_NAME as BILLING_3_1_, contactper0_.BILLING_LAST_NAME as BILLING_4_1_, contactper0_.BILLING_ADDRESS_1 as BILLING_5_1_, contactper0_.BILLING_ADDRESS_2 as BILLING_6_1_, contactper0_.BILLING_EMAIL as BILLING_7_1_, contactper0_.BILLING_PHONE as BILLING_8_1_, contactper0_.BILLING_FAX as BILLING_9_1_, contactper0_.BILLING_MOBILE as BILLING10_1_, contactper0_.PROJECT_FIRST_NAME as PROJECT11_1_, contactper0_.PROJECT_MID_NAME as PROJECT12_1_, contactper0_.PROJECT_LAST_NAME as PROJECT13_1_, contactper0_.PROJECT_ADDRESS_1 as PROJECT14_1_, contactper0_.PROJECT_ADDRESS_2 as PROJECT15_1_, contactper0_.PROJECT_EMAIL as PROJECT16_1_, contactper0_.PROJECT_PHONE as PROJECT17_1_, contactper0_.PROJECT_FAX as PROJECT18_1_, contactper0_.PROJECT_MOBILE as PROJECT19_1_, project1_.ID as ID0_, project1_.PROJECT_CODE as PROJECT_2_0_, project1_.PROJECT_NAME as PROJECT_3_0_, project1_.PROJECT_CLIENT as PROJECT_4_0_, project1_.PROJECT_MANAGER as PROJECT_5_0_, project1_.RATE_TYPE as RATE_TYPE0_, project1_.POS_ID as POS_ID0_, project1_.EST_START_DATE as EST_STAR8_0_, project1_.EST_END_DATE as EST_END_9_0_, project1_.START_DATE as START_DATE0_, project1_.END_DATE as END_DATE0_, project1_.PROJECT_VALUE as PROJECT12_0_, project1_.PROJECT_PAYMENT_ID as PROJECT13_0_, project1_.SCOPE_OF_WORK as SCOPE_O14_0_, project1_.BUDGET as BUDGET0_, project1_.ACTIVE as ACTIVE0_ from CONTACT_PERSON contactper0_ left outer join PROJECT project1_ on contactper0_.ID=project1_.ID where contactper0_.ID=?
Hibernate: select fkloc0_.ID as ID__, fkloc0_.PROJECT_ID as PROJECT_ID__, city1_.ID as ID0_, city1_.CITY_NAME as CITY_NAME0_, city1_.CITY_DESCRIPTION as CITY_DES3_0_, state2_.ID as ID1_, state2_.STATE_NAME as STATE_NAME1_, state2_.STATE_DESCRIPTION as STATE_DE3_1_, country3_.ID as ID2_, country3_.COUNTRY_NAME as COUNTRY_2_2_, country3_.COUNTRY_DESCRIPTION as COUNTRY_3_2_, fkloc0_.ID as ID3_, fkloc0_.NAME as NAME3_, fkloc0_.ADDRESS_1 as ADDRESS_13_, fkloc0_.ADDRESS_2 as ADDRESS_23_, fkloc0_.POSTCODE as POSTCODE3_, fkloc0_.CITY_ID as CITY_ID3_, fkloc0_.STATE_ID as STATE_ID3_, fkloc0_.COUNTRY_ID as COUNTRY_ID3_, fkloc0_.PROJECT_ID as PROJECT_ID3_ from LOCATION fkloc0_ left outer join CITIES city1_ on fkloc0_.CITY_ID=city1_.ID left outer join STATES state2_ on fkloc0_.STATE_ID=state2_.ID left outer join COUNTRIES country3_ on fkloc0_.COUNTRY_ID=country3_.ID where fkloc0_.PROJECT_ID=?
Hibernate: select fkproject0_.PROJECT_ID as PROJECT_ID__, fkproject0_.USER_ID as USER_ID__, project1_.ID as ID0_, project1_.PROJECT_CODE as PROJECT_2_0_, project1_.PROJECT_NAME as PROJECT_3_0_, project1_.PROJECT_CLIENT as PROJECT_4_0_, project1_.PROJECT_MANAGER as PROJECT_5_0_, project1_.RATE_TYPE as RATE_TYPE0_, project1_.POS_ID as POS_ID0_, project1_.EST_START_DATE as EST_STAR8_0_, project1_.EST_END_DATE as EST_END_9_0_, project1_.START_DATE as START_DATE0_, project1_.END_DATE as END_DATE0_, project1_.PROJECT_VALUE as PROJECT12_0_, project1_.PROJECT_PAYMENT_ID as PROJECT13_0_, project1_.SCOPE_OF_WORK as SCOPE_O14_0_, project1_.BUDGET as BUDGET0_, project1_.ACTIVE as ACTIVE0_ from PROJECT_USER fkproject0_ inner join PROJECT project1_ on fkproject0_.PROJECT_ID=project1_.ID where fkproject0_.USER_ID=?
Hibernate: select fkprojectm0_.ID as ID__, fkprojectm0_.PROJECT_MANAGER as PROJECT_5___, client1_.ID as ID0_, client1_.CLIENT_CODE as CLIENT_C2_0_, client1_.CLIENT_NAME as CLIENT_N3_0_, contactper2_.ID as ID1_, contactper2_.BILLING_FIRST_NAME as BILLING_2_1_, contactper2_.BILLING_MID_NAME as BILLING_3_1_, contactper2_.BILLING_LAST_NAME as BILLING_4_1_, contactper2_.BILLING_ADDRESS_1 as BILLING_5_1_, contactper2_.BILLING_ADDRESS_2 as BILLING_6_1_, contactper2_.BILLING_EMAIL as BILLING_7_1_, contactper2_.BILLING_PHONE as BILLING_8_1_, contactper2_.BILLING_FAX as BILLING_9_1_, contactper2_.BILLING_MOBILE as BILLING10_1_, contactper2_.PROJECT_FIRST_NAME as PROJECT11_1_, contactper2_.PROJECT_MID_NAME as PROJECT12_1_, contactper2_.PROJECT_LAST_NAME as PROJECT13_1_, contactper2_.PROJECT_ADDRESS_1 as PROJECT14_1_, contactper2_.PROJECT_ADDRESS_2 as PROJECT15_1_, contactper2_.PROJECT_EMAIL as PROJECT16_1_, contactper2_.PROJECT_PHONE as PROJECT17_1_, contactper2_.PROJECT_FAX as PROJECT18_1_, contactper2_.PROJECT_MOBILE as PROJECT19_1_, rategroup3_.RATE_TYPE as RATE_TYPE2_, rategroup3_.POSITION_ID as POSITION2_2_, rategroup3_.RATE_VALUE as RATE_VALUE2_, payment4_.ID as ID3_, payment4_.PAYMENT_NAME as PAYMENT_2_3_, payment4_.PAYMENT_DESCRIPTION as PAYMENT_3_3_, fkprojectm0_.ID as ID4_, fkprojectm0_.PROJECT_CODE as PROJECT_2_4_, fkprojectm0_.PROJECT_NAME as PROJECT_3_4_, fkprojectm0_.PROJECT_CLIENT as PROJECT_4_4_, fkprojectm0_.PROJECT_MANAGER as PROJECT_5_4_, fkprojectm0_.RATE_TYPE as RATE_TYPE4_, fkprojectm0_.POS_ID as POS_ID4_, fkprojectm0_.EST_START_DATE as EST_STAR8_4_, fkprojectm0_.EST_END_DATE as EST_END_9_4_, fkprojectm0_.START_DATE as START_DATE4_, fkprojectm0_.END_DATE as END_DATE4_, fkprojectm0_.PROJECT_VALUE as PROJECT12_4_, fkprojectm0_.PROJECT_PAYMENT_ID as PROJECT13_4_, fkprojectm0_.SCOPE_OF_WORK as SCOPE_O14_4_, fkprojectm0_.BUDGET as BUDGET4_, fkprojectm0_.ACTIVE as ACTIVE4_ from PROJECT fkprojectm0_ left outer join CLIENTS client1_ on fkprojectm0_.PROJECT_CLIENT=client1_.ID left outer join CONTACT_PERSON contactper2_ on fkprojectm0_.ID=contactper2_.ID left outer join RATE_GROUP rategroup3_ on fkprojectm0_.RATE_TYPE=rategroup3_.RATE_TYPE and fkprojectm0_.POS_ID=rategroup3_.POSITION_ID left outer join PAYMENT payment4_ on fkprojectm0_.PROJECT_PAYMENT_ID=payment4_.ID where fkprojectm0_.PROJECT_MANAGER=?
Hibernate: select contactper0_.ID as ID1_, contactper0_.BILLING_FIRST_NAME as BILLING_2_1_, contactper0_.BILLING_MID_NAME as BILLING_3_1_, contactper0_.BILLING_LAST_NAME as BILLING_4_1_, contactper0_.BILLING_ADDRESS_1 as BILLING_5_1_, contactper0_.BILLING_ADDRESS_2 as BILLING_6_1_, contactper0_.BILLING_EMAIL as BILLING_7_1_, contactper0_.BILLING_PHONE as BILLING_8_1_, contactper0_.BILLING_FAX as BILLING_9_1_, contactper0_.BILLING_MOBILE as BILLING10_1_, contactper0_.PROJECT_FIRST_NAME as PROJECT11_1_, contactper0_.PROJECT_MID_NAME as PROJECT12_1_, contactper0_.PROJECT_LAST_NAME as PROJECT13_1_, contactper0_.PROJECT_ADDRESS_1 as PROJECT14_1_, contactper0_.PROJECT_ADDRESS_2 as PROJECT15_1_, contactper0_.PROJECT_EMAIL as PROJECT16_1_, contactper0_.PROJECT_PHONE as PROJECT17_1_, contactper0_.PROJECT_FAX as PROJECT18_1_, contactper0_.PROJECT_MOBILE as PROJECT19_1_, project1_.ID as ID0_, project1_.PROJECT_CODE as PROJECT_2_0_, project1_.PROJECT_NAME as PROJECT_3_0_, project1_.PROJECT_CLIENT as PROJECT_4_0_, project1_.PROJECT_MANAGER as PROJECT_5_0_, project1_.RATE_TYPE as RATE_TYPE0_, project1_.POS_ID as POS_ID0_, project1_.EST_START_DATE as EST_STAR8_0_, project1_.EST_END_DATE as EST_END_9_0_, project1_.START_DATE as START_DATE0_, project1_.END_DATE as END_DATE0_, project1_.PROJECT_VALUE as PROJECT12_0_, project1_.PROJECT_PAYMENT_ID as PROJECT13_0_, project1_.SCOPE_OF_WORK as SCOPE_O14_0_, project1_.BUDGET as BUDGET0_, project1_.ACTIVE as ACTIVE0_ from CONTACT_PERSON contactper0_ left outer join PROJECT project1_ on contactper0_.ID=project1_.ID where contactper0_.ID=?
Hibernate: select contactper0_.ID as ID1_, contactper0_.BILLING_FIRST_NAME as BILLING_2_1_, contactper0_.BILLING_MID_NAME as BILLING_3_1_, contactper0_.BILLING_LAST_NAME as BILLING_4_1_, contactper0_.BILLING_ADDRESS_1 as BILLING_5_1_, contactper0_.BILLING_ADDRESS_2 as BILLING_6_1_, contactper0_.BILLING_EMAIL as BILLING_7_1_, contactper0_.BILLING_PHONE as BILLING_8_1_, contactper0_.BILLING_FAX as BILLING_9_1_, contactper0_.BILLING_MOBILE as BILLING10_1_, contactper0_.PROJECT_FIRST_NAME as PROJECT11_1_, contactper0_.PROJECT_MID_NAME as PROJECT12_1_, contactper0_.PROJECT_LAST_NAME as PROJECT13_1_, contactper0_.PROJECT_ADDRESS_1 as PROJECT14_1_, contactper0_.PROJECT_ADDRESS_2 as PROJECT15_1_, contactper0_.PROJECT_EMAIL as PROJECT16_1_, contactper0_.PROJECT_PHONE as PROJECT17_1_, contactper0_.PROJECT_FAX as PROJECT18_1_, contactper0_.PROJECT_MOBILE as PROJECT19_1_, project1_.ID as ID0_, project1_.PROJECT_CODE as PROJECT_2_0_, project1_.PROJECT_NAME as PROJECT_3_0_, project1_.PROJECT_CLIENT as PROJECT_4_0_, project1_.PROJECT_MANAGER as PROJECT_5_0_, project1_.RATE_TYPE as RATE_TYPE0_, project1_.POS_ID as POS_ID0_, project1_.EST_START_DATE as EST_STAR8_0_, project1_.EST_END_DATE as EST_END_9_0_, project1_.START_DATE as START_DATE0_, project1_.END_DATE as END_DATE0_, project1_.PROJECT_VALUE as PROJECT12_0_, project1_.PROJECT_PAYMENT_ID as PROJECT13_0_, project1_.SCOPE_OF_WORK as SCOPE_O14_0_, project1_.BUDGET as BUDGET0_, project1_.ACTIVE as ACTIVE0_ from CONTACT_PERSON contactper0_ left outer join PROJECT project1_ on contactper0_.ID=project1_.ID where contactper0_.ID=?
Hibernate: select fkloc0_.ID as ID__, fkloc0_.PROJECT_ID as PROJECT_ID__, city1_.ID as ID0_, city1_.CITY_NAME as CITY_NAME0_, city1_.CITY_DESCRIPTION as CITY_DES3_0_, state2_.ID as ID1_, state2_.STATE_NAME as STATE_NAME1_, state2_.STATE_DESCRIPTION as STATE_DE3_1_, country3_.ID as ID2_, country3_.COUNTRY_NAME as COUNTRY_2_2_, country3_.COUNTRY_DESCRIPTION as COUNTRY_3_2_, fkloc0_.ID as ID3_, fkloc0_.NAME as NAME3_, fkloc0_.ADDRESS_1 as ADDRESS_13_, fkloc0_.ADDRESS_2 as ADDRESS_23_, fkloc0_.POSTCODE as POSTCODE3_, fkloc0_.CITY_ID as CITY_ID3_, fkloc0_.STATE_ID as STATE_ID3_, fkloc0_.COUNTRY_ID as COUNTRY_ID3_, fkloc0_.PROJECT_ID as PROJECT_ID3_ from LOCATION fkloc0_ left outer join CITIES city1_ on fkloc0_.CITY_ID=city1_.ID left outer join STATES state2_ on fkloc0_.STATE_ID=state2_.ID left outer join COUNTRIES country3_ on fkloc0_.COUNTRY_ID=country3_.ID where fkloc0_.PROJECT_ID=?
Hibernate: select fkloc0_.ID as ID__, fkloc0_.PROJECT_ID as PROJECT_ID__, city1_.ID as ID0_, city1_.CITY_NAME as CITY_NAME0_, city1_.CITY_DESCRIPTION as CITY_DES3_0_, state2_.ID as ID1_, state2_.STATE_NAME as STATE_NAME1_, state2_.STATE_DESCRIPTION as STATE_DE3_1_, country3_.ID as ID2_, country3_.COUNTRY_NAME as COUNTRY_2_2_, country3_.COUNTRY_DESCRIPTION as COUNTRY_3_2_, fkloc0_.ID as ID3_, fkloc0_.NAME as NAME3_, fkloc0_.ADDRESS_1 as ADDRESS_13_, fkloc0_.ADDRESS_2 as ADDRESS_23_, fkloc0_.POSTCODE as POSTCODE3_, fkloc0_.CITY_ID as CITY_ID3_, fkloc0_.STATE_ID as STATE_ID3_, fkloc0_.COUNTRY_ID as COUNTRY_ID3_, fkloc0_.PROJECT_ID as PROJECT_ID3_ from LOCATION fkloc0_ left outer join CITIES city1_ on fkloc0_.CITY_ID=city1_.ID left outer join STATES state2_ on fkloc0_.STATE_ID=state2_.ID left outer join COUNTRIES country3_ on fkloc0_.COUNTRY_ID=country3_.ID where fkloc0_.PROJECT_ID=?
Hibernate: select fkproject0_.PROJECT_ID as PROJECT_ID__, fkproject0_.USER_ID as USER_ID__, project1_.ID as ID0_, project1_.PROJECT_CODE as PROJECT_2_0_, project1_.PROJECT_NAME as PROJECT_3_0_, project1_.PROJECT_CLIENT as PROJECT_4_0_, project1_.PROJECT_MANAGER as PROJECT_5_0_, project1_.RATE_TYPE as RATE_TYPE0_, project1_.POS_ID as POS_ID0_, project1_.EST_START_DATE as EST_STAR8_0_, project1_.EST_END_DATE as EST_END_9_0_, project1_.START_DATE as START_DATE0_, project1_.END_DATE as END_DATE0_, project1_.PROJECT_VALUE as PROJECT12_0_, project1_.PROJECT_PAYMENT_ID as PROJECT13_0_, project1_.SCOPE_OF_WORK as SCOPE_O14_0_, project1_.BUDGET as BUDGET0_, project1_.ACTIVE as ACTIVE0_ from PROJECT_USER fkproject0_ inner join PROJECT project1_ on fkproject0_.PROJECT_ID=project1_.ID where fkproject0_.USER_ID=?
false
User :
Name = dezie
Password =
Initial = DLW
lastLogin = java.util.GregorianCalendar[time=1090928811250,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=6,WEEK_OF_YEAR=31,WEEK_OF_MONTH=5,DAY_OF_MONTH=27,DAY_OF_YEAR=209,DAY_OF_WEEK=3,DAY_OF_WEEK_IN_MONTH=4,AM_PM=1,HOUR=6,HOUR_OF_DAY=18,MINUTE=46,SECOND=51,MILLISECOND=250,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Implementation ,Implementation, TECH-DEPLOY
Status = null
false
User :
Name = lucytjandra
Password =
Initial = LTJ
lastLogin = java.util.GregorianCalendar[time=1090922962233,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=6,WEEK_OF_YEAR=31,WEEK_OF_MONTH=5,DAY_OF_MONTH=27,DAY_OF_YEAR=209,DAY_OF_WEEK=3,DAY_OF_WEEK_IN_MONTH=4,AM_PM=1,HOUR=5,HOUR_OF_DAY=17,MINUTE=9,SECOND=22,MILLISECOND=233,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Strategy & Planning ,Strategy & Planning, TECH-DEPLOY
Status = null
false
User :
Name = like
Password =
Initial = LMA
lastLogin = java.util.GregorianCalendar[time=1090576405407,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=6,WEEK_OF_YEAR=30,WEEK_OF_MONTH=4,DAY_OF_MONTH=23,DAY_OF_YEAR=205,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=4,AM_PM=1,HOUR=4,HOUR_OF_DAY=16,MINUTE=53,SECOND=25,MILLISECOND=407,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CAS
Dept = Department : Strategy & Planning ,Strategy & Planning, TECH-DEPLOY
Status = null
false
Final

So I notice here, that the collection is UNABLE to remove the object...can anyone point out where I did the error??? Thanks in advance

it's because the object isn't in the set, here's a snippet from Set javadoc


so unless you're convinced that the object you got from userList .equals(tempUser) that's the problem.
Please check whether it is or not.

however... if I used this code:

public void removeUser(String code, String userName) throws HibernateException
{
sess = sessFact.openSession();
User tempUser = null;
Project theProject = null;

theProject = (Project) sess.find("from Project pro where " +
"lower(pro.projectCode) = lower( :code )",code,Hibernate.STRING).get(0);
Set userSet = theProject.getFkUser();
tempUser = (User) sess.find("from User as usr " +
"where lower(usr.userName) = lower( :name )",userName,Hibernate.STRING).get(0);
userSet.remove(tempUser); Transaction tx = null;
try
{
tx = sess.beginTransaction();
sess.update(theProject);
tx.commit();
}
catch(HibernateException he)
{
if(tx!=null) tx.rollback();
throw he;
}
finally
{
sess.close();
}
}

IT WORKS!

this line appears in debug phase:

Hibernate: delete from PROJECT_USER where PROJECT_ID=? and USER_ID=?

So it's the collection I had a problem with. If anyone know how to solve the problem, I would be so thankful.

But this method is working????

What's the big difference between the assign User and the remove User?? I can't seem to understand, whether there has some compatibility problem between List and Set while they both has been converted to Collection...

public void assignUser(String code, List userList) throws HibernateException
{
sess = sessFact.openSession();
User tempUser = null;
Project theProject = null;
theProject = (Project) sess.find("from Project pro where " +
"lower(pro.projectCode) = lower( :code )",code,Hibernate.STRING).get(0);

Set userSet = new HashSet();

Iterator it = userList.iterator();
while(it.hasNext())
{
tempUser = (User)it.next();
userSet.add(tempUser);
}
theProject.setFkUser(userSet);
Transaction tx = null;
try
{
tx = sess.beginTransaction();
sess.update(theProject);
tx.commit();
}
catch(HibernateException he)
{
if(tx!=null) tx.rollback();
throw he;
}
finally
{
sess.close();
}

}

I can assure you the above line works perfectly.

you know I still get the feeling the objects were not equal.
why not print out .equals in the first code?
At least it will be one less thing to worry about, from your code it's impossible to know where that userList came from, or what happened to the objects in it before it got there.

Guys, I print the two objects... one is from the list, and the other is from the Set... they are exactly the same.

The set is in BLUE
the List is in GREEN


Name = agung.binantoro
Password = 19A9228DBBBE3B613190002E54DC3429
Initial = ABI
lastLogin = java.util.GregorianCalendar[time=1092968982343,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=34,WEEK_OF_MONTH=3,DAY_OF_MONTH=20,DAY_OF_YEAR=233,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=3,AM_PM=0,HOUR=9,HOUR_OF_DAY=9,MINUTE=29,SECOND=42,MILLISECOND=343,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Implementation ,Implementation, TECH-DEPLOY
Status = 1
false
User :
Name = dezie
Password = 94EAFD1D8B59FF3A991E9F226B023A29
Initial = DLW
lastLogin = java.util.GregorianCalendar[time=1092101056843,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=33,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=223,DAY_OF_WEEK=3,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=24,SECOND=16,MILLISECOND=843,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Implementation ,Implementation, TECH-DEPLOY
Status = 1
false
User :
Name = lucytjandra
Password = 7AAF0CA4B4E34DFDB30A1542646F97B9
Initial = LTJ
lastLogin = java.util.GregorianCalendar[time=1092812610187,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=34,WEEK_OF_MONTH=3,DAY_OF_MONTH=18,DAY_OF_YEAR=231,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=3,AM_PM=1,HOUR=2,HOUR_OF_DAY=14,MINUTE=3,SECOND=30,MILLISECOND=187,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Strategy & Planning ,Strategy & Planning, TECH-DEPLOY
Status = 1
false
User :
Name = like
Password = 27FCDC3C74FF7291A0C2F320757EB9D5
Initial = LMA
lastLogin = java.util.GregorianCalendar[time=1092641596030,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=34,WEEK_OF_MONTH=3,DAY_OF_MONTH=16,DAY_OF_YEAR=229,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=3,AM_PM=1,HOUR=2,HOUR_OF_DAY=14,MINUTE=33,SECOND=16,MILLISECOND=30,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CAS
Dept = Department : Strategy & Planning ,Strategy & Planning, TECH-DEPLOY
Status = 1
false

Retrieving the User
User :
Name = agung.binantoro
Password = 19A9228DBBBE3B613190002E54DC3429
Initial = ABI
lastLogin = java.util.GregorianCalendar[time=1092968982343,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=34,WEEK_OF_MONTH=3,DAY_OF_MONTH=20,DAY_OF_YEAR=233,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=3,AM_PM=0,HOUR=9,HOUR_OF_DAY=9,MINUTE=29,SECOND=42,MILLISECOND=343,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Implementation ,Implementation, TECH-DEPLOY
Status = 1
User is successfully retrieved
Retrieving the User
User :
Name = dezie
Password = 94EAFD1D8B59FF3A991E9F226B023A29
Initial = DLW
lastLogin = java.util.GregorianCalendar[time=1092101056843,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=33,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=223,DAY_OF_WEEK=3,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=24,SECOND=16,MILLISECOND=843,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Implementation ,Implementation, TECH-DEPLOY
Status = 1
User is successfully retrieved
Retrieving the User
User :
Name = lucytjandra
Password = 7AAF0CA4B4E34DFDB30A1542646F97B9
Initial = LTJ
lastLogin = java.util.GregorianCalendar[time=1092812610187,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=34,WEEK_OF_MONTH=3,DAY_OF_MONTH=18,DAY_OF_YEAR=231,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=3,AM_PM=1,HOUR=2,HOUR_OF_DAY=14,MINUTE=3,SECOND=30,MILLISECOND=187,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CON
Dept = Department : Strategy & Planning ,Strategy & Planning, TECH-DEPLOY
Status = 1
User is successfully retrieved
Retrieving the User
User :
Name = like
Password = 27FCDC3C74FF7291A0C2F320757EB9D5
Initial = LMA
lastLogin = java.util.GregorianCalendar[time=1092641596030,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Bangkok",offset=25200000,dstSavings=0,useDaylight=false,transitions=3,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2004,MONTH=7,WEEK_OF_YEAR=34,WEEK_OF_MONTH=3,DAY_OF_MONTH=16,DAY_OF_YEAR=229,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=3,AM_PM=1,HOUR=2,HOUR_OF_DAY=14,MINUTE=33,SECOND=16,MILLISECOND=30,ZONE_OFFSET=25200000,DST_OFFSET=0]
Position = CAS
Dept = Department : Strategy & Planning ,Strategy & Planning, TECH-DEPLOY
Status = 1
User is successfully retrieved

Check your equals/hashCode implementation.

read Michael's post, printing the same values doesn't mean the objects are equal.
this might not be your problem but it's very likely, so look there first