Has anyone yet used any code generation tool on an oracle 10g instance?

I used the 10.0.1.4 driver but any tool showed different symptoms:

Middlegen could not read constraints, did not realise any PK's ...
Hiberclipse as well.
HibernateIDE got nothing the connection was anytime closed.


Any experiences?

Thanks
Tarik

yes i use(d) oracle 10g to develop it on so i know it works ,)

did you remember to set the default schema so it wont take the whole db ?
also remember that the user you login with need enough rights to read the metadata.

Hi Max, thanks a lot for verifying. It was just I did not want to believe that the DDL was set up differently than what I and middlegen guessed :-) Additionally 10g is pretty new to our company and so I was a beta tester somehow.

Well the issue was that, as I understood the schema was sketched in MS Access, well not the best tool I guess, and feeded somehow to Oracle 10g (me no DBA). During that migration Oracle somehow did, or most possibly could not define the PK. Middlegen was not able to do that as well ... all against me .-)

The DBA was so nice and ran my test-environment and figured it out.

Just to tell you the end of the story, I got my hbm's and ran hbm2java, failed. I tried HibernateTools, Hiberclipse and something else, they could not generate the sources (hibernate3 lib'ed). So I went back to hibernate2 to generate the sources and now I am happy, running on on hibernate 3 :-)

Till then
Tarik

Just to mention that I could not download the latest CVS tree. Is there something I perceived wrong?- is the HibernateTask to do the hbm->java task defined in the latest binary? I could not find it in the binaries.