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

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

Accessing MATLAB's unicode strings from C -

javascript - mongodb won't find my schema method in nested container -