StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTwo session Factories found when one was expected
primarykey
Id
9764678
data
AcceptedAnswerId
9766749
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-03-19T03:32:15.033
FavoriteCount
0
LastActivityDate
2016-08-25T10:08:05.270
LastEditDate
2017-05-23T12:08:31.883
LastEditorUserId
-1
OwnerUserId
975882
ParentId
0
PostTypeId
1
Score
1
ViewCount
3751
LastEditorDisplayName
text
Body
I have referred to the question asked at <a href="https://stackoverflow.com/questions/5843953/hibernate-using-multiple-databases">Hibernate using multiple databases</a>. My problem is similar but I am facing a different problem.I created two xml file each has a separate datasource and session factory. In my web.xml I have <pre><code> <context-param> <param-name>contextConfigLocation</param-name> <param-value>*The xml files* </param-value> </code></pre> Once I run the project,the various loadings and the bindings are done from both the xml files.The various annotations and databases/tables are properly identified.But just after this is done before the control even goes outside.I get the following error. <pre><code> main ERROR [org.springframework.web.context.ContextLoader] - Context initialization failed org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'daoEager' defined in URL [jar:file:/C:/Users/.../.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/infobutton-service/WEB-INF/lib/core-data-1.0.0-SNAPSHOT.jar!/.../DaoHibernateEagerImpl.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [org.hibernate.SessionFactory]: : No unique bean of type [org.hibernate.SessionFactory] is defined: expected single matching bean but found 2: [sessionFactory, profilesessionFactory]; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No unique bean of type [org.hibernate.SessionFactory] is defined: expected single matching bean but found 2: [sessionFactory, profilesessionFactory] </code></pre> The class DaoHibernateEagerImpl is <pre><code>@Implementation @Repository("daoEager") public class DaoHibernateEagerImpl extends DaoHibernateImpl { // ========================= CONSTANTS ================================= /** * A logger that helps identify this class' printouts. */ private static final Logger log = getLogger(DaoHibernateEagerImpl.class); // ========================= CONSTRUCTORS ============================== /** * Required for a Spring DAO bean. * * @param sessionFactory * Hibernate session factory */ @Autowired public DaoHibernateEagerImpl(final SessionFactory sessionFactory) { super(sessionFactory); } // ========================= DEPENDENCIES ============================== // ========================= IMPLEMENTATION: Dao ======================= // ========================= IMPLEMENTATION: SearchEngine ============== } </code></pre> One of the xml files is <pre><code><?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:jaxws="http://cxf.apache.org/jaxws" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd"> <context:annotation-config />  <bean id="profiledataSource" class=".....ConfigurableBasicDataSource"> <constructor-arg index="0"> <bean class="org.apache.commons.dbcp.BasicDataSource" /> </constructor-arg> <property name="properties"> <bean class="org.springframework.beans.factory.config.PropertiesFactoryBean"> <property name="locations"> <list> <value>WEB-INF/datasource-local.properties </value> </list> </property> </bean> </property>  <property name="testOnBorrow" value="true" /> <property name="testWhileIdle" value="true" /> </bean>   <bean id="profilesessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="profiledataSource" />  <property name="hibernateProperties"> <bean class="org.springframework.beans.factory.config.PropertiesFactoryBean"> <property name="locations"> <list> <value>WEB-INF/hibernate.properties </value> <value>WEB-INF/datasource-local.properties </value> </list> </property> </bean> </property>  <property name="namingStrategy"> <bean class="org.hibernate.cfg.DefaultNamingStrategy" /> </property>  <property name="annotatedClasses"> <list> <value><![CDATA[....profiledb.domain.Profiles]]></value> </list> </property> </bean>  <bean id="profilehibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory" ref="profilesessionFactory" /> </bean> <tx:annotation-driven />  <bean id="profiletransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="profilesessionFactory" /> </bean> <bean id="profilesdbDao" class="....profiledb.service.ProfilesDaoImpl" > <property name="sessionFactory" ref="profilesessionFactory"></property> </code></pre> <pre><code><context:component-scan base-package="....core.data" /> </code></pre> The other xml file is similar but has a different datasource and the session factory is <pre><code><bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> ..... </code></pre>
Tags
<java><spring><hibernate>
Title
Two session Factories found when one was expected
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USicedek
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COPlease provide the bean definition xml and also the class which is listed in this exception (DaoHibernateEagerImpl), then only someone can help you.
 singulars
 PostPostId
 POTwo session Factories found when one was expected
 UserUserId
 USraddykrish
2. COI have added some more details as you suggested.
 singulars
 PostPostId
 POTwo session Factories found when one was expected
 UserUserId
 USicedek

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.