File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

Problem on Resin CMP

Frank Hung
Greenhorn

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);
myInvoiceItem.setPrice(to_supplier);

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

<query>
<query-method>
<method-name>findByJobNumberAndTarget</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>
<![CDATA[
SELECT o FROM invoiceItems o
WHERE UPPER(o.jobNumber) LIKE UPPER(?1)
AND UPPER(o.invoiceTarget) LIKE UPPER(?2)
]]>
</ejb-ql>
</query>

I really don't know what is the problem. Can anyone help me?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem on Resin CMP