Hey, I've been trying to reverse engineer an oracle database and middlegen historically has broken while trying to convert it. I had to go in and turn the is_oracle flag to false in order to get the schema, but there is a host of PLSQL things that were left un-converted to hibernate. Does this mean hibernate itself does not support them? Or does it mean I just need to figure out the hibernate objects to interact with these features: (for example, SQL packages.)

what do you mean by PLSQL "things" - pretty hard to automatically map those I would say....

so yes, probably you need to do it yourself.

-max

In my post I provide SQL packages as an example. Does Middlegen map Hibernate well with PL/SQL packages or is this something I have to try to approximate by hand?

and as i said - probably need to do it your self...its not posible to map this automatically AFAIK.

The goal of the Oracle specific suuport was to deal with synomoms (sp?) primarily. The specialised support is not well tested. Remember Middlegen (and other tools similar) are using the JDBC data API so we are limited to what can be determined from the meta level features of the JDBC driver. Anything out of the usual (from a db stand point) would require some manual changes.