Integration

String Click = req.getParameter("delete") == null ? "" : req.getParameter("delete").trim();
//out.print(Click);
int position=Click.indexOf('/');
String temp=Click.substring(0, position);

try {

em.getTransaction().begin();

Query query=em.createQuery("delete from PaymentRecords pm where pm.UserId= ?id");

query.setParameter("id", temp);
entr.commit();
did not do the delete. thank

Edited by: Hjava on Dec 15, 2010 1:18 AM

Edited by: Hjava on Dec 15, 2010 2:24 AM
I get error on unknow associate field in UserId , my userid is not the Pk for my student
@JoinColumn(name = "UserId", referencedColumnName = "UserId")
@ManyToOne(optional = false)
private student student;
I have the userId in my table but not in my entity class PaymentRecords !!! what should I do in this situition?