Hi all,

We are developing a multi-client (/server) application.
For some reasons we need to have the current date&time on the client side, unfortenately client machines may not be synchronized. As a consequence we are using the database server clock.

Before starting with hibernate, we used to issue queries like:
(Oracle)

(DB2)


Like you know it's database dependant, and then I would like to know what is the most elegant way of implementing this using hibernate.

I know that in some cases, hibernate isn't the right answer and the direct jdbc is the best... but what is your opinion?

I forget to say that we don't store this current date&time (at least not always), but use it for processing on the client machine.

Thanks.
Johann

Hi.

I think, that you create two named query, and use the Dialect.getDialect(), to know which dialect you're using, and according to the Dialect you execute the correct one.

didn't check it, hope it's right.

Jus.

You could go for a 'fix' in the database. Create a view that does the query for you. The view could also format the date/time in a consistent way, so if you change databases, your Java/Hibernate code would never know the difference.[/b]

didn't think about that. great idea.

Jus.

Nice, it could be really easy if there is a way to access this values from the sessionfactory ... i will have a look where it's possible to add this feature at the sessionfactory level.




Could be a solution, but if the view is designed to send back a java.sql.Timestamp, it (java/hibernate mapping) would never change from a database to another.

Thank you for your help.