further explain from user list
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.
this will be fixed if we upgrade to version 10.3.1.4
David E Jones sent the following on 7/16/2008 1:24 PM:
>
> Could you be more specific about the problem? I'm not able to figure
> that our based on the solution you are proposing...
>
> Which database are you using? What SQL in particular is not supported,
> and what does that SQL need to look like to work?
>
> -David
>
>
> On Jul 16, 2008, at 1:38 PM, BJ Freeman wrote:
>
>> I moved this from user since some thought has to be put in on how to
>> handle different DB that use different reserved words.
>>
>> currently it is hard coded for instance to use rename for a column.
>> However our default DB OTTB uses Alter for a column
>>
>> my suggestion is use framework\entity\dbparms
>> folder and put in files that denote each db.
>> this way the code would be changed only by adding routine to look of the
>> db equivalent for Rename.
>>
>> any other Ideas.
>>
>
>
>
>
