Interfacing with Unidata - advice wanted

agillett · **Joined:** Mon Oct 06, 2003 1:01 am **Posts:** 2

Hi,

I need to access some legacy data in a UniData 7.1 database. So far I've got the JDBC driver going and now I'd like to get some ORM happening.

I've begun by writing a trivial Dialect class but this fails on the simplest query because the UniData SQL does not support column aliases.

An example of the SQL generated by Hibernate for a simple query is:

Code:

select this_.CODE as CODE0_0_, this_.DESCR as DESCR0_0_ from GF_COUNTRY_NF_SUB this_;
[i]syntax error[/i]

However if I remove the "as ..." clauses and submit the SQL directly, then it executes without error:

Code:

select this_.CODE, this_.DESCR from GF_COUNTRY_NF_SUB this_;

So, is this a lost cause? Is there any way to "dumb down" the SQL that hibernate generates so as to accomodate the limited syntax supported by UniData?

Andrew.

kgignatyev · **Posted:** Mon Nov 21, 2005 1:24 pm

You may try support for named SQL queries if all you need is to retrieve the data
http://www.hibernate.org/hib_docs/v3/re ... medqueries

For full CRUD operations you may need to look at iBatis
http://ibatis.apache.org/