jdbc.dicon 2.79 KB
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE components PUBLIC "-//SEASAR2.1//DTD S2Container//EN"
	"http://www.seasar.org/dtd/components21.dtd">
<components namespace="jdbc">
	<include path="jta.dicon"/>
	<component 
		name="resultSetFactory"
		class="org.seasar.dao.pager.PagerResultSetFactoryWrapper">
		<arg>
			<component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/>
		</arg>
		<property name="useScrollCursor">true</property>
	</component>
	<!--
	<component 
		name="resultSetFactory"
		class="org.seasar.dao.pager.PagerResultSetFactoryLimitOffsetWrapper">
		<arg>
			<component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/>
		</arg>
		<arg>dataSource</arg>
	</component>
	-->

	<component class="org.seasar.extension.jdbc.impl.ConfigurableStatementFactory">
		<arg>
			<component class="org.seasar.dao.pager.PagerStatementFactory"/>
		</arg>
		<property name="fetchSize">100</property>
		<!--
		<property name="maxRows">100</property>
		-->
	</component>

	<!--
	<component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/>
	<component class="org.seasar.extension.jdbc.impl.ConfigurableStatementFactory">
		<arg>
			<component class="org.seasar.extension.jdbc.impl.BasicStatementFactory"/>
		</arg>
		<property name="fetchSize">100</property>
		<! - -
		<property name="maxRows">100</property>
		- - >
	</component>
	<component class="org.seasar.extension.jdbc.impl.OracleResultSetFactory"/>
	<component class="org.seasar.extension.jdbc.impl.BooleanToIntStatementFactory"/>
	-->

	<!-- for SQLServer -->
	<component name="xaDataSource"
		class="org.seasar.extension.dbcp.impl.XADataSourceImpl">
		<property name="driverClassName">
			<!--  "net.sourceforge.jtds.jdbc.Driver" -->
			"com.microsoft.sqlserver.jdbc.SQLServerDriver"
        </property>
        <property name="URL">
            "jdbc:sqlserver://10.175.3.205:1433;DatabaseName=ValueDesignSystem_DB;SendStringParametersAsUnicode=false"
        </property>
        <property name="user">"VD_User"</property>
        <property name="password">"jhad83&amp;1"</property>
    </component>

    <component name="connectionPool"
        class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl">
        <property name="timeout">36000</property>
        <property name="maxPoolSize">100</property>
        <!-- JTAトランザクションが開始されていない場合にコネクションを
             取得できないようにするには次のプロパティをfalseにしてください.-->
        <property name="allowLocalTx">true</property>
        <property name="validationQuery">"select 1"</property>
        <property name="validationInterval">30000</property> 
        <destroyMethod name="close"/>
    </component>
	<component name="dataSource"
		class="org.seasar.extension.dbcp.impl.DataSourceImpl"/>
	
</components>