Forums

Home » Liferay Portal » English » 3. Development

Combination View Flat View Tree View
Threads [ Previous | Next ]
venka reddy
Re:How to Customize DB Column Size in Plugin
June 5, 2012 5:58 AM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi ,

How can we Customize column size in Plugin? , I have read a documentation, we can modify column size in EXT at Portal-model-hints.xml.
Jelmer Kuperus
RE: Re:How to Customize DB Column Size in Plugin
June 5, 2012 9:06 AM
Answer

Jelmer Kuperus

Rank: Liferay Legend

Posts: 1192

Join Date: March 10, 2010

Recent Posts

It works the same way for portlets, you edit : docroot/WEB-INF/src/META-INF/portlet-model-hints.xml after you have run ant build-service
venka reddy
RE: Re:How to Customize DB Column Size in Plugin
June 5, 2012 10:10 PM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

hi jelmer,

Thanks for your reply

I have modified portlet-model-hints.xml as below.

<model-hints>
<hint-collection name="CLOB">
<hint name="max-length">2000000</hint>
</hint-collection>

<model name="xxxxxxxxxx">
<field name="Content" type="String" >
<hint-collection name="CLOB" />
</field>

I have noticed It is updated in tables.sql as ,
content TEXT null,

But is not updated in DB still content type is VARCHAR
Jitendra Rajput
RE: Re:How to Customize DB Column Size in Plugin
June 5, 2012 10:33 PM
Answer

Jitendra Rajput

Rank: Liferay Master

Posts: 709

Join Date: January 7, 2011

Recent Posts

check this
http://itsliferay.blogspot.in/2012/03/customize-database-column-size.html
venka reddy
RE: Re:How to Customize DB Column Size in Plugin
June 5, 2012 11:27 PM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi Jitendra,

I have gone through your link and same steps i have implemented in my plugin.

But not reflected in my DB , Still it shows its DATATYPE is VARCHAR.

I think once table is added with column type varchar , it cannot update to TEXT.

Is my guess correct?
Chintan Akhani
RE: Re:How to Customize DB Column Size in Plugin
June 5, 2012 11:30 PM
Answer

Chintan Akhani

Rank: Regular Member

Posts: 111

Join Date: March 13, 2008

Recent Posts

If you want to change the datatype than you have to do that change in service.xml first, and than you need to do ant build service again.
Jitendra Rajput
RE: Re:How to Customize DB Column Size in Plugin
June 5, 2012 11:45 PM
Answer

Jitendra Rajput

Rank: Liferay Master

Posts: 709

Join Date: January 7, 2011

Recent Posts

First of check if your changes are getting reflected or not . Verify from your log is that any BuildNumber error if so then you database changes wont be reflected.
venka reddy
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 12:41 AM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi,

My Service .properties as follows


include-and-override=service-ext.properties

build.namespace=Sample
build.number=486
build.date=1338904122042
build.auto.upgrade=true

spring.configs=\
WEB-INF/classes/META-INF/base-spring.xml,\
\
WEB-INF/classes/META-INF/hibernate-spring.xml,\
WEB-INF/classes/META-INF/infrastructure-spring.xml,\
\
WEB-INF/classes/META-INF/cluster-spring.xml,\
\
WEB-INF/classes/META-INF/portlet-spring.xml,\
\
WEB-INF/classes/META-INF/dynamic-data-source-spring.xml,\
WEB-INF/classes/META-INF/shard-data-source-spring.xml,\
\
WEB-INF/classes/META-INF/ext-spring.xml


and my servicecomponent table is


11501, 'Sample', 485, 1335936754156,

By observing this , i think it will not generate BuildNumber error
Riccardo Ferrari
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 12:48 AM
Answer

Riccardo Ferrari

Rank: Regular Member

Posts: 137

Join Date: November 13, 2010

Recent Posts

Hi,
I am not sure that LR is able to update an already deployed schema. Can you try to drop the table and deploy the service again? (you have to run a service-build task before deploying it)
Which LR are you running?

Regards,
Riccardo
Alexandre FILLATRE
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 1:04 AM
Answer

Alexandre FILLATRE

Rank: Junior Member

Posts: 80

Join Date: December 2, 2010

Recent Posts

Riccardo Ferrari:
Hi,
I am not sure that LR is able to update an already deployed schema. Can you try to drop the table and deploy the service again? (you have to run a service-build task before deploying it)
Which LR are you running?

Regards,
Riccardo


Liferay should be able to handle that. This might be a regression (to check). I'm familiar with the process describe in the second post, and it looks right to me.

@venka : Can you try to add a field in your entity, build the service again, and re-deploy your plugin to see if it works that way ?

Regards,
Alexandre FILLATRE
Riccardo Ferrari
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 1:13 AM
Answer

Riccardo Ferrari

Rank: Regular Member

Posts: 137

Join Date: November 13, 2010

Recent Posts

I had previous experience on LR 5.2.2 CE not being able to update the schema. Thats why I was asking about the LR version.

Regards,
Riccardo
venka reddy
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 3:14 AM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi Alexandre FILLATRE,

I am using LR 6.0.5

As you have suggested, i have changed as below

portlet-models-hints.xml

<model-hints>
<hint-collection name="CLOB">
<hint name="max-length">2000000</hint>
</hint-collection>

<model name="xxxxxxxxxx">
<field name="Content" type="String" >
<hint-collection name="CLOB" />
</field>

Modified portlet-models-hints.xml

<model-hints>
<hint-collection name="CLOB">
<hint name="max-length">2000000</hint>
</hint-collection>

<model name="xxxxxxxxxx">
<field name="description" type="String" >
<hint-collection name="CLOB" />
</field>

<field name="Content" type="String" >
<hint-collection name="CLOB" />
</field>

tables.SQL
title TEXT null,
description TEXT null,

I have built the service and deploy the portlet no changes In DB , Still my "description" DATATYPE is VARCHAR
Jitendra Rajput
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 4:21 AM
Answer

Jitendra Rajput

Rank: Liferay Master

Posts: 709

Join Date: January 7, 2011

Recent Posts

Have you tried by restarting your application server ?
venka reddy
RE: Re:How to Customize DB Column Size in Plugin
June 6, 2012 4:47 AM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi,

got!!! when i restart the server, Columns get updated