java - build a org.eclipse.persistence.queries.ReportQuery from a javax.persistence.Query -

-

i trying use single named query both obtaining set of results , count available amount of data. have named jpql query:

@namedquery(name = "query.all.absences.by.name", query = "select absence a.name = :name")

when obtain absences i'm invoking query this:

final query q = em.createnamedquery("query.all.absences.by.name"); q.setparameter("name","arandomabsencename"); //maxresults , firstresult coming parameters, computed in method q.setmaxresults(maxresults); q.setfirstresult(firstresult);

q.getresultlist() gets me correct result set. far good.

now want use same named query execute count query. i'm doing following:

final query q = em.createnamedquery("query.all.absences.by.name"); q.setparameter("name","arandomabsencename"); q.sethint(queryhints.query_type, "org.eclipse.persistence.queries.reportquery"); final reportquery test = jpahelper.getreportquery(q); test.addcount(); test.setshouldreturnwithoutreportqueryresult(true);

this approach works fine if named query not have parameters. parameters, if execute reportquery defined above have following exception:

exception [eclipselink-6094] (eclipse persistence services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.queryexception exception description: parameter name [name] in query's selection criteria not match parameter name defined in query. query: reportquery(referenceclass=absencecategory sql="select count(category_key) absence_category (category_key = ?)")     @ org.eclipse.persistence.exceptions.queryexception.parameternamemismatch(queryexception.java:1063)     @ org.eclipse.persistence.internal.expressions.parameterexpression.getvalue(parameterexpression.java:275)     @ org.eclipse.persistence.internal.databaseaccess.databasecall.translate(databasecall.java:1000)     @ org.eclipse.persistence.internal.queries.datasourcecallquerymechanism.executecall(datasourcecallquerymechanism.java:206)     @ org.eclipse.persistence.internal.queries.datasourcecallquerymechanism.executecall(datasourcecallquerymechanism.java:193)     @ org.eclipse.persistence.internal.queries.datasourcecallquerymechanism.executeselectcall(datasourcecallquerymechanism.java:264)     @ org.eclipse.persistence.internal.queries.datasourcecallquerymechanism.selectallrows(datasourcecallquerymechanism.java:646)     @ org.eclipse.persistence.internal.queries.expressionquerymechanism.selectallrowsfromtable(expressionquerymechanism.java:2611)     @ org.eclipse.persistence.internal.queries.expressionquerymechanism.selectallreportqueryrows(expressionquerymechanism.java:2554)     @ org.eclipse.persistence.queries.reportquery.executedatabasequery(reportquery.java:846)     @ org.eclipse.persistence.queries.databasequery.execute(databasequery.java:844)     @ org.eclipse.persistence.queries.objectlevelreadquery.execute(objectlevelreadquery.java:1040)     @ org.eclipse.persistence.queries.readallquery.execute(readallquery.java:392)     @ org.eclipse.persistence.queries.objectlevelreadquery.executeinunitofwork(objectlevelreadquery.java:1128)     @ org.eclipse.persistence.internal.sessions.unitofworkimpl.internalexecutequery(unitofworkimpl.java:2871)     @ org.eclipse.persistence.internal.sessions.abstractsession.executequery(abstractsession.java:1516)     @ org.eclipse.persistence.internal.sessions.abstractsession.executequery(abstractsession.java:1498)     @ org.eclipse.persistence.internal.sessions.abstractsession.executequery(abstractsession.java:1449)

how else can possibly set parameters reportquery?

i'm using eclipselink 2.0.

how executing reportquery? need call session.executequery(query, arguments) , pass list of arguments (order same query.getarguments().

you can use jpaentitymanager createquery(databasequery) api convert reportquery jpa query, can set parameter jpa way.


Comments

Post a Comment

Popular posts from this blog

design - Custom Styling Qt Quick Controls -

-
Image
i have custom design qt quick controls. example, change background colour of tool bar, since hate default design. how can that? in qt quick controls, there limited styling available via qt quick control styles items, buttonstyle , checkboxstyle , etc. at moment, other styles require delving qt sources , messing internal details. here complete example of how 1 might modify toolbar's style. main.qml import qtquick 2.1 import qtquick.layouts 1.0 import qtquick.controls 1.0 applicationwindow { toolbar: toolbar { id: toolbar component.oncompleted: toolbar.data[0].item.children = [newrectangle]; property item _newrectangle: rectangle { // rectangle within toolbarstyle's panel // gleaned from: // http://qt.gitorious.org/qt/qtquickcontrols/source/ // c304d741a27b5822a35d1fb83f8f5e65719907ce:src/styles/base/toolbarstyle.qml id: newrectangle anchors.fill: parent...
Read more

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more