File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Java Products and Servers and the fly likes Problem on Resin CMP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Problem on Resin CMP" Watch "Problem on Resin CMP" New topic

Problem on Resin CMP

Frank Hung

Joined: Mar 11, 2004
Posts: 1
I encounter some problems while using resin CMP.
I find that when I get a object and update the value of attribute, resin don't really update it, instead it produce a new record
This violate the primary key constraint of my database so error occurs:
Exception while try to update invoice: com.caucho.ejb.EJBExceptionWrapper: com.caucho.transaction.RollbackExceptionWrapper: com.caucho.ejb.EJBExceptionWrapper: com.sybase.jdbc2.jdbc.SybSQLException: Attempt to insert duplicate key row in object 'invoice_items' with unique index 'invoice_it_14011080821'

My method of update data is simple, it is just the following codes:
myInvoiceItem = invoiceItemHome.findByJobNumberAndTarget(invoice_jobNo, invoice_target);

InvoiceItem findByJobNumberAndTarget(String job_number, String target)
throws FinderException;

SELECT o FROM invoiceItems o
AND UPPER(o.invoiceTarget) LIKE UPPER(?2)

I really don't know what is the problem. Can anyone help me?
I agree. Here's the link:
subject: Problem on Resin CMP
It's not a secret anymore!