jndi 数据连接

最新推荐文章于 2024-02-02 12:08:00 发布

原创最新推荐文章于 2024-02-02 12:08:00 发布 · 248 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了如何在Tomcat环境下配置数据库驱动、创建内容XML文件、整合Spring框架与MySQL数据库，包括数据源配置、JNDI绑定、Hibernate配置等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.将数据库驱动jar 放到 tomcat / lib 下。

2.MET-INF 下新建 content.xml 文件。

<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/timesshDB"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="false"
validationQuery="SELECT 1"
validationInterval="30000"
timeBetweenEvictionRunsMillis="30000"
maxActive="100"
minIdle="10"
maxWait="10000"
initialSize="10"
removeAbandonedTimeout="60"
removeAbandoned="true"
logAbandoned="true"
minEvictableIdleTimeMillis="30000"
jmxEnabled="true"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="root"
password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://192.168.101.231:3306/timessh?autoReconnect=true&autoReconnectForPools=true&failOverReadOnly=false&useUnicode=true&characterEncoding=utf-8"/>
</Context>

3 spring.xml 配置文件中：

<bean id="dataSourceTimessh" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/timesshDB" />
</bean>

<bean id="sessionFactoryTimessh"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSourceTimessh" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>


<prop key="hibernate.show_sql">false</prop>

<prop key="hibernate.jdbc.batch_size">10</prop>
<prop key="hibernate.query.factory_class">
org.hibernate.hql.ast.ASTQueryTranslatorFactory
</prop>
</props>
</property>
<property name="packagesToScan">
<list>
<value>com.experience.common.db.po.timesshdb</value>
</list>
</property>
</bean>