java - How to use LIMIT in spring within sql query? -

-

somehow cannot use limit qualifier within sql query using spring-data-jpa:

@query("select p person p p.company.id = :id order p.name desc limit 3")

what wrong here?

caused by: org.hibernate.hql.internal.ast.querysyntaxexception: unexpected token: limit near line 1, column 146     @ org.hibernate.hql.internal.ast.querysyntaxexception.convert(querysyntaxexception.java:91)     @ org.hibernate.hql.internal.ast.errorcounter.throwqueryexception(errorcounter.java:109)     @ org.hibernate.hql.internal.ast.querytranslatorimpl.parse(querytranslatorimpl.java:304)     @ org.hibernate.hql.internal.ast.querytranslatorimpl.docompile(querytranslatorimpl.java:203)     @ org.hibernate.hql.internal.ast.querytranslatorimpl.compile(querytranslatorimpl.java:158)     @ org.hibernate.engine.query.spi.hqlqueryplan.<init>(hqlqueryplan.java:126)     @ org.hibernate.engine.query.spi.hqlqueryplan.<init>(hqlqueryplan.java:88)     @ org.hibernate.engine.query.spi.queryplancache.gethqlqueryplan(queryplancache.java:190)     @ org.hibernate.internal.abstractsessionimpl.gethqlqueryplan(abstractsessionimpl.java:301)     @ org.hibernate.internal.abstractsessionimpl.createquery(abstractsessionimpl.java:236)     @ org.hibernate.internal.sessionimpl.createquery(sessionimpl.java:1800)     @ org.hibernate.jpa.spi.abstractentitymanagerimpl.createquery(abstractentitymanagerimpl.java:328)     ... 48 more

limit not part of jpql. mechanism available in current release version (1.6.0.release of time of writing) pagination:

interface personrepository extends repository<person, long> {    @query("...")   list<person> findlimited(..., pageable pageable); }

this can used follows:

repository.findlimited(..., new pagerequest(0, 10));

this return first ten results of query defined in @query annotation.

the current master branch of spring data jpa contains new feature allow rewrite above query follows:

interface personrepository extends repository<person, long> {    list<person> findtop3bycompanyorderbyname(company company); }

as of version 1.7.0.m1 (feature already available in snapshots) query derivation mechanism understand top , first in subject clause limit number of results returned.


Comments

Post a Comment

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

-
this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
Read more

html - Accumulated Depreciation of Assets on php -

-
i have problem table print out asset accumulated depreciation on php, stright line method. $query = mysqli_query($connect, "select current_value, salvage_value, useful_life, placed_service assets"); if(!$query){ echo 'could not run query b: ' . mysqli_error($connect); exit; } while($asset = mysqli_fetch_row($query)){ echo "assets :"; print_r($asset); $month = 12; $year = date('y',strtotime($asset[3])); $first_year = $month - ((int)date('m',strtotime($asset[3]))-1); $last_year = $month - $first_year; $first = round((($asset[0] - $asset[1])/$asset[2])*(($first_year)/12),0); $last = round((($asset[0] - $asset[1])/$asset[2])*(($last_year)/12),0); $others = ($asset[0] - $asset[1])/$asset[2]; echo "<table border=1>"; echo "<tr><th>year</th><th>book value year start</th><th>depreciation expense</th><th...
Read more