mysql - Spring Data JPA: @Query gives error java.sql.SQLException: Column 'id' not found -


i trying run following query

@org.springframework.stereotype.repository public interface reportingparamrepository extends repository<reportingparamdao, integer> {      @query(nativequery = true, value = "select student, avg(height) reportingparams group student")     public list<reportingparamdao> getaveragegroupbystudent(); }

this dao

@entity @table(name = "reportingparams") @namedquery(name = "reportingparams.findall", query = "select r reportingparamdao r") public class reportingparamdao extends basedao<integer, reportingparam> implements dao<integer> {      private static final long serialversionuid = 1l;      @id     @generatedvalue(strategy = generationtype.identity)     @column(unique = true, nullable = false)     private integer id;      @manytoone     @joincolumn(name = "student", nullable = true)     private studentdao studentbean;      @column     private long height;      public integer getid() {         return id;     }      public void setid(integer id) {         this.id = id;     }      public studentdao getstudentbean() {         return studentbean;     }      public void setstudentbean(studentdao studentbean) {         this.studentbean = studentbean;     }      public long getheight() {         return height;     }      public void setheight(long height) {         this.height = height;     } }

but on executing repository method following error

java.sql.sqlexception: column 'id' not found.     @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:964) ~[mysql-connector-java-5.1.43.jar:5.1.43]     @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:897) ~[mysql-connector-java-5.1.43.jar:5.1.43]     @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:886) ~[mysql-connector-java-5.1.43.jar:5.1.43]     @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:860) ~[mysql-connector-java-5.1.43.jar:5.1.43]     @ com.mysql.jdbc.resultsetimpl.findcolumn(resultsetimpl.java:1077) ~[mysql-connector-java-5.1.43.jar:5.1.43]     @ com.mysql.jdbc.resultsetimpl.getint(resultsetimpl.java:2567) ~[mysql-connector-java-5.1.43.jar:5.1.43]     @ org.apache.commons.dbcp2.delegatingresultset.getint(delegatingresultset.java:283) ~[commons-dbcp2-2.1.1.jar:2.1.1]     @ org.apache.commons.dbcp2.delegatingresultset.getint(delegatingresultset.java:283) ~[commons-dbcp2-2.1.1.jar:2.1.1]     @ org.hibernate.type.descriptor.sql.integertypedescriptor$2.doextract(integertypedescriptor.java:62) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.type.descriptor.sql.basicextractor.extract(basicextractor.java:47) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:238) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:234) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:224) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.type.abstractstandardbasictype.hydrate(abstractstandardbasictype.java:300) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.extractkeysfromresultset(loader.java:789) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.getrowfromresultset(loader.java:714) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.processresultset(loader.java:972) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.doquery(loader.java:930) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:336) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.dolist(loader.java:2617) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.dolist(loader.java:2600) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.listignorequerycache(loader.java:2429) ~[hibernate-core-5.0.12.final.jar:5.0.12.final]     @ org.hibernate.loader.loader.list(loader.java:2424) ~[hibernate-core-5.0.12.final.jar:5.0.12.final] ...

if run query directly mysql terminal works fine , proper output. can please help? !!

this can't work. query fetches student object, trying map list of reportingparamdao's.


Comments

Post a Comment

Popular posts from this blog

What is happening when Matlab is starting a "parallel pool"? -

running parallel cpu processes in matlab starts command parpool() according documentation , function: [creates] special job on pool of workers, , [connects] matlab client parallel pool. this function takes bit of time execute, on order of 30 seconds. in other multi-cpu paradigms openmp, parallel execution seems totally transparent -- i've never noticed behavior analogous matlab (granted i'm not experienced parallel programming). so, happening between time parpool() called , when finishes executing? takes long? parallel computing toolbox enables run matlab code in parallel using several different paradigms (e.g. jobs , tasks, parfor , spmd , parfeval , batch processing), , run either locally (parallelised across cores in local machine) or remotely (parallelised across machines in cluster - either 1 own, or 1 in cloud). in of these cases, code run on matlab workers , copies of matlab without interactive desktop. if you're intending run on remo...
Read more

php - Cannot override Laravel Spark authentication with own implementation -

during login process of laravel spark need request token of remote api. api stores exact same users , passwords laravel spark application. therefore need username , non hashed password of user during authentication process. i thought overriding authenticated method solution problem. in routes/web.php override post /login endpoint , pointing endpoint own logincontroller: <?php namespace app\http\controllers\auth; use illuminate\support\facades\log; use illuminate\http\request; use laravel\spark\http\controllers\auth\logincontroller sparklogincontroller; class logincontroller extends sparklogincontroller { /** * create new login controller instance. * * @return void */ public function __construct() { parent::__construct(); } /** * handle successful authentication attempt. * * @param request $request * @param \illuminate\contracts\auth\authenticatable $user * @return response */ public fu...
Read more

Qt QGraphicsScene is not accessable from QGraphicsView (on Qt 5.6.1) -

i new qt. trying catch mouse press , release in qgraphicsview area , draw line. this, extended qgraphicsview , called myqgraphicsview . seems scene not attached since added " hello world " , never appears in view. here code extended class: class myqgraphicsview : public qgraphicsview { q_object public: myqgraphicsview(qgraphicsscene *scene, qwidget *parent = q_nullptr) : qgraphicsview(scene,parent){ // qgraphicsview::qgraphicsview(scene,parent); } qpoint *pointptr, *startpos,*endpos; qgraphicsview *cv;//maa qgraphicsscene *c; qgraphicsscene *sceneptr; // maa protected: void paintevent(qpaintevent *event) { show(); } void mousepressevent(qmouseevent *event) { // pos wrt widget. global wer global screen qdebug()<<" mouse pressed @ "<<qwidget::mapfromglobal(event->globalpos()); //globalx(); startpos = new qpoint; startpos->setx(qwidget::mapfromglobal(event->globalpos()).x()); startpos->sety(qw...
Read more