Spring配置连接池
来源:互联网 发布:windows任务管理工具 编辑:程序博客网 时间:2024/05/23 22:54
1 c3p0连接池
<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close" dependency-check="none">
<property name="driverClass"
value="com.MySQL.jdbc.Driver" />
<property name="jdbcUrl"
value="jdbc:mysql://10.3.6.76:3306/mjadc" />
<property name="properties">
<props>
<prop key="c3p0.minPoolSize">5</prop>
<prop key="hc3p0.maxPoolSize">10</prop>
<prop key="hc3p0.timeout">60</prop>
<prop key="c3p0.max_statement">50</prop>
<prop key="c3p0.testConnectionOnCheckout">true</prop>
<prop key="user">mobileadc</prop>
<prop key="password">mobileadc</prop>
</props>
</property>
</bean>
2jndi连接池
tomcat conf/context.xml配置
<Resource name="jdbc/mysql"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
password="mobileadc"
maxIdle="2"
maxWait="5000"
username="mobileadc"
url="jdbc:mysql://10.3.6.76:3306/mjadc"
maxActive="10"/>
jboss /jboss3/server/default/deploy/thirdgs-Oracle-ds.xml(是oracle的配置文件 是mysql的 thirdgs-mysql-ds.xml()
<local-tx-datasource>
<connection-url>jdbc:oracle:thin:@10.3.6.72:1521:TEST</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>lnadc</user-name>
<password>lnadc</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements>true</track-statements>
</local-tx-datasource>
spring配置
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>Java:comp/env/jdbc/mysql</value>
</property>
</bean>
3 proxoo连接池l
bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource" destroy-method="close">
<property name="driver" value="${hibernate.driverClass}" />
或者直接写成<property name="driver"> <value>com.mysql.jdbc.Driver</value></property>
<property name="driverUrl" value="${hibernate.jbdc.url}" />
<property name="user" value="${hibernate.jbdc.user}" />
<property name="password" value="${hibernate.jdbc.password}" />
<property name="alias" value="proxoolPool" />
<property name="houseKeepingSleepTime" value="30000" />
<property name="prototypeCount" value="20" />
<property name="maximumConnectionCount" value="${hibernate.jdbc.maxConn}" />
<property name="minimumConnectionCount" value="${hibernate.jdbc.minConn}" />
<property name="trace" value="true" />
<property name="verbose" value="true" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="schemaUpdate" value="${hibernate.schemaUpdate}" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.use_outer_join">true</prop>
<prop key="hibernate.jdbc.fetch_size">50</prop>
<prop key="hibernate.jdbc.use_streams_for_binary">true</prop>
<prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>
<prop key="hibernate.query.substitutions">true 1,false 0,yes 'Y',no 'N'</prop>
</props>
</property>
<property name="annotatedClasses">
<list>
<value>com.mysteel.entity.xxx</value>
</list>
</property>
</bean>
在默认通过myeclipse生成的配置里,spring使用的是apache的dbcp连接池
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://localhost:3306/mysql">
</property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
- spring配置连接池
- Spring 配置连接池
- Spring配置连接池
- spring配置连接池
- spring配置连接池
- Spring 连接池配置
- spring配置连接池
- Spring配置连接池
- Spring配置连接池
- spring配置连接池
- Spring配置连接池
- Spring配置连接池
- Spring配置连接池
- spring连接池配置
- Spring 配置proxool连接池
- Spring配置proxool连接池
- Struts+Spring+连接池 配置
- spring配置dbcp连接池
- Java 中的内部类
- Spring:HandlerInterceptor使用
- Codeforces 831 A Unimodal Array
- java集合--fail-fast总结(通过ArrayList来说明fail-fast的原理、解决办法)
- Hibernate3.x的各个jar包的用途
- Spring配置连接池
- office文件转pdf
- margin的感想
- 《数据结构(C语言版)》- 线性表
- java学习之interface
- MFC 右键连续弹出快捷菜单
- git关联阿里云服务项目配置开发
- 滚动相应效果——返回顶部
- ajax上传图片+FastDFS