Forums

Home » Liferay Portal » English » 2. Using Liferay » General

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
venka reddy
Re:Not updating table in Database
April 30, 2012 10:16 PM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi ,

I am developing plugin, i have created a table "Book" with certain columns(like Id,title). i have build the service. XML and successfully deployed.

These table is created in DATABASE also.

Due to some new requirements i need to add column "Type" in table .Again i have build the service. XML and successfully deployed, but it is not updating the table in DATABASE.

Is anything i am going wrong??
Hitesh Methani
RE: Re:Not updating table in Database
April 30, 2012 10:34 PM
Answer

Hitesh Methani

Rank: Regular Member

Posts: 171

Join Date: June 24, 2010

Recent Posts

Hi Venka,

Try clearing server cache, check in tables.sql if that column is add there, and in deployment logs, check if build-number exception is not coming.

Thanks and Regards,
Hitesh Methani
venka reddy
RE: Re:Not updating table in Database
April 30, 2012 11:46 PM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi Hitesh ,

Thanks for your reply

I have checked "tables.sql" it is updated with the new column, also it is not generating build-number exception.

Still it is not updated in Database
Hitoshi Ozawa
RE: Re:Not updating table in Database
May 1, 2012 3:13 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Liferay doesn't update table structure once it's created. You'll have to drop the table and let liferay recreate it or do a manual update on the table using sql command yourself.
venka reddy
RE: Re:Not updating table in Database
May 1, 2012 4:50 AM
Answer

venka reddy

Rank: Regular Member

Posts: 231

Join Date: March 23, 2011

Recent Posts

Hi Hitoshi Ozawa ,

I got it

When i restart the server , table is updated in DB