per http://db.apache.org/derby/docs/10.1/ref/rrefkeywords29722.html should use Alter for debry db will see what I can do to make a patch.
BJ Freeman sent the following on 7/16/2008 9:17 AM: > 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 >> >> >> >> > > > >
