Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Hibernate using multiple databases
- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <property name="driverClassName">
- <value>com.mysql.jdbc.Driver</value>
- </property>
- <property name="url" value="jdbc:mysql://localhost/personal"/>
- <property name="username" value="root"/>
- <property name="password" value="mysql"/>
- </bean>
- <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
- <property name="dataSource">
- <ref local="dataSource"/>
- </property>
- <property name="packagesToScan">
- <list>
- <value>com.app.personal.model</value>
- </list>
- </property>
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
- <prop key="hibernate.show_sql">false</prop>
- </props>
- </property>
- </bean>
- <tx:annotation-driven/>
- <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory">
- <ref local="sessionFactory"/>
- </property>
- </bean>
- @Repository
- public class ModuloDAOHibernate extends HibernateTemplate implements ModuloDAO {
- @Autowired
- public ModuloDAOHibernate(SessionFactory sessionFactory) {
- super(sessionFactory);
- }
- public List<Modulo> getAllGrupoModuloDAO() {
- Criteria criteriaList = this.getSession().createCriteria(Modulo.class);
- criteriaList.addOrder(Order.asc("orden"));
- return criteriaList.list();
- }
- <bean id="dataSource1" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <!-- ... -->
- </bean>
- <bean id="sessionFactory1" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
- <property name="dataSource" ref="dataSource1"/>
- <!-- ... -->
- </bean>
- <bean id="transactionManager1" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactory1"/>
- <!-- ... -->
- </bean>
- <bean id="dataSource2" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <!-- ... -->
- </bean>
- <bean id="sessionFactory2" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
- <property name="dataSource" ref="dataSource2"/>
- <!-- ... -->
- </bean>
- <bean id="transactionManager2" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactory2"/>
- <!-- ... -->
- </bean>
- <tx:annotation-driven transaction-manager="transactionManager1"/>
- <bean id="courseDAO" class="com.app.CourseDAOHibernate">
- <property name="sessionFactory" ref="sessionFactory2"/>
- </bean>
- @Autowired
- public ProgramaSgteDAOHibernate(@Qualifier("sessionFactory3") SessionFactory sessionFactory) {
- super(sessionFactory);
- }
- Configuration config = new Configuration().configure("<complete path to your cfg.xml file>");
- SessionFactory sessionFactory = config.buildSessionFactory();
- Session session = sessionFactory.getCurrentSession();
- session.beginTransaction();
Add Comment
Please, Sign In to add comment