Multiple LocalSessionFactoryBean does not work

Question

I have multiple data sources and the dynamic session mapping used to work fine when I used "org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" Now I have upgraded my application to hibernate 4 and started using "org.springframework.orm.hibernate4.LocalSessionFactoryBean". For some reason hibernate is not able to map the tables from my second data source.

Here are my configs.

<bean id="DataSource1" class="org.apache.commons.dbcp.BasicDataSource"
    autowire="byName" destroy-method="close">
    <property name="driverClassName" value="$api{d1.jdbc.driver}" />
    <property name="url" value="$api{d1.jdbc.url}" />
    <property name="username" value="$api{d1.jdbc.username}" />
    <property name="password" value="$api{d1.jdbc.password}" />
    <property name="maxActive" value="$api{dbcp.maxActive}" />
    <property name="maxWait" value="$api{dbcp.maxWait}" />
    <property name="minIdle" value="$api{dbcp.minIdle}" />
    <property name="maxIdle" value="$api{dbcp.maxIdle}" />
    <property name="validationQuery" value="$api{dbcp.validationQuery}" />
    <property name="testOnBorrow" value="true" />
</bean>
<bean id="d1SessionFactory"
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"
    autowire="byName">
    <property name="dataSource" ref="DataSource1" />
    <property name="annotatedClasses">
        <list>
            <value>com.class1</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
            <prop key="hibernate.show_sql">false</prop>
            <prop key="hibernate.hbm2ddl.auto">validate</prop>
            <prop key="hibernate.current_session_context_class">thread</prop>
            <prop key="hibernate.transaction.flush_before_completion">true</prop>
            <prop key="hibernate.transaction.auto_close_session">true</prop>

        </props>
    </property>
</bean>
<bean id="d1Dao" class="com.DaoImpl"
    autowire="byName">
    <property name="sessionFactory" ref="d1SessionFactory"></property>
</bean>

And the second session definition is

<bean id="DataSource2" class="org.apache.commons.dbcp.BasicDataSource"
    autowire="byName" destroy-method="close">
    <property name="driverClassName" value="$api{d1.jdbc.driver}" />
    <property name="url" value="$api{d1.jdbc.url}" />
    <property name="username" value="$api{d2.jdbc.username}" />
    <property name="password" value="$api{d2.jdbc.password}" />
    <property name="maxActive" value="$api{dbcp.maxActive}" />
    <property name="maxWait" value="$api{dbcp.maxWait}" />
    <property name="minIdle" value="$api{dbcp.minIdle}" />
    <property name="maxIdle" value="$api{dbcp.maxIdle}" />
    <property name="validationQuery" value="$api{dbcp.validationQuery}" />
    <property name="testOnBorrow" value="true" />
</bean>
<bean id="d2SessionFactory"
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"
    autowire="byName">
    <property name="dataSource" ref="DataSource2" />
    <property name="annotatedClasses">
        <list>
            <value>com.class2</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
            <prop key="hibernate.show_sql">false</prop>
            <prop key="hibernate.hbm2ddl.auto">validate</prop>
            <prop key="hibernate.current_session_context_class">thread</prop>
            <prop key="hibernate.transaction.flush_before_completion">true</prop>
            <prop key="hibernate.transaction.auto_close_session">true</prop>

        </props>
    </property>
</bean>
<bean id="d2Dao" class="com.DaoImpl"
    autowire="byName">
    <property name="sessionFactory" ref="d2SessionFactory"></property>
</bean>

At run time when I do

Session session = this.sessionFactory.openSession() ; 

The session always corresponds to d1SessionFactory even when dao is d2Dao. Not sure what am I doing wrong here. The same config worked fine when I was using "AnnotationSessionFactoryBean"

Help is appreciated.

The error I get is as follows

org.hibernate.hql.internal.ast.QuerySyntaxException: Class2 is not mapped [FROM Class2 WHERE user_id = :value0 AND active = :value1] at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180) at 
org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110) at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93) at 
org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:326) at 
org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3252) at 
org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3141) at 
org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:694) at 
org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:550) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:287) at 
org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:235) at 
org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248) at 
org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183) at 
org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) at 
org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at 
org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at 
org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:119) at 
org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:215) at 
org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:193) at 
org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1649)