To Configure Liferay to store data of Document Library in Mysql Database Follow these Steps:

1) Shutdown the Liferay tomcat server.

2) Add these lines in Portal-ext.properties:

#dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook

dl.hook.impl=com.liferay.documentlibrary.util.JCRHook

##

## JCR

##

jcr.initialize.on.startup=true

jcr.workspace.name=liferay

jcr.node.documentlibrary=documentlibrary

jcr.jackrabbit.repository.root=${liferay.home}/data/jackrabbit

jcr.jackrabbit.config.file.path=${jcr.jackrabbit.repository.root}/repository.xml

jcr.jackrabbit.repository.home=${jcr.jackrabbit.repository.root}/home

jcr.jackrabbit.credentials.username=none

jcr.jackrabbit.credentials.password=none

3) Changes in \liferay-portal-5.2.0\data\jackrabbit\repository.xml

<Repository>

<!-- Commented to remove filesystem

<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">

<param name="path" value="${rep.home}/repository" />

</FileSystem> -->

<!--

Database File System (Cluster Configuration)

This is sample configuration for mysql persistence that can be used for

clustering Jackrabbit. For other databases, change the connection,

credentials, and schema settings.

-->

<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">

<param name="driver" value="com.mysql.jdbc.Driver"/>

<param name="url" value="jdbc:mysql://localhost/training" />

<param name="user" value="root" />

<param name="password" value="root" />

<param name="schema" value="mysql"/>

<param name="schemaObjectPrefix" value="J_R_FS_"/>

</FileSystem>

<Security appName="Jackrabbit">

<AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager" />

<LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule">

<param name="anonymousId" value="anonymous" />

</LoginModule>

</Security>

<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="liferay" />

<Workspace name="${wsp.name}">

<!-- Commented to remove filesystem

<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">

<param name="path" value="${wsp.home}" />

</FileSystem>

<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.BundleFsPersistenceManager" /> -->

<!--

Database File System and Persistence (Cluster Configuration)

This is sample configuration for mysql persistence that can be used for

clustering Jackrabbit. For other databases, change the connection,

credentials, and schema settings.

-->

<PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">

<param name="driver" value="com.mysql.jdbc.Driver" />

<param name="url" value="jdbc:mysql://localhost/training" />

<param name="user" value="root" />

<param name="password" value="root" />

<param name="schema" value="mysql" />

<param name="schemaObjectPrefix" value="J_PM_${wsp.name}_" />

<param name="externalBLOBs" value="false" />

</PersistenceManager>

<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">

<param name="driver" value="com.mysql.jdbc.Driver"/>

<param name="url" value="jdbc:mysql://localhost/training" />

<param name="user" value="root" />

<param name="password" value="root" />

<param name="schema" value="mysql"/>

<param name="schemaObjectPrefix" value="J_FS_${wsp.name}_"/>

</FileSystem>

</Workspace>

<Versioning rootPath="${rep.home}/version">

<!-- Commented to remove filesystem

<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">

<param name="path" value="${rep.home}/version" />

</FileSystem>

<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.BundleFsPersistenceManager" /> -->

<!--

Database File System and Persistence (Cluster Configuration)

This is sample configuration for mysql persistence that can be used for

clustering Jackrabbit. For other databases, change the connection,

credentials, and schema settings.

-->

<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">

<param name="driver" value="com.mysql.jdbc.Driver"/>

<param name="url" value="jdbc:mysql://localhost/training" />

<param name="user" value="root" />

<param name="password" value="root" />

<param name="schema" value="mysql"/>

<param name="schemaObjectPrefix" value="J_V_FS_"/>

</FileSystem>

<PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">

<param name="driver" value="com.mysql.jdbc.Driver" />

<param name="url" value="jdbc:mysql://localhost/training" />

<param name="user" value="root" />

<param name="password" value="root" />

<param name="schema" value="mysql" />

<param name="schemaObjectPrefix" value="J_V_PM_" />

<param name="externalBLOBs" value="false" />

</PersistenceManager>

</Versioning>

<!--

Cluster Configuration

This is sample configuration for mysql persistence that can be used for

clustering Jackrabbit. For other databases, change the connection,

credentials, and schema settings.

-->

<!--<Cluster id="node_1" syncDelay="5">

<Journal class="org.apache.jackrabbit.core.journal.DatabaseJournal">

<param name="revision" value="${rep.home}/revision"/>

<param name="driver" value="com.mysql.jdbc.Driver"/>

<param name="url" value="jdbc:mysql://localhost/jcr"/>

<param name="user" value=""/>

<param name="password" value=""/>

<param name="schema" value="mysql"/>

<param name="schemaObjectPrefix" value="J_C_"/>

</Journal>

</Cluster>-->

</Repository>

4. Start Liferay Tomcat Server

5. Now Create a Document and upload content in Document Library

6. At time of uploding content more then few MB, If you get 'max_allowed_packet' related error. Then Shutdown the Liferay Tomcat Server.

7. Edit \Program Files\MySQL\MySQL Server 5.0\my.ini

8. Set the 'max_allowed_packet' property by adding the following line at the end [[mysqld] Section ]

# 16777216 = 16M so upto 16MB packet can be uploaded

max_allowed_packet=16777216

4. Restart MySql Service

5. Start Liferay Tomcat Server and you can upload the Content in Document Library