ran the web tools to update db.
for the derby got this error a lot
* SQL Exception while executing the following: ALTER TABLE
OFBIZ.WORK_EFFORT_SEARCH_RESULT RENAME NUM_RESULTS TO TMP_NUMRESULTS
Error was: java.sql.SQLException: Syntax error: Encountered "RENAME" at
line 1, column 45.
BJ Freeman sent the following on 7/16/2008 8:30 AM:
> Database util seems to report tables size, missing or removed fine.
> I was under the assumption that it also modified (altered) the Tables
> and columns, to fit the new entities.
> If so it is not doing it as far as i can tell on the default db (derby)
>
> next observation is that some of the tables are two char smaller than
> the entities. I don't believe the entities have been changed since they
> report 20 as the size, but the DB is 18.
>
> these are with
> ant clean
> you won't see this with a
> ant clean-all
>
>
>
>
