Re:Not updating table in Database

[venka reddy, geändert vor 11 Jahren.]

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, geändert vor 11 Jahren.]

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, geändert vor 11 Jahren.]

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, geändert vor 11 Jahren.]

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, geändert vor 11 Jahren.]

Hi Hitoshi Ozawa ,

I got it

When i restart the server , table is updated in DB