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

I am using oracle 10g and hibernate 3.3.2. I have used regular expression in sql before, now for th… Read more How To Use Oracle's Regexp_like In Hibernate Hql?

I'm trying to see the value of a calculated value in hive. For example, I'm trying to get t… Read more How To View The Calculated Value Of A Hive Variable