java - Native query works sqlDeveloper but fails using hibernate -


i have query want run using hibernate native sqlquery

when run query using sql developer works fine when hibernate run ,it throws exception 

java.sql.sqlexception: invalid column name     @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:112) ~[ojdbc14-10.2.0.4.0.jar:oracle jdbc driver version - "10.2.0.4.0"]     @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:146) ~[ojdbc14-10.2.0.4.0.jar:oracle jdbc driver version - "10.2.0.4.0"]     @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:208) ~[ojdbc14-10.2.0.4.0.jar:oracle jdbc driver version - "10.2.0.4.0"]     @ oracle.jdbc.driver.oraclestatement.getcolumnindex(oraclestatement.java:3319) ~[ojdbc14-10.2.0.4.0.jar:oracle jdbc driver version - "10.2.0.4.0"]     @ oracle.jdbc.driver.oracleresultsetimpl.findcolumn(oracleresultsetimpl.java:1926) ~[ojdbc14-10.2.0.4.0.jar:oracle jdbc driver version - "10.2.0.4.0"]     @ oracle.jdbc.driver.oracleresultset.getlong(oracleresultset.java:1575) ~[ojdbc14-10.2.0.4.0.jar:oracle jdbc driver version - "10.2.0.4.0"]     @ org.hibernate.type.descriptor.sql.biginttypedescriptor$2.doextract(biginttypedescriptor.java:63) ~[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]

this query hibernate logs :

hibernate: select o.guichet,count(*) operations o, guichet g, centre c date_operations between trunc(sysdate,'mm') , add_months(trunc(sysdate,'mm'),1) , c.centre_id=? , c.centre_id=g.centre_id , g.guichet_id=o.guichet group o.guichet

here's table class definition : 

@entity @table(name = "operations") public class operations implements serializable  {      private static final long serialversionuid = 1l;      @generatedvalue(strategy= generationtype.auto)     @id     private long operationsid;     private date dateoperations;     @manytoone()     @joincolumn(name = "guichet", referencedcolumnname = "guichetid")     private guichet guichet;

edit : here's code im defining method , using it

@repository public interface operationsrepository extends crudrepository<operations, long> {      @query(value="select o.guichet,count(*) operations o, guichet g, centre c date_operations between trunc(sysdate,'mm') , add_months(trunc(sysdate,'mm'),1) " +              "and c.centre_id=?1 , c.centre_id=g.centre_id , g.guichet_id=o.guichet " +              "group o.guichet",nativequery=true)     iterable<operations> operationsstat( long centreid);

using method : 

@override     public iterable<operations> operationsstat(long centreid) {         return operationsrepository.operationsstat(centreid);     }   @getmapping(value="/statistique")     @responsebody()     iterable<operations> dostatistique()     {         return operationsserviceimpl.operationsstat(new long(selectedcentre));      }

code after changing return type :

@repository public interface operationsrepository extends crudrepository<operations, long> {      @query(value="select o.guichet,count(*) operations o, guichet g, centre c date_operations between trunc(sysdate,'mm') , add_months(trunc(sysdate,'mm'),1) " +              "and c.centre_id=?1 , c.centre_id=g.centre_id , g.guichet_id=o.guichet " +              "group o.guichet",nativequery=true)     iterable<object> operationsstat( long centreid);

then :

@override     public iterable<object> operationsstat(long centreid) {         return operationsrepository.operationsstat(centreid);     }   @getmapping(value="/statistique")     @responsebody()     iterable<object> dostatistique()     {         return operationsserviceimpl.operationsstat(new long(selectedcentre));      }

Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more