sqlmapconfig总结
以前没有怎么用过IBATIS,用过后总结了一下。sqlmapconf文件的配置
?
<? xml version="1.0" encoding="UTF-8" ?>?
<! DOCTYPE sqlMapConfig??
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"??
"http://www.ibatis.com/dtd/sql-map-config-2.dtd" >?
< sqlMapConfig >?
?? < settings???
??? cacheModelsEnabled ="true"? <!--是否启用缓存机制-- >?
?? lazyLoadingEnabled="true"? <!-- 是否启用延迟加载机制 -->?
?? enhancementEnabled="true"? <!-- 是否启用字节码增强机制 -->?
?? errorTracingEnabled="true"? <!-- 是否启用错误处理机制 -->?
?? maxRequests="32"? <!-- 最大并发请求数 -->?
?? maxSessions="10"? <!-- 最大Session数 -->?
?? maxTransactions="5"? <!-- 最大并发事务数 -->?
?? useStatementNamespaces="true"/>? <!-- 是否启用名称空间 -->??
?</ sqlMapConfig >??
?
<sqlMapConfig>
? <settings cacheModelsEnabled="false"
???? enhancementEnabled="true"
???? lazyLoadingEnabled="false"
??? ?useStatementNamespaces="true"
???? statementCachingEnabled="true"
???? classInfoCacheEnabled="true"
???? maxSessions="1024"
???? maxTransactions="512"
???? maxRequests="5120" />
? <typeAlias alias="mapModel" type="org.platform.models.MapModel" />
? <typeAlias alias="mapResultModel" type="org.platform.models.MapResultModel" />
? <sqlMap resource="config/xyhoa/sqlmaps/oracle/wf/sqlmap-deployment.xml" />
? <sqlMap resource="config/xyhoa/sqlmaps/oracle/wf/sqlmap-tasks.xml" />
? <sqlMap resource="config/xyhoa/sqlmaps/oracle/wf/sqlmap-jbpm4_deployprop.xml" />
</sqlMapConfig>
?
Spring中配置管理
? <bean id="sqlMapClient_xyhoa"
??? ref="dataSource_xyhoa" />
? </bean>
? <bean id="xyhoaSqlMapDao" abstract="true"????? init-method="initialize">
??? <property name="dataSource">
????? <ref bean="dataSource_xyhoa" />
??? </property>
??? <property name="sqlMapClient">
????? <ref bean="sqlMapClient_xyhoa" />
??? </property>
??? <property name="sqlExecutor">
????? <ref bean="sqlExecutor" />
??? </property>
? </bean>
? 事务管理器
? <!-- Transaction manager for a single JDBC DataSource -->
? <bean id="transactionManager_xyhoa"
??? ref="dataSource_xyhoa" />
? </bean>
? <tx:advice id="xyhoaTxAdvice" transaction-manager="transactionManager_xyhoa">
??? <tx:attributes>
????? <tx:method name="insert*" propagation="REQUIRED" rollback-for="Exception"/>
????? <tx:method name="update*" propagation="REQUIRED" rollback-for="Exception"/>
????? <tx:method name="delete*" propagation="REQUIRED" rollback-for="Exception"/>
????? <tx:method name="select*" read-only="true"/>
??? </tx:attributes>
? </tx:advice>
? <aop:config proxy-target-expression="execution(* com.xyh.xyhoa.service*..*.*(..))" />
??? <aop:advisor advice-ref="xyhoaTxAdvice" pointcut-ref="xyhoaTx1" order="1" />
? </aop:config>