Liferay连接第二个database

最新推荐文章于 2025-09-12 12:57:51 发布

原创最新推荐文章于 2025-09-12 12:57:51 发布 · 564 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了如何使用Spring框架进行数据库整合配置，包括数据源、事务管理、会话工厂等关键组件的配置，以及如何在服务层中实现创建空表的操作。同时，提供了针对特定数据库（如MySQL）的配置信息，以及创建自定义SQL文件和数据库的步骤。

In MATA-INF add ext-spring.xml

<?xml version="1.0"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
	<bean id="newDatabaseHibernateSessionFactory"
		class="com.liferay.portal.spring.hibernate.PortletHibernateConfiguration"
		lazy-init="true">
		<property name="dataSource" ref="newDatabaseDataSource" /></span>
	</bean>

	<bean id="newDatabaseSessionFactory" class="com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl"</span>
		lazy-init="true">
		<property name="sessionFactoryImplementor" ref="newDatabaseHibernateSessionFactory" /></span>
	</bean>

	<bean id="newDatabaseTransactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager"
		lazy-init="true">
		<property name="dataSource" ref="newDatabaseDataSource" /></span>
		<property name="globalRollbackOnParticipationFailure" value="false" />
		<property name="sessionFactory" ref="newDatabaseHibernateSessionFactory" /></span>
	</bean>
	
	<bean id="newDatabaseDataSource"</span>
		class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">
		<property name="targetDataSource">
			<bean class="com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean">
				<property name="propertyPrefix" value="jdbc.newDatabase." /></span>
			</bean>
		</property>
	</bean>
</beans>

In service.xml use:(create a empty table for tableNameFinderImpl in persistence pageage )

<entity name="tableName" local-service="true" remote-service="false" 
			data-source="newDatabaseDataSource" session-factory="newDatabaseSessionFactory"
			tx-manager="newDatabaseTransactionManager">
		<column name="Id" type="long" primary="true" />
		<column name="value" type="String" />
	</entity>

In Liferay Tomcat tomcat-7.0.23\webapps\ROOT\WEB-INF\classes file portal-ext.properties

#newDatabase database
jdbc.newDatabase.driverClassName=com.mysql.jdbc.Driver
jdbc.newDatabase.url=jdbc:mysql://localhost/newDatabase?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.newDatabase.username=root
jdbc.newDatabase.password=root