It's not a secret anymore!
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

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
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!