请教一下ibatis配置链接池的问题 ibatis怎么配置连接池呀 不依赖容器的 就是不是JNDI的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc\:oracle\:thin\:@localhost\:1521\:orcl" /> <property name="username" value="xx" /> <property name="password" value="xx" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/promise/maps/User.xml" /> </mappers></configuration> 发一段配置文件:<bean id="dataSourceSl" name="dataSourceSl" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" > <property name="user" value="${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></property> <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> <property name="driverClass" value="${jdbc.driverClass}"></property> <property name="maxPoolSize" value="${jdbc.poolmax}"></property> <property name="minPoolSize" value="${jdbc.poolmin}"></property> <property name="initialPoolSize" value="${jdbc.poolinit}"></property> <property name="maxStatements" value="0"></property> <property name="maxStatementsPerConnection" value="0"></property> <property name="maxConnectionAge" value="${jdbc.connectionAgeMax}"></property> <property name="checkoutTimeout" value="${jdbc.timeOutCheck}"></property> <property name="testConnectionOnCheckout" value="${jdbc.testConnectionOnCheckout}"></property> <property name="preferredTestQuery" value="select 1 from dual"></property> <property name="maxIdleTime" value="${jdbc.idleTimeMax}"></property> <property name="maxAdministrativeTaskTime" value="${jdbc.adminTaskTimeMax}"></property> <property name="numHelperThreads" value="${jdbc.helperThreadsNum}"></property> <property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"></property> </bean> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSourceSl" /></bean><bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation"> <value>classpath:sql-map-config.xml</value> </property> <property name="mappingLocations"> <value>classpath*:/com/**/*-ibatis2.xml</value> </property> <property name="dataSource" ref="dataSourceSl"/> <property name="useTransactionAwareDataSource" value="true"></property> </bean> <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" useStatementNamespaces="true" /> <transactionManager type="JDBC" commitRequired="true"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> <!-- 测试 <property name="JDBC.ConnectionURL" value="jdbc:sqlserver://10.148.20.148:1433;databaseName=cloudserverlog" /> <property name="JDBC.Username" value="sa" /> <property name="JDBC.Password" value="wimaxci" /> --> <!-- 正式 --> <property name="JDBC.ConnectionURL" value="jdbc:sqlserver://10.71.1.156:1433;databaseName=cloudserverlog" /> <property name="JDBC.Username" value="sa" /> <property name="JDBC.Password" value="WiCi2010!" /> </dataSource> </transactionManager> <sqlMap resource="com/cs/web/sqlmap/Logger.xml" /> <sqlMap resource="com/cs/web/sqlmap/User.xml" /></sqlMapConfig>]这是我之前用的 这是mybatis吧 我还用着ibatis 哈哈、抱歉、这两天在学mybaits、粘贴错了这个你直接定义一个*.xml文件,写在里面就可以了。到时引用就找到这个路径嘛 网上搜索一下 感觉不是用xml配置的 自己查了一下 是不是设为dbcp就行 其他的不用管? 可能我问的不太明白 补充一下我自己写了个连接池实现 用的oracle的连接池 用的单例模式然后想整合到ibatis中 该怎么整合 Hibernate穿件数据库报错! EJB资料 ssh开发中的一个小错误 其实偶么有什么问题,就是刚注册想说冒个头认识下大家. javascript校验? hibernate如何实现两表的左连接 关于ANT里几个不问题看不懂,求指教 在WEBWORK下,对于访问每个应用的用户权限验证问题。。。 java控件的缩放问题,真诚求教! jbuilder7和weblogic6(sp2)没有装在一台机器,如何配置jbuilder7,在线等 HTML 框架内 加载 jsp 显示空白??? action跳转action怎么传值
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc\:oracle\:thin\:@localhost\:1521\:orcl" />
<property name="username" value="xx" />
<property name="password" value="xx" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/promise/maps/User.xml" />
</mappers>
</configuration>
<bean id="dataSourceSl" name="dataSourceSl"
class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" >
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="maxPoolSize" value="${jdbc.poolmax}"></property>
<property name="minPoolSize" value="${jdbc.poolmin}"></property>
<property name="initialPoolSize" value="${jdbc.poolinit}"></property>
<property name="maxStatements" value="0"></property>
<property name="maxStatementsPerConnection" value="0"></property>
<property name="maxConnectionAge" value="${jdbc.connectionAgeMax}"></property>
<property name="checkoutTimeout" value="${jdbc.timeOutCheck}"></property>
<property name="testConnectionOnCheckout" value="${jdbc.testConnectionOnCheckout}"></property>
<property name="preferredTestQuery" value="select 1 from dual"></property>
<property name="maxIdleTime" value="${jdbc.idleTimeMax}"></property>
<property name="maxAdministrativeTaskTime" value="${jdbc.adminTaskTimeMax}"></property>
<property name="numHelperThreads" value="${jdbc.helperThreadsNum}"></property>
<property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"></property>
</bean>
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSourceSl" />
</bean><bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>classpath:sql-map-config.xml</value>
</property>
<property name="mappingLocations">
<value>classpath*:/com/**/*-ibatis2.xml</value>
</property>
<property name="dataSource" ref="dataSourceSl"/>
<property name="useTransactionAwareDataSource" value="true"></property>
</bean>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" useStatementNamespaces="true" />
<transactionManager type="JDBC" commitRequired="true">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<!-- 测试
<property name="JDBC.ConnectionURL"
value="jdbc:sqlserver://10.148.20.148:1433;databaseName=cloudserverlog" />
<property name="JDBC.Username" value="sa" />
<property name="JDBC.Password" value="wimaxci" />
-->
<!-- 正式 -->
<property name="JDBC.ConnectionURL" value="jdbc:sqlserver://10.71.1.156:1433;databaseName=cloudserverlog" />
<property name="JDBC.Username" value="sa" />
<property name="JDBC.Password" value="WiCi2010!" />
</dataSource>
</transactionManager>
<sqlMap resource="com/cs/web/sqlmap/Logger.xml" />
<sqlMap resource="com/cs/web/sqlmap/User.xml" />
</sqlMapConfig>
]
这是我之前用的