Reverse engineering Oracle database using Hibernate Tools in Eclipse
The best solution I came across was described in this tutorial:
How to Generate HBM (Hibernate Mapping) files and POJO (Model) Classes in Eclipse.
It worked fine. What I was doing wrong was to use the schema name in lower-case. It must be in upper-case.