Mail Portlet Synchronization Issue

Liferay Portlet doesn't Synchronize all the mails properly. Though it shows the Mail Count in Pagination,the Pagination fails to work properly at a certain level.

This is due to some unusual characters in subject/sender/to/body in your mails.

You can resolve this by changing some column types from "mail_message" table.

Step 1: Please make sure that your database character set is "UTF-8".If it isn't then create it as follows:

create database testing character set utf-8



Step 2: Change "longtext" to "binary" for some column from "mail_message" table

as follows:

alter table Mail_Message modify column sender longtext character set binary;

alter table Mail_Message modify column to_ longtext character set binary;

alter table Mail_Message modify column cc longtext character set binary;

alter table Mail_Message modify column bcc longtext character set binary;

alter table Mail_Message modify column body longtext character set binary;

alter table mail_message modify column sender longtext charecter set binary

Read more »

Fileupload using service.xml file

I have done this in MVC portlet. File upload in liferay using service.xml file is bit tricky. With small modification in portlet-model-hints.xml we can achieve this.

Step 1: Give the data type as string to store the uploaded file.

entry in service.xml file

<entity name="FileUploader" table="fileuploader" local-service="true">

<column name="fid" type="long" primary="true"/>

<column name="content" type="String"/>

</entity>

Step 2 : Do 'ant build-service' from specific portlet level. As you know that which is used to generate the api to interact with database.

Step 3 : Open 'portlet-model-hints.xml' file which is in 'WEB-INF/src/META-INF'.

Initially this xml file look like this

<model-hints>

<model name="com.sample.mvc.model.FileUploader">

<field name="fid" type="long" />

<field name="content" type="String" />

</model>

</model-hints>

Depending on this xml file script files will generate which are in 'sql' folder.

Define 'hint-collection' tag for the 'content' column where i am storing the file content in this example.

Modified file will be as shown below.

<model-hints>

<model name="com.sample.mvc.model.FileUploader">

<field name="fid" type="long" />

<field name="content" type="String">

<hint-collection name="CLOBTYPE" />

</field>

</model>

<hint-collection name="CLOBTYPE">

<hint name="max-length">2000000</hint>

</hint-collection>

</model-hints>

Step 4 : Now do again 'ant build-service' to update the corresponding script files. This will update the sql script file. We can see the datatype of 'content' column in sql script as TEXT. When we deploy it will create CLOB type column in your database.

Step 5 : Write this logic in your action class to get the file from the jsp page and store it into the database.

public void abc(ActionRequest arq,ActionResponse ars) throws Exception {

UploadPortletRequest uploadRequest = PortalUtil.getUploadPortletRequest(arq);

FileUploader fileUp = new FileUploaderImpl();

fileUp.setFid(CounterLocalServiceUtil.increment("FileUploader.class"));

File file = uploadRequest.getFile("file");

byte[] bytes = FileUtil.getBytes(file);

fileUp.setContent(Base64.objectToString(bytes));

FileUploaderLocalServiceUtil.addFileUploader(fileUp);

}

Your JSP page something look like this :

<%@ taglib uri="http://java.sun.com/portlet_2_0" prefix="portlet" %>

<portlet:defineObjects />

<%@page import="javax.portlet.PortletURL"%>

<portlet:actionURL name="abc" var="actionURL1"></portlet:actionURL>

<form action="<%= actionURL1.toString() %>" method="post" enctype="multipart/form-data">

Name : <input type="text" name="urname" />

<input type="file" name="file"/>

<input type="submit" value="Submit" />

</form>

Read more »