spring3 + hibernate3配置weblogic数据源的问题

荷梅月剑 2013-07-05 04:36:19

原来使用的是c3p0连接池，jdbc直连
现在想改成用weblogic的jdbc，连接weblogic的datasource

datasource名:myDS
用户名:weblogic
密码:welcome1
ip:localhost:7001

请问应该如何修改这个application-context.xml
代码如下:



<beans 略...>

	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

		<property name="driverClass" value="oracle.jdbc.driver.OracleDriver" />

		<property name="jdbcUrl" value="jdbc:oracle:thin:@172.188.3.129:1521:orcl" />

		<property name="user" value="admin" />

		<property name="password" value="password" />

		<property name="autoCommitOnClose" value="true" />

		<property name="checkoutTimeout" value="5000" />

		<property name="initialPoolSize" value="5" />

		<property name="minPoolSize" value="5" />

		<property name="maxPoolSize" value="10" />

		<property name="maxIdleTime" value="7000" />

		<property name="acquireIncrement" value="10" />

		<property name="maxIdleTimeExcessConnections" value="1800" />

	</bean>

	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

		<!-- CLOB支持 -->

		<property name="lobHandler" ref="lobHandler"/>

		<property name="dataSource" ref="dataSource" />

		<property name="mappingLocations">

			<list>

				略...

			</list>

		</property>

		<property name="hibernateProperties">

			<props>

				<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>

				<prop key="hibernate.show_sql">true</prop>

				<prop key="hibernate.format_sql">false</prop>

				<prop key="hibernate.jdbc.batch_size">0</prop>

				<prop key="hibernate.query.substitutions">true 1, false 0</prop>

				<prop key="hibernate.cache.use_query_cache">true</prop>

				<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>

				<prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>				

			</props>

		</property>

		<property name="entityInterceptor">

			<ref local="treeInterceptor" />

		</property>

		<property name="cacheProvider">

			<ref local="cacheProvider" />

		</property>

	</bean>



	<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />



	<bean id="cacheProvider" class="cn.com.neauce.hljs.portal.common.hibernate3.SpringEhCacheProvider">

		<property name="configLocation">

			<value>classpath:ehcache-hibernate.xml</value>

		</property>

		<property name="diskStoreLocation">

			<value>/WEB-INF/cache/hibernate</value>

		</property>

	</bean>

	<bean id="treeInterceptor" class="cn.com.neauce.hljs.portal.common.hibernate3.TreeIntercptor" />

	<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">

		<property name="sessionFactory" ref="sessionFactory" />

	</bean>

	<!-- 设置 CLOB -->

	<bean id="nativeJdbcExtractor" lazy-init="true"  class="org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor"/>



	<!-- 设置本地 Jdbc 对象抽取器 读操作-->

	<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">

	   <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor" />

	</bean>

	<!-- 设置本地 Jdbc 对象抽取器 写操作-->

	<bean id="defaultLobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true"/>

	

	<context:annotation-config />

	<tx:annotation-driven transaction-manager="transactionManager" />

</beans>