TOMCAT6+SPRING+HIBERNATE JNDI 数据源配置

1、在context.xml中的context标签内加入以下代码:

 

<Resource name="jdbc/mysql" auth="Container"
type="javax.sql.DataSource"    driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/yourdbname"
username="root"

password="root"

maxActive="20"

maxIdle="10"/>

2、在web.xml中web-app下加入以下代码

 

    <resource-ref>
        <description>MySql DataSource</description>
        <res-ref-name>jdbc/yourdbname</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

3. 在SPRING的配置文件中加入如下代码

 

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

<value>java:comp/env/jdbc/yourdbname</value>

</property>
</bean>

4. 最后在你的SPRING配置文件中加入以下代码接管HIBERNATE的配置

 

<beans>
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mappingResources">
            <list>
              <value>这里是加载的HIBERNATE OR 文件</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">

org.hibernate.dialect.MySQLInnoDBDialect

 </prop>

  </props>

   </property>

</bean>

</beans>