Liferay Plugin portlet connecting to multiple data bases/Data Sources

Lifray portal 6.1GA2+Tomcat7.X+Mysql 5.1X

Download Portlet from following URL

http://master.dl.sourceforge.net/project/meeralferay/MultiDataSource/MultiDataSource-portlet.rar

Place the portlet into your plugins/portlet directory

Create portlet using Liferay IDE from existing portlet and select portlet what you have downloaded.

Note:

before import please delete .project, .classpath and .settings files from downloaded portlet.

Create data base in mysql database name is “anotherdatabase”

Create Table name is TableFromAnotherDataSource in “anotherdatabase” database.

CREATE TABLE `tablefromanotherdatasource` (

`IFADSId` BIGINT(20) NOT NULL,

`Description` VARCHAR(75) NULL DEFAULT NULL,

PRIMARY KEY (`IFADSId`)

);

Add following properties in portal-ext.properties file

jdbc.anotherdbconfig.driverClassName=com.mysql.jdbc.Driver

jdbc.anotherdbconfig.url=jdbc:mysql://localhost:3306/anotherdatabase?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false

jdbc.anotherdbconfig.username=root

jdbc.anotherdbconfig.password=

Note:

When we change portal-ext.proprtiesfile you have to stop server after add some properties you have to restart.

portal-ext.properties file should be available in liferay home path if not you have to create and add above properties.

Generally home path like below

/bundles/ portal-ext.proprties or liferay-portal-6.1.1-ce-ga2/ portal-ext.proprties

Run ant build-service target from your eclipse ant view

Run and deploy then portle will be deployed

Note:
this portlet developed in Loferay Portal 6.1GA2 version and Plug-in SDK 6.1GA2

This portlet will use to connect to multiple data bases. When we get requirement plugin portlet need to connect to multiple databases or data sources we have to configure data source and Session Factory information in ext-spring.xml.

We have to create xml file and we need to place file in src/META-INF/ext-spring.xml

Generally Liferay plugin portlets uses default liferay database or data source. If we want connect to another database we have to configure those details in ext-spring.xml file.

Once we configured the data source and session factory in ext-spring.xml file then have to use these data source information in service.xmlfile that’s for entity.

following is ext-spring.xml

<?xml version="1.0"?>

<beans default-destroy-method="destroy" default-init-method="afterPropertiesSet"

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-3.0.xsd">

<bean id="anotherDataSource"

class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">

</bean>

<bean id="anotherDataSourceImpl"

class="com.liferay.portal.dao.jdbc.spring.DataSourceFactoryBean">

</bean>

<constructor-arg ref="anotherDataSourceImpl" />

</bean>

</bean>

<bean id="anotherHibernateSessionFactory" class="com.liferay.portal.kernel.spring.util.SpringFactoryUtil"

factory-method="newBean">

<constructor-arg value="com.liferay.portal.spring.hibernate.PortletHibernateConfiguration" />

<constructor-arg>

<map>

</map>

</constructor-arg>

</bean>

<bean id="anotherSessionFactory" class="com.liferay.portal.kernel.spring.util.SpringFactoryUtil"

factory-method="newBean">

<constructor-arg

value="com.liferay.portal.dao.orm.hibernate.PortletSessionFactoryImpl" />

<constructor-arg>

<map>

</map>

</constructor-arg>

</bean>

</beans>

Once we configured data source and session factory in ext-spring.xml we have to provide data source properties from portal-ext.properties file which in you liferay home path.

Generally home path like below

/bundles/ portal-ext.proprties or liferay-portal-6.1.1-ce-ga2/ portal-ext.proprties

Add the following properties in portal-ext.proprties

jdbc.anotherdbconfig.driverClassName=com.mysql.jdbc.Driver

jdbc.anotherdbconfig.url=jdbc:mysql://localhost:3306/anotherdatabase?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false

jdbc.anotherdbconfig.username=root

jdbc.anotherdbconfig.password=

Note:

jdbc. anotherdbconfig. Is the propertyPrefix which we have mentioned in ext-spring.xml file

<bean id="anotherDataSourceImpl"

class="com.liferay.portal.dao.jdbc.spring.DataSourceFactoryBean">

</bean>

Now we have to provide this information to entity which we have configured in service.xml .

In entity tag we have two attributes from that we can explicitly said about data source and session factory information .

</entity>

Note:
we have table attribute in entity tag when we mention this entity class targeting to that particular table

If we not provide table attribute then service builder create table name as namespace_entityname

If provide table attribute then table will be created exact name that we provided in table attribute.

Example:

We already having existed data base then we need not create tables from service builder then we just pass table name in table attribute then out entity class targeting to that table.

Observations:

Note:

When we use other data source for plugin portlet when we run service builder then tables creation script is not create so we have to create table manually in database if the table is new.

If you need create table script you can see in the class XXXModelImpl.java

XXX= entity Name

public static final String TABLE_SQL_CREATE = "create table TableFromAnotherDataSource (IFADSId LONG not null primary key,Description VARCHAR(75) null)";

You can also find data source and session factory that is used by your Entity class

public static final String DATA_SOURCE = "anotherDataSource";

public static final String SESSION_FACTORY = "anotherSessionFactory";

About Meera Prince

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.