Converting normal sql query into hibernate criteria query -

-

i need convert sql query hibernate criteria,please guys.

select name, count(*) app
device group name order app desc limit 3

try code:

select device.name, count(device) device device group device.name order count(device) desc

this assumes have entity class called device field name along getter method getname(). may have change query depending on actual code (which never showed us).

the limit clause had not applicable hql. instead, should doing query.setmaxresults().


Comments

Post a Comment

Popular posts from this blog

amazon web services - S3 and apache mod_proxy with basic authentication -

-
i'd redirect s3 bucket in ssl basic authentication of files (apk files) apache mod_proxy. ssl , mod_proxy work, basic authentication ignored. <virtualhost *:443> servername resources.mydomain.jp <filesmatch "\.apk$"> order deny,allow setenvif user-agent ".*android.*" allow_ag options followsymlinks allow env=allow_ag deny authtype basic authname "secret zone" authuserfile /etc/httpd/.htpasswd require user xxx_customer </filesmatch> sslengine on sslproxyengine on sslprotocol -all +sslv3 +tlsv1 sslciphersuite all:!adh:rc4+rsa:+high:+medium:-low:-sslv2:-exp sslcertificatefile conf.d/xxx.cer sslcertificatekeyfile conf.d/xxx.key sslcacertificatefile conf.d/xxx.cer proxypass / http://resources.mydomain.jp.s3-website-ap-zone-1.amazonaws.com/ proxypa...
Read more

How to install ruby on rails -

-
i newbie ruby on rails, here trying install ruby on rails on windows 7 64 bit. installed ruby installer , installed rails. , created new app files. when start rails server showing following errors. how can rid of these errors , start developing ruby application? c:\users\walnut\desktop > bundle install fetching gem metadata https://rubygems.org/............ fetching version metadata https://rubygems.org/... fetching dependency metadata https://rubygems.org/.. resolving dependencies................. using rake 10.4.2 using i18n 0.7.0 installing json 1.8.3 native extensions gem::installerror: 'json' native gem requires installed build tools. please update path include build tools or download devkit 'http://rubyinstaller.org/downloads' , follow instructions @ 'http://github.com/oneclick/rubyinstaller/wiki/development-kit' error occurred while installing json (1.8.3), , bundler cannot continue. make sure `gem install json -v '1.8.3'` succeeds be...
Read more

powershell - This solution contains one or more assemblies targeted for the global assembly cache -

-
Image
i having sharepoint site deployed through sharepoint powershell. wsp build through visual studio 2013. all projects in solution not signed assemblies(project->right click->properties->signing->sign assemblies check box unchecked). taking wsp of solution publishing , deploying sharepoint using sharepoint powershell. when try this, getting following error: when googled solution. many of them suggesting check 'sign assemblies' check box. don't want do, because facing other issues packages install through nugget. sign libraries of solution go properties of project click signing tab , check sign libraries options , create new strong name file or without password , rebuild , deploy.
Read more