Hello,

I am using hbm2ddl tool for generating "create schema" script for production system which will work with huge amount of data. I am solving a performance problem now. I can improve the performance by using of some Oracle specific DDL statements in create script but I have not found an easy way how to generate Oracle specific DDL with hbm2ddl (or another tool).

For example I need to generate indices on foreign keys or I want to determine in which tablespace should be given table added.

I realize that the metadata desciption tools (annotations or XML mapping files) have to be generic but I speculate if there can be some possibility to append some piece of vendor-specific DDL to generated DDL.

This problem can be also solved using another approach - using another anotation-processing tool which will have its own set of annotations allowing generation of Oracle specific DDL.

I have not found suitable tool or some "best practice" how to do that so I am asking this question before I start to implement some utility which will allow doing this by hand.

I know that my question is quite generic, but I will be grateful for every hint or experience in solving above mentioned problems.

Thank you.

I hope you are using the right dialect. The dialect that u use will make your DDL specific to the vendor you want. For Oracle there is OracleDialect as well Oracle9iDialect. For MySQl it is the MySQLDialect. You can read the documentation for all the dialects supported. You can also extend and an existing dialect as customize them as per your need and then use that dialect to generate your DDLs from your mapping files using hbm2ddl hibernate tool

But no...we don't have a good way of adding propritary elements to the output.

Sukirtha and max, thank you for your answers. Extension of dialect sounds very attractive but I think that this approach will have to solve (as well as other approaches using standard Hibernate tools) the lack of metadata information in generic annotations (or mapping files).

For now I am thinking about using hbm2ddl for generation of standard DDL create script and after that it will be necessary to use some tool which will add some specific DDL clauses into this script. This clauses will be generated on the basis of vendor-specific annotations (which will be defined for this purpose by hand).

But all of this will depend on costs for development of such tool.