Hi,
i am placing my HibernateSessionFactory.java and my hibernate.cfg.xml
if u can figure out where i am wrong in dynamic configuration.
(right now trying static data, but not in hibernate.cfg.xml)
HibernateSessionFactory.java
-----------------------------------------------
package com;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
public class HibernateSessionFactory {
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
private HibernateSessionFactory() {
}
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
public static void rebuildSessionFactory() {
try {
//configuration.configure(configFile); //original and working
//********
dynamic code where there is a problem
Properties prop = new Properties();
prop.setProperty("hibernate.connection.username","root");
prop.setProperty("hibernate.connection.password","root");
prop.setProperty("hibernate.dialect","org.hibernate.dialect.MySQLDialect
");
prop.setProperty("hibernate.connection.pool_size","10");
prop.setProperty("connection.driver_class","com.mysql.jdbc.Driver");
prop.setProperty("connection.url","jdbc:mysql://localhost:3306/testdb");
prop.setProperty("hbm2ddl.auto", "update");
configuration.setProperties(prop);
configuration.addResource("Login.hbm.xml");
configuration.addResource("User.hbm.xml");
sessionFactory = configuration.buildSessionFactory();
//*********************
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.close();
}
}
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}
public static Configuration getConfiguration() {
return configuration;
}
}
and
Hibernate.cfg.xml (The working one - hardcoded sample)
-----------------------------
<?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">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="myeclipse.connection.profile">
cpvdbdemo
</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/testdb</property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="model/User.hbm.xml" />
<mapping resource="model/Login.hbm.xml" />
</session-factory>
</hibernate-configuration>
Login
FAQ
Search
