配置数据源
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/test</value>
<!--<value>java:comp/env/jdbc/*</value> -->
</property>
</bean>
创建数据源
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" dependency-check="none">
<property name="driverClass" value="net.sourceforge.jtds.jdbc.Driver" />
<property name="jdbcUrl" value="jdbc:jtds:sqlserver://localhost:1433/test" />
<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">sa</prop>
<prop key="password"></prop>
</props>
</property>
</bean>
注:
<value>java:comp/env/jdbc/test</value>
<property name="jdbcUrl" value="jdbc:jtds:sqlserver://localhost:1433/test" />
中test为数据库名
在Spring中配置JNDI数据源
最新推荐文章于 2021-11-09 00:21:06 发布