Hi,

I currently using CMP and JDBC together, I use CMP is when I need to define relationship between whole and parts (ex: Student and Course), and JDBC when I want to just associate between objects (ex: Library and Student).
Mostly I use JDBC to generate report, so I can easily join multiple tables which may not be closely related, but I need to present as much information as possible in the report, and the good thing is sometime all these information can be retrieved with just 1 query.

I have not read all the documentation extensively but from what I read on some examples, Hibernate is a good replacement of CMP, but probably cannot solve the problem that caused me to use JDBC, I hope someone can show me to use Hibernate to solve that problem, so in the future I can use Hibernate only. Thanks in advance.

Best Regards,
Iwan

Reporting is easy to do in HQL, it has most of the features of SQL.