Hello,

I have amost 60 tables in the database, and many are interlinked to each other.

Right now I am using the following approach: I have all my mapping resources(60 xml files ) listed in the hibernate.cfg.xml file.

---------------HIbernate.cfg.xml ----------------
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="foo">
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@10.25.31.73:1521:DBMSN</property>
<property name="hibernate.connection.username">qa</property>
<property name="hibernate.default_schema">DBMS</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.show_sql">true</property>
<mapping resource="VsDomainWorkflowRef.hbm.xml" />
<mapping resource="VsRequestFieldT.hbm.xml" />
<mapping resource="VsSystemConfigurationT.hbm.xml" />
<mapping resource="VsBrandCountryMapT.hbm.xml" />
<mapping resource="VsDbmsResourcesRef.hbm.xml" /> and so on ......
.
Also I am using a ThreadLocal logic for session management.
-----------
public class HibernateUtil {

private static final SessionFactory sessionFactory;

static {
sessionFactory = new Configuration().configure().buildSessionFactory();
}

public static final ThreadLocal session = new ThreadLocal();

public static Session currentSession() throws HibernateException {
Session s = (Session) session.get();
if (s == null) {
s = sessionFactory.openSession();
session.set(s);
}
return s;
}

public static void closeSession() throws HibernateException {
Session s = (Session) session.get();
session.set(null);
if (s != null)
s.close();
}
}

---------------
The advantage of including all the xml files in the hibernate.cfg.xml is that I dont have to do a addClass(..) for each time I want to do a query.

But is there any performance related issue associated with it ?
Are all the classes listed in the configuartion file(hibernate.cfg.xml) be loaded every time a session is created ?

Please let me know

Thanks
Shobhana

Thanks
Shobhana

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

no there is no such performance realated issue creating a session from session factory once session factory is build .