Hi,

I'm working as an architect at a bank in the City. They are mainly a CICS/DB2 bank but my particular project is J2EE/Java and requires the use of an O/R mapping tool to talk to the DB2 database from within WebSphere.

My preferred solution is to use Hibernate. I've used O/R mapping technologies before (toplink, jdo, entity beans).

However, the bank has constraints in the use of generated SQL which almost disallow the use of Hibernate. Has anyone come across this problem before ?

One work-around is to write a set of unit tests that generate all the SQL and can be provided to the data architecture team to validate. I wonder if there are facilities within Hibernate that could assist here ?

enable debug logging for org.hibernate and you should get a list of all the static generated sql.