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>