Re: Entity Changes for column definition Not Reflecting in DB

2009-08-11 Thread snowc
In r4.0 on MS SQL, new columns are not recognized by the entity engine using my setup. I was told this may be due to the lack of meta data provided by the MS JDBC driver I am using. I manually add new columns and keys to the database - it's not that much of a big deal for my environment.

Entity Changes for column definition Not Reflecting in DB

2009-08-10 Thread Hemanth Kumar Kanamarlapudi
Hi Users, Can any one please tell me the reason why the changes in my entity definition are not reflected in the database. For example I have a cardNumber which is earlier Numeric/Integer in entitymodel.xml as well as in database. Now I changed cardNumber to Name/String type in

Re: Entity Changes for column definition Not Reflecting in DB

2009-08-10 Thread Abdullah Shaikh
Do you have check-on-start add-missing-on-start set to true in your datasource definition ? On Mon, Aug 10, 2009 at 12:00 PM, Hemanth Kumar Kanamarlapudi hemanth_kanamarlap...@mindtree.com wrote: Hi Users, Can any one please tell me the reason why the changes in my entity definition are

Re: Entity Changes for column definition Not Reflecting in DB

2009-08-10 Thread David E Jones
The Entity Engine only automatically adds new tables and columns, it does not automatically change column types. It will, however, warn you about the database column type not matching the entity field type. Please read through the warnings on startup or on the checkdb page in webtools

Re: Entity Changes for column definition Not Reflecting in DB

2009-08-10 Thread Hans Bakker
The change you did need a unload/reload of the entity if you do not want to loose existing data. If you do not mind loosing the content of the entity simply dropping the entity and restarting ofbiz will do the trick Regards, Hans On Mon, 2009-08-10 at 12:00 +0530, Hemanth Kumar Kanamarlapudi