Hibernate Tool problem with Oracle 9i

Musicolo · **Posted:** Mon Jan 31, 2005 8:13 am

Hi everyone, I'm trying to use Hibernate 3 beta2. I've read lots of documentation about it from many URLs (and mainly from Hibernate Website). I write all of you as my last chance to solve the problem I have regarding Hibernate Tools. I have an Oracle9i Enterprise Edition Release 9.2.0.1.0 database and I would like to use Hibernate 3 on it. Thus, I've downloaded Hibernate Tools alpha1 for Hibernate 3.0. Besides, I've read and complied all requirements (Eclipse 3.1M14 and JBoss IDE 1.4.x, in my case 1.4.1, everything installed from scratch). By following all steps indicated in the documentation and the Flash format example, I've tried to generate my database corresponding java sources. Although I've achived to finished successfully the two initial steps, I haven't been able to generate the last step. I have tried many times and from many schemas on the same database. As you can see below, it always generates the same error it doesn't matter what schema I use. Thus, can somebody give me any clue about why is this happening?

I'm aware Hibernate tools isn't a final realise and it must be refined in the future. However, it would be really helpfull if you could provide me some information of why this error happens. I would also appreciate you reply as soon as possible, since time really counts in my company .

If you need any addicional data, please do not hesitate to contact me. I'm looking forward to hearing from you.

Thanks for everything in advance.

PS. Sorry, if my English isn't as perfect as I would like to.

max · **Posted:** Mon Jan 31, 2005 8:39 am

This is probably caused by the fact our rev.eng. tool gets information about *all* your tables in the database - and somehow oracle is reporting the same column twice (or we have a bug in jdbcbinder ,)

But i think you can solve your issue by simple specifying which schema you will be using in hibernate.cfg.xml (hibernate.default_schema).

This will make JDBCBinder only pick up the tables for this schema - thus avoiding these more or less weird system table/columns)

Musicolo · **Posted:** Mon Jan 31, 2005 9:08 am

Thanks! It worked perfectly as you said! :)