Hi all,

I would like to know if there is any solution to test mappings efficiency on a database, when the Hibernate configuration was built dynamically ?

I looked everywhere in documentation, api, google,forum,etc. and I tried some methods of the SessionFactory class, but none of them throws any Exception when running.

My aim is to provide to user an interface for configuring DBMS and database used by Hibernate (with multiple JDBC drivers). So the application checks the server availability with JDBC, and then configures Hibernate to connect to it and check if database is well-formed (i.e. mappings can work with it). If database is not initialized, then it uses the hbm2ddl tool to generate it directly.

I know this case is not standard, but I think it's quite interesting.

Thank you,
Fred.

look for schemavalidator which does some of this...but probably not complete - patches welcome

Thanks a lot max,

It seems to work very well :)
It's the same for dynamic database generation with hbm2ddl :)

Thank you again ;)

Avangel/max,
I am trying to validate my mapping files by writing a tag in cfg file:
<property name="hibernate.hbm2ddl.auto">validate</property>.

but when I run my testcase, I get below Exception:
Initial SessionFactory creation failed.org.hibernate.HibernateException: Wrong column type: C_NCVRD_CHRG_AMT, expected: double precision.

My maping file contains:


Is it the right way to run SchemaValidator? Do we have any other ways?
Thanks in advance

yes you are doing it correctly, but schemavalidator is not perfect.

Thanks Max,
Since schemavalidator is not perfect, please tell me how I can validate my hbm files with schema.

well - submit patches to schemaexport is a good step ;)

..note i've added an hbmlint to hibernatetools which validate the schema (and more). hbmlint is planned to be more extendable/fixable so try that out if you have the desire. (look in jira for hbmlint)