Hi,
I have requirement of working with different configuration files for my application (i.e. one cfg for MySQL, another for Oracle, another for MS-SQL Server,...etc). But picking of cfg file needs to be done during run time (means no hard coding for xxxx.cfg.xml names for each configuration and file name picked as files added to the classpath). I have spring support for working with hibernate.

Any suggestion please...

Many thanks
Gayath

You can instantiate more than one Configuration objects which in turn can refer to different cfg.xml files.

SessionFactory sf1 = new Configuration().configure(getConfigFile()).buildSessionFactory();

where getConfigFile() will return the appropriate file based on some logic.

Thanks keliveli... I'll try this option.