CODEWITHSUNDEEP
sqljpaeclipselinkglassfish-3
Hasan Tuncay
Hasan Tuncay

Reputation: 1108

Casting error after jpa query on database

This query gives a array ob objects instead of giving me the Tracking object back.

In the log i see: java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.quoka.qis.ads.web.tracking.Tracking

@NamedNativeQuery(
name = "Tracking.findByNo", 
query = "select * " +
    "from inet.TRACKING t " +
    "where t.prditmNO = ?1"
)


TypedQuery<Tracking> q = em.createNamedQuery("Tracking.findByNo", Tracking.class);
q.setParameter(1, adno);
List<Tracking> list = q.getResultList();
return list.isEmpty()?null:list.get(0);

Thanks for you help.

Upvotes: 0

Views: 305

Answers (1)

ppeterka
ppeterka

Reputation: 20726

You use a native query. You should use a JPA query.

 @NamedQuery( name = "Tracking.findByNo",  
              query = "select t " + 
                      "from Tracking t " +
                      "where t.prditmNO = ?1" )

Upvotes: 2

Related Questions