Hello,

I have amost 60 tables in the database, and many are interlinked to each other. I am using one table per class mapping.

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:

Hi,

All the files will be loaded on creation of the SessionFactory.
i.e) sessionFactory = new Configuration().configure().buildSessionFactory();

On the above block?

After starting the server, the first call to database will create the sessionfactory at that time itself, all xml files will be loaded please look into your log.

BottomLine: xml files are not loaded on session creation.