dataSource 가 허접할 때

SPRING_SETTING/기타

dataSource 가 허접할 때

우혁이 아빠 2012. 3. 13. 09:45

테스트 할때는 심플로

실제로는 아파치 껄로

<bean id="dataSource"
		class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="#{db['db.driverclassname']}" />
		<property name="url" value="#{db['db.url']}" />
		<property name="username" value="#{db['db.username']}" />
		<property name="password" value="#{db['db.password']}" />
		<property name="maxActive" value="100" />
		<property name="maxIdle" value="10" />
		<property name="maxWait" value="1000" />
		<property name="defaultAutoCommit" value="true" />
	</bean>

이것도 한번 C3P0

<bean id="dataSource"
		class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="org.hsqldb.jdbcDriver" />
		<property name="jdbcUrl" value="jdbc:hsqldb:hsql://localhost/test" />
		<property name="user" value="sa" />
		<property name="password" value="" />
		<property name="initialPoolSize" value="5" />
		<property name="minPoolSize" value="5" />
        <property name="maxPoolSize" value="20" />
        <property name="acquireIncrement" value="5" />
        <property name="acquireRetryAttempts" value="30" />
        <property name="acquireRetryDelay" value="1000" />
	</bean>

아님 JNDI

저작자표시