项目数据库管理基于myabatis框架,应用容器使用tomcat8.5版本,生产上使用JNDI数据源配置:
1.tomcat需要配置的信息,修改tomcat的conf目录下的配置文件context.xml和server.xml,增加以下配置信息:
- 1) context.xml文件在<Context></Context>里增加属性:
<ResourceLink name="jndi_demo" global="jdbc/jndi_demo" type="javax.sql.DataSource"/>
- 2) server.xml文件在<GlobalNamingResources></GlobalNamingResources>里增加属性:
<Resource auth="Container"
description="DB Connection"
driverClass="oracle.jdbc.driver.OracleDriver"
maxPoolSize="20"
minPoolSize="5"
acquireIncrement="5"
maxIdleTime="300"
idleConnectionTestPeriod="60"
preferredTestQuery="select 1 from dual"
acquireRetryAttempts="30"
breakAfterAcquireFailure="true"
name="jdbc/jndi_demo"
user="admin123"
password="123456"
factory="org.apache.naming.factory.BeanFactory"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
jdbcUrl="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.218)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))" />
- 3)数据源使用了c3p0连接池,因此tomcat的lib目录下还需要导入依赖jar包:c3p0-0.9.1.1.jar和ojdbc14.jar
2.mybatis的sqlMapConfig.xml配置文件<sqlMapConfig></sqlMapConfig>里增加属性:
<transactionManager type="JDBC">
<dataSource type="JNDI">
<property name="DataSource" value="java:comp/env/jndi_demo" />
</dataSource>
</transactionManager>