[jboss-user] [EJB 3.0] - Help on javax.persistence.NonUniqueResultException

[scout1lacno]

Hi all,

Im developing and EJB 3.0 application with JBOSS 4.0.4.GA and NB 5.5. Im having an error below:


2006-10-18 14:11:08,690 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/CRM-war].[PlaceBean]] Servlet.service() for servlet PlaceBean threw exception
  | javax.ejb.EJBException: javax.persistence.NonUniqueResultException: org.hibernate.NonUniqueResultException: query did not return a unique result: 161
  | 	at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
  | 	at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
  | 	at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197)
  | 	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | 	at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
  | 	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | 	at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

The entity:

@Entity
  | @Table(name = "tblCountry")
  | public class TblCountry implements Serializable {
  | 
  |     @Id
  |     @Column(name = "IDCountry", nullable = false)
  |     private Integer iDCountry;
  | 
  |     @Column(name = "strCountry", nullable = false)
  |     private String strCountry;
  | 
  |     @Column(name = "strRegion")
  |     private String strRegion;

Does anyone has an idea about this error? A link?

Hope for a kind reply 

Thankz :)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3978978#3978978

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3978978