Hi:

I am a Java Software Engineer with a company in California. My employer is using multiple DBMS (Oracle, MS SQL Server and MySQL) and for each DBMS, we have two separate scripts: (1) to create schema for database tables and (2) for inserting data into these tables.

Now my manager has decided to also port the web application we are developing into DB2 RDBMS. At the same time, he wants to automate the generation of schemas for database tables and views so that we do not have to maintain a separate script for each DBMS. So he has asked me to look into this.

I find that the Ant tools supplied with Hibernate utility are very useful for database vendor-independent schema generation of database tables. But I do not see in the Hibernate documentation any tips for generating views out of database tables.

So can you please tell me whether Hibernate can also be used to generate database table views automatically and if it can be used for this task, what I need to do to implement this task?

Thanks,

Kalpana

no - hibernate only creates tables.

the mappings does not contain enough information to create views.