Hi.

Which is the fastest way to get the database time?
How to execute queries like "select getdate()" or "select systime from dual" in hibernate?

Tanks
markov


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

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I created my own "dual" table in hsql similar to Oracle's built in table.

Then I created this function (which uses Spring's HibernateDaoSupport, but you could get the session in another way):



This worked for me,

If you want to execute the SQL directly without trying some workaround in HQL, this is how to do it:

(Of course, you could abstract this into two functions, one private that accepts a sql string parameter and one public that calls the private. This would allow you to have multiple functions without rewriting the command and reader objects.)

I can't beleve that such a simple things cannot be realised in hibernate..
So how to map select getdate()??? Is there no simple way to get the time from different database types?

cheers
markov