Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.2.5

Mapping documents:

Code between sessionFactory.openSession() and session.close():
sessionFactory.getCurrentSession().beginTransaction();
System.out.println(""+sessionFactory.getCurrentSession().createQuery("select NOW() from Quest q").uniqueResult());


Full stack trace of any exception that occurs: getting null value

Name and version of the database you are using: hsqldb 1.8.0.7 for Unit testing and MYSQL for Production

The generated SQL (show_sql=true): Hibernate: select now() as col_0_0_ from Quest quest0_

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

This is the tools forum you might get more answers in the user forum - having said that I did a quick look and the docs recommend CURRENT_TIMESTAMP() instead of NOW() . Not sure what this really means as I do not use that database. Also, check the dialect to make sure it is aware of the now() function and is returning the correct type.

Thanks for your response