• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using multiple datasources in hibernate app

 
srija patel
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
In my application I will be using 3 different datasources.
How do I configure that ?
I'm trying to use
public SessionFactory createSessionFactory() {
Configuration config = new Configuration();
config.configure("hib.cfg.xml");
config.addResource("events/Event.hbm.xml");
return config.buildSessionFactory();
}




SessionFactory sessionFactory = createSessionFactory();
Session sess = sessionFactory.openSession();
Query query = sess.getNamedQuery("loadEvent");
List result = query.list();


But it is not working
 
srija patel
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My cfg file is like this
<?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>
<!-- Database connection settings -->
<property name="show_sql">true</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="connection.url">jdbc:mysql://localhost:3306/mysql</property>
<property name="connection.username">root</property>
<property name="connection.password">sess</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
<property
name="current_session_context_class">thread</property>
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>
<mapping resource="events/Event.hbm.xml"/>
</session-factory>
</hibernate-configuration>


hbm file
--------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="events.Event" table="EVENT">
<id name="id" column="EVENT_ID">
<generator class="native"/>
</id>
<property name="date" type="timestamp" column="EVENT_DATE"/>
<property name="title"/>
</class>
<query name="loadEvent">select ev from Event ev</query>
</hibernate-mapping>
 
abin awale
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
After you define (in cfg file):
<mapping resource="events/Event.hbm.xml"/>

Do you still have to define:
config.addResource("events/Event.hbm.xml"); ? in your java file.

If it still doesn't work, can you paste the error also. It might ease to answer.

Thanks,
Abin
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic