Fóruns

Início » Liferay Portal » English » 3. Development

Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
venka reddy
Re:How to Customize DB Column Size in Plugin
5 de Junho de 2012 05:58
Resposta

venka reddy

Ranking: Regular Member

Mensagens: 231

Data de entrada: 23 de Março de 2011

Mensagens recentes

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
5 de Junho de 2012 09:06
Resposta

Jelmer Kuperus

Ranking: Liferay Legend

Mensagens: 1192

Data de entrada: 10 de Março de 2010

Mensagens recentes

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
5 de Junho de 2012 22:10
Resposta

venka reddy

Ranking: Regular Member

Mensagens: 231

Data de entrada: 23 de Março de 2011

Mensagens recentes

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
5 de Junho de 2012 22:33
Resposta

Jitendra Rajput

Ranking: Liferay Master

Mensagens: 858

Data de entrada: 7 de Janeiro de 2011

Mensagens recentes

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
5 de Junho de 2012 23:27
Resposta

venka reddy

Ranking: Regular Member

Mensagens: 231

Data de entrada: 23 de Março de 2011

Mensagens recentes

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
5 de Junho de 2012 23:30
Resposta

Chintan Akhani

Ranking: Regular Member

Mensagens: 111

Data de entrada: 13 de Março de 2008

Mensagens recentes

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
5 de Junho de 2012 23:45
Resposta

Jitendra Rajput

Ranking: Liferay Master

Mensagens: 858

Data de entrada: 7 de Janeiro de 2011

Mensagens recentes

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
6 de Junho de 2012 00:41
Resposta

venka reddy

Ranking: Regular Member

Mensagens: 231

Data de entrada: 23 de Março de 2011

Mensagens recentes

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
6 de Junho de 2012 00:48
Resposta

Riccardo Ferrari

Ranking: Regular Member

Mensagens: 137

Data de entrada: 13 de Novembro de 2010

Mensagens recentes

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
6 de Junho de 2012 01:04
Resposta

Alexandre FILLATRE

Ranking: Junior Member

Mensagens: 80

Data de entrada: 2 de Dezembro de 2010

Mensagens recentes

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
6 de Junho de 2012 01:13
Resposta

Riccardo Ferrari

Ranking: Regular Member

Mensagens: 137

Data de entrada: 13 de Novembro de 2010

Mensagens recentes

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
6 de Junho de 2012 03:14
Resposta

venka reddy

Ranking: Regular Member

Mensagens: 231

Data de entrada: 23 de Março de 2011

Mensagens recentes

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
6 de Junho de 2012 04:21
Resposta

Jitendra Rajput

Ranking: Liferay Master

Mensagens: 858

Data de entrada: 7 de Janeiro de 2011

Mensagens recentes

Have you tried by restarting your application server ?
venka reddy
RE: Re:How to Customize DB Column Size in Plugin
6 de Junho de 2012 04:47
Resposta

venka reddy

Ranking: Regular Member

Mensagens: 231

Data de entrada: 23 de Março de 2011

Mensagens recentes

Hi,

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