Problem changing a field length

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Problem changing a field length

Postby jasantana » Wed Feb 08, 2012 2:45 pm

Good afternoon from Gran Canaria.

I have changed a field length in one of my tables. After uploading the new solution I get a warning about that and the column has not been changed on the database.

I have manually changed that thru pgAdmin, now I have the DB as the one in my developer system, but the field length has not changed in the Servoy Application.

Do I need to restart the server?
Best regards,
Juan Antonio Santana Medina
jasantana@nephos-solutions.co.uk
Servoy MVP 2015
Servoy 6.x - Servoy 7.x - Servoy 8.x - MySQL - PostgreSQL - Visual Foxpro 9
User avatar
jasantana
 
Posts: 555
Joined: Tue Aug 10, 2010 11:40 am
Location: Leeds - West Yorkshire - United Kingdom

Re: Problem changing a field length

Postby Joas » Wed Feb 08, 2012 3:32 pm

The application server does not see changes to the database done with an external tool. When restarting the server it will reload the datamodel, so that will help.

Another option is to use the function JSServer.reloadDataModel() from the maintenance plugin.
For the future you might consider using the maintenance plugin to do the changes to the datamodel in a pre or post import solution, then you don't have to do it manually for every import.
Joas de Haan
Yield Software Development
Need help on your project? yieldsd.com
User avatar
Joas
Site Admin
 
Posts: 842
Joined: Mon Mar 20, 2006 4:07 pm
Location: Leusden, NL


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 3 guests

cron