我想要插入很多的数据到表里,就要执行多次insert ,可是执行一次数据源就会关闭,下一次再打开,执行sql语句再关闭,怎么办,我想要打开后把insert全都执行完再去close
我是用的spring+mybatis配置的
<!-- 目换数据源定义 -->
<bean id="dsto" class="gpsData.transform.dao.DataSourceManage" >
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property> <property name="url">
<value>jdbc:MYSQL://{toip}:3306/mygps?characterEncoding=gbk</value>
</property>
<property name="username">
<value>db2admin</value>
</property>
<property name="password">
<value>gisshyb</value>
</property> </bean>
<bean id="tto" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dsto"/>
</bean> <bean id="sqlsessionTo" class="org.mybatis.spring.SqlSessionFactoryBean" >
<property name="mapperLocations" value="classpath:gpsData/transform/dao/GpsDao.xml" ></property>
<property name="dataSource" ref="dsto"/> </bean>
我是用的spring+mybatis配置的
<!-- 目换数据源定义 -->
<bean id="dsto" class="gpsData.transform.dao.DataSourceManage" >
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property> <property name="url">
<value>jdbc:MYSQL://{toip}:3306/mygps?characterEncoding=gbk</value>
</property>
<property name="username">
<value>db2admin</value>
</property>
<property name="password">
<value>gisshyb</value>
</property> </bean>
<bean id="tto" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dsto"/>
</bean> <bean id="sqlsessionTo" class="org.mybatis.spring.SqlSessionFactoryBean" >
<property name="mapperLocations" value="classpath:gpsData/transform/dao/GpsDao.xml" ></property>
<property name="dataSource" ref="dsto"/> </bean>
<property name="driverClass">
<value>com.mysql.jdbc.Driver</value>
</property> <property name="jdbcUrl">
<value>jdbc:MYSQL://127.0.0.1:3306/MYGPS?characterEncoding=utf8</value>
</property>
<property name="user">
<value>db2admin</value>
</property>
<property name="password">
<value>gisshyb</value>
</property>
<property name="autoCommitOnClose" value="true"/>
<property name="checkoutTimeout" value="5000"/>
<property name="initialPoolSize" value="10"/>
<property name="minPoolSize" value="0"/>
<property name="maxPoolSize" value="1"/>
<property name="maxIdleTime" value="7200"/>
<property name="acquireIncrement" value="10"/>
<property name="maxIdleTimeExcessConnections" value="1800"/>
也还是那样呢,但我感觉可能真的是连接池的问题