java - JPA: PGobject cannot be cast -
java - JPA: PGobject cannot be cast -
i'm using jpa first time , i'm getting error when seek query postgres database:
exception in thread "main" java.lang.classcastexception: org.postgresql.util.pgobject cannot cast [ljava.lang.object;
the code is:
list<results> r = em.createnativequery("select r results r\n" + "inner bring together session s on s.session_id = r.session_id s.session_id = '" + sessionid + "'").getresultlist();
i've tried object[], error still same
list<object[]> r = em.createnativequery("select r results r\n" + "inner bring together session s on s.session_id = r.session_id s.session_id = '" + sessionid + "'").getresultlist();
someone knows whats wrong?
i noticed using jpql syntax nativequery, have tried code createquery method()?
list<results> r = em.createquery("select r results r\n" + "inner bring together session s on s.session_id = r.session_id s.session_id = '" + sessionid + "'").getresultlist();
if sql right , using native query,
query query = em.createnativequery(select * results r\n" + "inner bring together session s on s.session_id = r.session_id s.session_id = '" + sessionid + "'"); list<object[]> result = query.getresultlist();
return without class cast exception?
java postgresql jpa casting
Comments
Post a Comment