フォーラム

ホーム » Liferay Portal » English » 2. Using Liferay » General

構造的に表示 平面上に表示 ツリー上に表示
スレッド [ 前へ | 次へ ]
toggle
Ishan Sahore
Liferay Repository for Web content
2012/07/13 3:02
答え

Ishan Sahore

ランク: Junior Member

投稿: 56

参加年月日: 2012/04/25

最近の投稿

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
2012/07/13 3:14
答え

DarshanKumar N Bhatia

ランク: Junior Member

投稿: 85

参加年月日: 2010/03/02

最近の投稿

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
2012/07/13 3:26
答え

Sachin Mane

ランク: Junior Member

投稿: 76

参加年月日: 2012/04/09

最近の投稿

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
2012/07/13 3:46
答え

Jignesh Vachhani

ランク: Liferay Master

投稿: 785

参加年月日: 2008/03/10

最近の投稿

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
2012/07/15 23:23
答え

Ishan Sahore

ランク: Junior Member

投稿: 56

参加年月日: 2012/04/25

最近の投稿

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
2012/07/15 23:44
答え

Jignesh Vachhani

ランク: Liferay Master

投稿: 785

参加年月日: 2008/03/10

最近の投稿

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
2012/07/16 1:44
答え

Ishan Sahore

ランク: Junior Member

投稿: 56

参加年月日: 2012/04/25

最近の投稿

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
2012/07/16 2:58
答え

Jignesh Vachhani

ランク: Liferay Master

投稿: 785

参加年月日: 2008/03/10

最近の投稿

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
2012/07/16 10:54
答え

Sachin Mane

ランク: Junior Member

投稿: 76

参加年月日: 2012/04/09

最近の投稿

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
2012/07/16 14:34
答え

Hitoshi Ozawa

ランク: Liferay Legend

投稿: 7949

参加年月日: 2010/03/23

最近の投稿

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.