dataSource 가 허접할 때

테스트 할때는 심플로
<!-- ============================ DataSource ============================ --> <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource"> <property name="driverClass" 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']}" /> </bean>

실제로는 아파치 껄로
<!-- ============================ DataSource ============================ --> <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> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="defaultAutoCommit" value="true"/> <property name="initialSize" value="5"/> <property name="maxActive" value="30"/> <property name="maxIdle" value="5"/> <property name="maxWait" value="30000"/> <property name="validationQuery" value="SELECT 1 FROM DUAL"/> <property name="testOnBorrow" value="true"/> <property name="testOnReturn" value="false"/> <property name="testWhileIdle" value="true"/> <property name="timeBetweenEvictionRunsMillis" value="60000"/> </bean>

이것도 한번 C3P0
<!-- ============================ DataSource ============================ --> <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> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="org.gjt.mm.mysql.Driver" /> <property name="jdbcUrl" value="jdbc:mysql://localhost/testdb" /> <property name="user" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="initialPoolSize" value="5" /> <property name="maxPoolSize" value="30" /> <property name="minPoolSize" value="5" /> <property name="acquireIncrement" value="3" /> <property name="acquireRetryAttempts" value="30" /> <property name="acquireRetryDelay" value="1000" /> <property name="idleConnectionTestPeriod" value="60" /> <property name="preferredTestQuery" value="SELECT 1" /> <property name="testConnectionOnCheckin" value="true" /> <property name="testConnectionOnCheckout" value="false" /> </bean>

아님 JNDI
<!-- ============================ DataSource ============================ --> <jee:jndi-lookup id="dataSource" jndi-name="jdbc/CjkpiDB" resource-ref="true" />