You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by BJ Freeman <bj...@free-man.net> on 2008/07/16 17:30:28 UTC
Couple of DB issues
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
Re: Couple of DB issues
Posted by BJ Freeman <bj...@free-man.net>.
move this to dev list
BJ Freeman sent the following on 7/16/2008 11:28 AM:
> 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
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>
>
Re: Couple of DB issues
Posted by BJ Freeman <bj...@free-man.net>.
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
>>
>>
>>
>>
>
>
>
>
Re: Couple of DB issues
Posted by BJ Freeman <bj...@free-man.net>.
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
>
>
>
>