Hi,

I need to port an application from oracle to multiple datbases support (mssql, db2, oracle as the first goal).

The application does not need an OR mapping. It uses SQL which are a little bit more complex than standard SQL (e.g. oracles NVL).

For instance, I want to write one SQL like

select 'some con' || 'cat string', coalesce('its null', somevalue), current_timestamp() from mytable order by someothervalue

Can I use hibernate dialect implementation to translate that into different SQL dialects?

I know hibernate is ment to be an OR mapping. I found SwisSQL which does this job, but its very expensive.


thanks,
michael

pretty much all you describe in that query can be achieved in Hibernate.
Hibernate HQL does have current_time functions, coalesce and concat.

OK. I find some things out now. But I''m still not sure...


My current HQL query is
select coalesce('its null', somevalue), current_timestamp() from IdObject order by someothervalue

In my hibernate configuration I can switch the Dialict and it works.

But:
- I need an "dummy object" with an mapping (here: IdObject) for each table I query. The class IdObject has only an String id with a getter and setter method and the mapping file. Can I avoid this without getting a "Table (object) XXX is not mapped" exception if I query an unknown table?

- I don't need the current_timestamp, I need somethink like oracle's "to_date" function. I need to create a db date value out of a string (e.g. to_date('2007-01-12 10:23:11', 'YYYY-MM-DD hh24:mm:ss'). I could not find an HQL function for that jet.


thanks,
Michi