spring应用程序weblogic jndi数据源问题

Question

我在weblogic中创建了一个名为jdbc/myds的oracle数据源。

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName" value="jdbc/myDS"/>
</bean>

<bean id="sessionFactory"
    class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="hibernateProperties">
        <util:map>
            <entry key="hibernate.hbm2ddl.auto" value="update" />
            <entry key="hibernate.show_sql" value="true" />
        </util:map>
    </property>
</bean>

<bean id="myDAO" class ="com.example.MyDAOImpl">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>

public class MyDAOImpl implements MyDAO{

private SessionFactory sessionFactory;

public void setSessionFactory(SessionFactory sessionFactory){
    this.sessionFactory = sessionFactory;
}

public SessionFactory getSessionFactory() {
    return sessionFactory;
}

public void persistPerson(Person  person) {
    Session session = getSessionFactory().openSession();

    try {

    session.beginTransaction();

    session.save(person);

    session.getTransaction().commit();

    }catch(HibernateException he) {

        he.printStackTrace();
    } finally {
         session.close();
    } 
}
}

Answer 1

下面提供了一个Spring XML配置，通过JNDI名称获取数据源，并将其注入SpringAnnotationSessionFactoryBean。

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName" value="jdbc/YourJndi"/>
</bean> 


<bean id="sessionFactory"
    class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource">
        <ref bean="dataSource" />
    </property>
    <property name="annotatedClasses">
        <list>
            <value>com.java.model.Employee</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">${hibernate.dialect}</prop>
            <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
            <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>             
        </props>
    </property>
</bean>

这个例子已经在WebLogic10.3.4和Oracle11g上进行了成功的测试。