Connect to second database in Liferay(連接第二個(gè)數(shù)據(jù)庫(kù))

同時(shí)連接兩個(gè)數(shù)據(jù)庫(kù)，連接多個(gè)數(shù)據(jù)庫(kù)

這是我自己研究出來(lái)的，真的可以說(shuō)是世界首發(fā)了，網(wǎng)上也有一些例子，都要么就是老版本，要么就特復(fù)雜。我的這個(gè)方法特簡(jiǎn)單，希望對(duì)大家有用，也希望大家珍惜

因?yàn)楣镜男枰苯訉懙挠⑽陌娴模幌朐俜g回來(lái)了。都不難理解，一看就能明白。不懂的請(qǐng)留言

Introduction

                First of all, I should say that setting liferay to connect to another database is very easy. Certainty, all of things to make easy always after numerous attempts . I searched several solutions from website before. But, not only for old version but also too complex.  As my understand  According to original source, and several trial. I found the way. And I think that it is the World Premiere.^_^

Prerequisites

You should know how to create services with Service Builder, Also You should know how to create new portlet. how to link to database and  how it is used inside programming language code.

The steps described here were performed over Liferay 6.0.6.

Let us Beginning

1.       Create a file named portal-ext.properties in {WEBSERVER-HOME}\webapps\ROOT\WEB-INF\classes. And type the following code:

    #
    # MySQL
    #
    jdbc.default.driverClassName=com.mysql.jdbc.Driver
    jdbc.default.url=jdbc:mysql://localhost/lfportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
    jdbc.default.username=root
    jdbc.default.password=root  
  
    #
    # This is the second connection
    #
    jdbc.second.driverClassName=net.sourceforge.jtds.jdbc.Driver
    jdbc.second.url=jdbc:jtds:sqlserver://localhost:1433/extraDB
    jdbc.second.username=sa
    jdbc.second.password=test

2.       Create a service.xml file. And type the following code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.0.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd">
<service-builder package-path="com.test">
    <author>noah.xiang</author>
    <namespace>nx</namespace>

    <entity name="MyTable" local-service="true" remote-service="false" table="myTable" data-source="secondDataSource" session-factory="secondSessionFactory" tx-manager="secondTransactionManager">
        <!-- PK fields -->

        <column name="id" type="int" primary="true" />

        <!-- Audit fields -->

        <column name="jahr" type="Date" mapping-key="[Jahr]"/>
        <column name="beschaffungsstrategie" type="String"  mapping-key="[Beschaffungsstrategie]"/>
        <column name="buchVon" type="String" mapping-key="[Buch von]"/>
        
    </entity>
</service-builder>

3.       Ant build-service.xml, let liferay to generate code.

4.       Create a new file named ext-spring.xml in src\META-INF folder. And copy the following code:

<?xml version="1.0"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="secondDataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy" lazy-init="true">
        <property name="targetDataSource">
            <bean class="com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean">
                <property name="propertyPrefix" value="jdbc.second." />
            </bean>
        </property>
    </bean>
    <bean id="secondHibernateSessionFactory" class="com.liferay.portal.spring.hibernate.PortalHibernateConfiguration" lazy-init="true">
        <property name="dataSource">
            <ref bean="secondDataSource" />
        </property>
        <property name="mappingResources">
            <list>
                <value>META-INF/portlet-hbm.xml</value>
            </list>
        </property>
    </bean>
    <bean id="secondSessionFactory" class="com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl" lazy-init="true">
        <property name="sessionFactoryImplementor">
            <ref bean="secondHibernateSessionFactory" />
        </property>
    </bean>
    <bean id="secondTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager" lazy-init="true">
        <property name="dataSource">
            <ref bean="secondDataSource" />
        </property>
        <property name="sessionFactory">
            <ref bean="secondHibernateSessionFactory" />
        </property>
    </bean>
</beans>

5.       No more. So easy right? About how to call and deploy it. I believe that you can do.

眼鏡蛇

posted on 2011-10-27 17:56 眼鏡蛇 閱讀(1420) 評(píng)論(6)  編輯  收藏 所屬分類: Liferay