Lab Sql

I'm trying to access a MySQL database from a Java webservice. I'm using the NetBeans IDE an… Read more Netbeans Hql Editor Wrong Translation To Sql

List last = session.createQuery('from lahetys order by lahetysNro DESC LIMIT 1').list(); … Read more How To Get Last Record From Mysql Using Hibernate?

I want to create a new functionality to delete rows from a table programatically with a limit of ro… Read more Limit Delete Query With Hibernate

I'm working with Struts 2 and Hibernate and I'm getting this error : org.hibernate.hql.ast.… Read more Org.hibernate.hql.ast.querysyntaxexception: Unexpected Token

I have a pretty complex Join query to select few items from DB, and it doesn't involve any Upda… Read more How To Execute Normal Sql Query In Hibernate Without Hql?

derived from this question, is it possible to use HQL or Criteria for the following SQL statement: … Read more Case Statement In Hql Or Criteria