Get Max value from table in hibernate -


i using below java(1.7) function max value hsql using hibernate 4.3:

public int getmaxid() {     session session = hibernateutil.getsessionfactory().opensession();     query q = session.createquery("select cast(s.id integer) student s order cast(s.id integer) desc");     list result =  q.list();     return integer.parseint(result.get(0).tostring()); }

but getting below error:

    error: unexpected token: ) required: in statement [select cast(student0_.idasinteger) col_0_0_ public.public.student student0_ order  cast(student0_.id integer)desc]     exception in thread "main" org.hibernate.exception.sqlgrammarexception: not prepare statement         @ org.hibernate.exception.internal.sqlexceptiontypedelegate.convert(sqlexceptiontypedelegate.java:80)         @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49)         @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:126)         @ org.hibernate.engine.jdbc.internal.statementpreparerimpl$statementpreparationtemplate.preparestatement(statementpreparerimpl.java:196)         @ org.hibernate.engine.jdbc.internal.statementpreparerimpl.preparequerystatement(statementpreparerimpl.java:160)         @ org.hibernate.loader.loader.preparequerystatement(loader.java:1884)         @ org.hibernate.loader.loader.executequerystatement(loader.java:1861)         @ org.hibernate.loader.loader.executequerystatement(loader.java:1838)         @ org.hibernate.loader.loader.doquery(loader.java:909)         @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:354)         @ org.hibernate.loader.loader.dolist(loader.java:2551)         @ org.hibernate.loader.loader.dolist(loader.java:2537)         @ org.hibernate.loader.loader.listignorequerycache(loader.java:2367)         @ org.hibernate.loader.loader.list(loader.java:2362)         @ org.hibernate.hql.internal.classic.querytranslatorimpl.list(querytranslatorimpl.java:939)         @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:229)         @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1260)         @ org.hibernate.internal.queryimpl.list(queryimpl.java:103)         @ test.hservice.getmaxid(hservice.java:23)         @ test.test.main(test.java:19)     caused by: java.sql.sqlsyntaxerrorexception: unexpected token: ) required: in statement [select cast(student0_.idasinteger) col_0_0_ public.public.student student0_ order  cast(student0_.id integer)desc]         @ org.hsqldb.jdbc.jdbcutil.sqlexception(unknown source)         @ org.hsqldb.jdbc.jdbcutil.sqlexception(unknown source)         @ org.hsqldb.jdbc.jdbcpreparedstatement.<init>(unknown source)         @ org.hsqldb.jdbc.jdbcconnection.preparestatement(unknown source)         @ org.hibernate.engine.jdbc.internal.statementpreparerimpl$5.doprepare(statementpreparerimpl.java:162)         @ org.hibernate.engine.jdbc.internal.statementpreparerimpl$statementpreparationtemplate.preparestatement(statementpreparerimpl.java:186)         ... 16 more

if remove cast(s.id integer) select statement only, query works fine e.g.

    query q = session.createquery("select s.id student s order cast(s.id integer) desc");

i have use cast id varchar type column.


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more