Can't invoke delete sql from web service client

[sam White]

Hi,

I have an EAR project, written with CXF.
backend is built with hibernate 4.
The problem is when the client service facade execute a remove(obj) through web sersice, it doesnt' invoke the delete hibernate sql query in the backend.

The log message shown that it is going through the cxf calls:

I AM NOT ABLE TO PASTE THE LOG MESSAGE HERE DUE TO SITE RESTRICTION. ...

but there is no sign of finding its invocation with the "delete" sql query.

Here is my client service facade invoking the remove(obj) function:

@Override
    public void remove(String productId, String[] categoryIds) {
        if (categoryIds.length > 0) {
            Collection<ProductCategoryAssociate> pList 
= this.findByProductId(Integer.valueOf(productId), 0, this.count());
            Iterator<ProductCategoryAssociate> iterator = pList.iterator();
            for (int i=0; i<categoryIds.length; i++) {
                while (iterator.hasNext()) {
                       ProductCategoryAssociate p = iterator.next();
                       if (p.getCategoryId().getCategoryId().compareTo(Integer.valueOf(categoryIds[i])) == 0) {
                           logger.debug("==== removing product+category:"+productId+"; "+categoryIds[i]);
                            remove(p);
                       }
                }
            }
        }
    }

In the above code, logger.debug("======== removing product+category....") is executed, so I am very sure the remove(p) function is getting invoke.

Any help is much appreciated.
Thanks
Sam

[Praful Thakare]

can you post code of your remove method ? how are transactions handled? is there exception thrown after this call that might cause a rollback?