| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204 |
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
- "http://www.springframework.org/dtd/spring-beans.dtd">
- <!-- <beans xmlns="http://www.springframework.org/schema/beans"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://www.springframework.org/schema/beans
- http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"> -->
- <beans>
- <bean id="dataSource"
- class="org.apache.commons.dbcp.BasicDataSource"
- destroy-method="close">
- <property name="driverClassName">
- <value>oracle.jdbc.driver.OracleDriver</value>
- </property>
- <property name="url">
- <value>jdbc:oracle:thin:@192.168.1.5:1521:corerdb</value><!-- jdbc:oracle:thin:@172.16.0.8:1521:SQMESDB -->
- </property>
- <property name="username">
- <value>core</value> <!--xg3q -->
- </property>
- <property name="password">
- <value>core</value> <!-- xg3q123 -->
- </property>
- <!-- 最大连接数据库连接数,设 0 为没有限制 -->
- <property name="maxActive">
- <value>100</value>
- </property>
- <!-- 最大等待连接中的数量,设 0 为没有限制 -->
- <property name="maxIdle">
- <value>20</value>
- </property>
- <!-- 最小等待连接中的数量 -->
- <property name="minIdle">
- <value>10</value>
- </property>
- <!-- 最大等待毫秒数, 单位为 ms, 超过时间会出错误信息 -->
- <property name="maxWait">
- <value>5000</value>
- </property>
- <!-- 最大等待连接中的数量,设 0 为没有限制 -->
- <property name="defaultAutoCommit">
- <value>true</value>
- </property>
- <!-- 回收被遗弃的(一般是忘了释放的)数据库连接到连接池中 -->
- <property name="removeAbandoned">
- <value>true</value>
- </property>
- <!-- 数据库连接过多长时间不用将被视为被遗弃而收回连接池中 -->
- <property name="removeAbandonedTimeout">
- <value>60</value>
- </property>
- <property name="logAbandoned">
- <value>true</value>
- </property>
- <property name="initialSize">
- <value>5</value>
- </property>
- </bean>
-
- <bean id="dataSource1"
- class="org.apache.commons.dbcp.BasicDataSource"
- destroy-method="close">
- <property name="driverClassName">
- <value>oracle.jdbc.driver.OracleDriver</value>
- </property>
- <property name="url">
- <value>jdbc:oracle:thin:@192.168.1.5:1521:orcl</value><!-- jdbc:oracle:thin:@172.16.0.8:1521:SQMESDB -->
- </property>
- <property name="username">
- <value>core</value> <!--xg3q -->
- </property>
- <property name="password">
- <value>core</value> <!-- xg3q123 -->
- </property>
- <!-- 最大连接数据库连接数,设 0 为没有限制 -->
- <property name="maxActive">
- <value>100</value>
- </property>
- <!-- 最大等待连接中的数量,设 0 为没有限制 -->
- <property name="maxIdle">
- <value>20</value>
- </property>
- <!-- 最小等待连接中的数量 -->
- <property name="minIdle">
- <value>10</value>
- </property>
- <!-- 最大等待毫秒数, 单位为 ms, 超过时间会出错误信息 -->
- <property name="maxWait">
- <value>5000</value>
- </property>
- <!-- 最大等待连接中的数量,设 0 为没有限制 -->
- <property name="defaultAutoCommit">
- <value>true</value>
- </property>
- <!-- 回收被遗弃的(一般是忘了释放的)数据库连接到连接池中 -->
- <property name="removeAbandoned">
- <value>true</value>
- </property>
- <!-- 数据库连接过多长时间不用将被视为被遗弃而收回连接池中 -->
- <property name="removeAbandonedTimeout">
- <value>60</value>
- </property>
- <property name="logAbandoned">
- <value>true</value>
- </property>
- <property name="initialSize">
- <value>5</value>
- </property>
- </bean>
- <bean id="jdbcTemplate"
- class="org.springframework.jdbc.core.JdbcTemplate">
- <property name="dataSource" ref="dataSource" />
- <!-- 设置抽取器 -->
- <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor" />
- </bean>
-
- <bean id="jdbcTemplate1"
- class="org.springframework.jdbc.core.JdbcTemplate">
- <property name="dataSource" ref="dataSource1" />
- <!-- 设置抽取器 -->
- <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor" />
- </bean>
-
- <bean id="nativeJdbcExtractor"
- class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"
- lazy-init="true" />
- <bean id="oracleLobHandler"
- class="org.springframework.jdbc.support.lob.OracleLobHandler"
- lazy-init="true">
- <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor" />
- <!-- ① 设置本地 Jdbc 对象抽取器 -->
- </bean>
- <bean id="KgDao" class="CoreFS.SA04.CoreDBProxy">
- <property name="jdbcTemplate" ref="jdbcTemplate" />
- <!-- ② 设置 LOB 处理器 -->
- <property name="lobHandler" ref="oracleLobHandler" />
- </bean>
-
- <bean id="coredao" class="CoreFS.SA04.CoreDBProxy">
- <property name="jdbcTemplate" ref="jdbcTemplate1" />
- <!-- ② 设置 LOB 处理器 -->
- <property name="lobHandler" ref="oracleLobHandler" />
- </bean>
- <!-- 实体类使用的Hibernate配置 -->
- <!-- Hibernate配置-->
- <bean id="sessionFactory"
- class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
- <property name="dataSource" ref="dataSource" />
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">
- org.hibernate.dialect.Oracle10gDialect
- </prop>
- <prop key="hibernate.default_batch_fetch_size">10</prop>
- <prop key="hibernate.max_fetch_depth">0</prop>
- <prop key="hibernate.show_sql">true</prop>
- </props>
- </property>
-
- <property name="mappingLocations">
- <list>
- <!-- <value>classpath:CoreBpm/Model/Hs_order_manager.hbm.xml</value>-->
-
- </list>
- </property>
- </bean>
- <bean id="transactionManager"
- class="org.springframework.orm.hibernate3.HibernateTransactionManager">
- <property name="sessionFactory" ref="sessionFactory" />
- </bean>
- <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
- <property name="sessionFactory">
- <ref bean="sessionFactory"/>
- </property>
- <property name="allowCreate">
- <value>true</value>
- </property>
- </bean>
-
- <bean id="baseDao" class="CoreBpm.Util.BaseDao">
- <property name="hibernateTemplate">
- <ref bean="hibernateTemplate"/>
- </property>
- </bean>
- <!-- 工作流配置 -->
- <!-- jBPM configuration -->
- <!-- <bean id="JbpmConfiguration"
- class="org.springmodules.workflow.jbpm31.LocalJbpmConfigurationFactoryBean">
- <property name="configuration" value="classpath:jbpm.cfg.xml" />
- <property name="createSchema" value="false" />
- <property name="sessionFactory">
- <ref local="sessionFactory"/>
- </property>
- </bean>
- -->
- <!-- jBPM template -->
- <!-- <bean id="JbpmTemplate"
- class="org.springmodules.workflow.jbpm31.JbpmTemplate">
- <constructor-arg index="0" ref="JbpmConfiguration" />
- </bean> -->
- </beans>
|