ibatis如何加载数据源
ibatis中有两种数据源加载方式,分别在sql-map-config.xml文件中配置如下:
1, 通过jndi方式加载数据源:
1. <transactionManager type="JDBC">
2. <dataSource type="JNDI">
3. <property name="DataSource" value="java:jdbc/cisa"/>
4. dataSource>
5.transactionManager>
其中:JNDI是web container中初始化的datasource 的jndi,也可以直接配置jdbc,如下:
1.<transactionManager type="JDBC">
2. <dataSource type="SIMPLE">
3. <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
4. <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@192.168.1.19:1521:boxer"/>
5. <property name="JDBC.Username" value="cisa"/>
6. <property name="JDBC.Password" value="admin"/>
7. <property name="Pool.MaximumActiveConnections" value="10"/>
8. <property name="Pool.MaximumIdleConnections" value="5"/>
9. <property name="Pool.MaximumCheckoutTime" value="120000"/>
10. <property name="Pool.TimeToWait" value="500"/>
11. <property name="Pool.PingQuery" value="select 1 from user"/>
12. <property name="Pool.PingEnabled" value="false"/>
13. <property name="Pool.PingConnectionsOlderThan" value="1"/>
14. <property name="Pool.PingConnectionsNotUsedFor" value="1"/>
15. dataSource>
16.transactionManager>
2,通过jdbc.properties文件加载datasource,等同与1中的第二中加载方式:
xml 代码
1.<properties resource="properties/database.properties"/>
2.<transactionManager type="JDBC">
1. <dataSource type="SIMPLE">
2. <property value="${driver}" name="JDBC.Driver"/>
3. <property value="${url}" name="JDBC.ConnectionURL"/>
4. <property value="${username}" name="JDBC.Username"/>
5. <property value="${password}" name="JDBC.Password"/>
6. dataSource>
7.transactionManager>
其中:database.properties是jdbc配置文件,内容如下:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/jpetstore
username=root
password=
3,ibatis缓存配置:
xml 代码
1.<settings
2. cacheModelsEnabled="true"
3. enhancementEnabled="true"
4. lazyLoadingEnabled="true"
5. errorTracingEnabled="true"
6. maxRequests="10"
7. maxSessions="5"
8. maxTransactions="3"
9. useStatementNamespaces="false"
10./>
<sqlmapconfig></sqlmapconfig>
