Forums

Home » Liferay Portal » English » 2. Using Liferay » General

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Ishan Sahore
Liferay Repository for Web content
July 13, 2012 3:02 AM
Answer

Ishan Sahore

Rank: Junior Member

Posts: 56

Join Date: April 25, 2012

Recent Posts

Hi,

I wanted to know that where does Liferay store the web content that we publish through its "Web Content" tool. Also, when we provide translation for the content, where is that stored?

Thanks.
DarshanKumar N Bhatia
RE: Liferay Repository for Web content
July 13, 2012 3:14 AM
Answer

DarshanKumar N Bhatia

Rank: Junior Member

Posts: 85

Join Date: March 2, 2010

Recent Posts

Liferay's Web Content is Stored in Database :

In Database "journalarticle" is main table to store web content.

In Content columns , web content data is stored in the form of XML like :

<?xml version="1.0"?>

<root available-locales="en_US" default-locale="en_US">
<static-content language-id="en_US">&lt;p&gt; This is my Own Terms of Use Showing within Web content adjust by Hook.&lt;/p&gt;</static-content>
</root>

Also Multilingual Content is saved in same table in XML format like

<?xml version="1.0"?>

<root available-locales="en_US,hi_IN," default-locale="hi_IN">
<static-content language-id="en_US">&lt;style type="text/css"&gt; h1 {font-size:36pt;} h2 {color:blue;} p {margin-left:50px;}&lt;/style&gt; &lt;h1&gt; This header is 36 pt&lt;/h1&gt; &lt;h2&gt; This header is blue&lt;/h2&gt; &lt;p&gt; This paragraph has a left margin of 50 pixels&lt;/p&gt;</static-content>
<static-content language-id="hi_IN">इस अनुच्छेद 50 पिक्सल के बाईं मार्जिन</static-content>
</root>

HTH
Sachin Mane
RE: Liferay Repository for Web content
July 13, 2012 3:26 AM
Answer

Sachin Mane

Rank: Junior Member

Posts: 76

Join Date: April 9, 2012

Recent Posts

It depends on how you configure your document library and image library. Liferay 6.x provides following options in the form of Store.
The meta data is stored in the database table. However the actual content is stored based on Store configuration
1
2BaseStore
3-> FileSystemStore -> plain file system
4---> AdvancedFileSystemStore -> advance folder and file handling
5-> DBStore  -> database
6-> CMISStore -> any CMIS compliant repository
7-> JCRStore -> any JSR170 compliant repository
8-> S3Store -> amazon store
Jignesh Vachhani
RE: Liferay Repository for Web content
July 13, 2012 3:46 AM
Answer

Jignesh Vachhani

Rank: Liferay Master

Posts: 785

Join Date: March 10, 2008

Recent Posts

Web content related information will be stored in below tables :

journalarticle : Stores actual web content details
journalarticleimage : Article Image will be stored
journalarticleresource : reference table
journalcontentsearch : used by web content search
journalfeed : Details about web content feed
journalstructure : Stores structure details when you create any structure in web content
journaltemplate : Stores template details when you create any template in web content
Ishan Sahore
RE: Liferay Repository for Web content
July 15, 2012 11:23 PM
Answer

Ishan Sahore

Rank: Junior Member

Posts: 56

Join Date: April 25, 2012

Recent Posts

Thanks All for your answers.
I am using the default HSQL database. Where can I find it in HSQL?
Jignesh Vachhani
RE: Liferay Repository for Web content
July 15, 2012 11:44 PM
Answer

Jignesh Vachhani

Rank: Liferay Master

Posts: 785

Join Date: March 10, 2008

Recent Posts

In HSQL it will be stored in file system like which will be stored in form of query.
you can find this file in your tomcat data folder e.g\tomcat\liferay-portal-6.1.0-ce-ga1\data\hsql\lportal.script
Ishan Sahore
RE: Liferay Repository for Web content
July 16, 2012 1:44 AM
Answer

Ishan Sahore

Rank: Junior Member

Posts: 56

Join Date: April 25, 2012

Recent Posts

Jignesh Vachhani:
In HSQL it will be stored in file system like which will be stored in form of query.
you can find this file in your tomcat data folder e.g\tomcat\liferay-portal-6.1.0-ce-ga1\data\hsql\lportal.script



Can I access the content from HSQL client by running hsql.jar?
The lportal.script file contains data but it's quite difficult to understand.
Jignesh Vachhani
RE: Liferay Repository for Web content
July 16, 2012 2:58 AM
Answer

Jignesh Vachhani

Rank: Liferay Master

Posts: 785

Join Date: March 10, 2008

Recent Posts

Ishan Sahore:
Jignesh Vachhani:
In HSQL it will be stored in file system like which will be stored in form of query.
you can find this file in your tomcat data folder e.g\tomcat\liferay-portal-6.1.0-ce-ga1\data\hsql\lportal.script



Can I access the content from HSQL client by running hsql.jar?
The lportal.script file contains data but it's quite difficult to understand.



I would suggest don't go with HSQL because liferay also doesn't propose to use this DB.
So better you go with mysql or other db and check
Sachin Mane
RE: Liferay Repository for Web content
July 16, 2012 10:54 AM
Answer

Sachin Mane

Rank: Junior Member

Posts: 76

Join Date: April 9, 2012

Recent Posts

You can use http://squirrel-sql.sourceforge.net/ to connect see and query HSQL database. It is kind of universal ui client.
Hitoshi Ozawa
RE: Liferay Repository for Web content
July 16, 2012 2:34 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

You can use Squirrel SQL as Sachin mentioned but you can just open up lportal.script with a text editor and do a search for the word you've entered.

In either case, you have to have liferay shutdown becase liferay flushes content when it is shutting down.