Quartz scheduler configuration in cluster

-
 
Quartz is a very popular open source scheduler engine. Quartz scheduler stores data related to scheduled jobs in the Liferay database.

In clustered environment there will be chance of starting the scheduler for all the nodes at same time which causes duplicate entries in the portal. We should  execute only once for all the nodes.

Suppose if we have configured 4 nodes, then 4 scheduler will start at same time. But we need execute 1 scheduler for a job.

Hence in a clustered environment, it is possible that multiple nodes start the same job at the same time. This can create havoc. To prevent this situation, we need to configure Quartz for the clustered environment.

Add the following property in the portal-ext.properties

org.quartz.jobStore.isClustered=true

 Drop all the tables starting with QUARTZ_. This step is required if Liferay tables are already created.

We just added a property to let the Quartz scheduler know that we are running multiple instances of the Quartz scheduler connected to a single database.

By enabling this property, the Quartz scheduler will make sure that each job is executed only once.

Comments

  1. UnknownMarch 12, 2015 at 1:31 PM

    Kiến thức bạn share rất thông dụng, cảm ơn bạn đã share.
    Tìm hiểu Blog : Bán đá thạch anh

    ReplyDelete
  2. UnknownMarch 27, 2015 at 8:04 AM

    Bài viết của Bạn rất hữu ích, thank bạn đã share.
    Xem tại website : Đá thạch anh vụn rải bể cá

    ReplyDelete
  3. UnknownApril 29, 2015 at 8:56 PM

    Bài viết của Admin rất hay, thank bạn đã share.
    Thông tin thêm : Tỳ hưu

    ReplyDelete

Post a Comment

Popular posts from this blog

Theme display in javascript

-
We know that we can access the themedisplay in java as ThemeDisplay themeDisplay = (ThemeDisplay) request.getAttribute(WebKeys.THEME_DISPLAY) But how can we access in javascript? Here we go Liferay.ThemeDisplay.getScopeGroupId() Liferay.ThemeDisplay.getCompanyId() Liferay.ThemeDisplay.getPlid() Liferay.ThemeDisplay.getLayoutId() By this we can access the groupId, companyid ... etc
Read more

How to know which liferay version we are using

-
Image
Sometimes we have to know which liferay version we are using, so how can we know? We can know the liferay version in different ways. 1. Liferay has provided some utility methods to know the which liferay version we are using , Here is the utility method ReleaseInfo.getReleaseInfo() It prints this statement " Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014) " as i am using community version it shoes as CE. 2. Also we can also identify by response headers as below screenshot. If your using the chrome, right click on the browser and click inscept element , and navigate to the network  . you will see the URLS , click on the any url. 3. Also we can see during server startup as below statement Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014)
Read more

Viewing the SQL Query in liferay : debugging the SQL Query in Hibernate

-
Sometimes we have to know SQL query hiting in DB to retrieve the list. Suppose When we are writing the DynamicQuery , Some times we have to know SQL query it is generating to hit DB. So generally it is useful when we are debugging the Query it is generated. In hibernate we used the write the property in XML file as hibernate.show.sql to view the query. In Liferay also we can also set the below property to true in the portal-ext.properties to view the SQL query at the console. hibernate.show_sql=true. By adding the above property it will just reterive the parameters. What if we want to display the parameters. Add the below properties in log4j.properties it will display the paramters also. # logs the SQL statements #log4j.logger.org.hibernate.SQL=debug # Logs the JDBC parameters passed to a query #log4j.logger.org.hibernate.type=trace In Liferay log4j is located in the below location tomcat-7.0.42\webapps\ROOT\WEB-INF\classes Also we want to see hibernate ses
Read more