Re: SQL Error

Posted by Adrian Crum on
URL: http://ofbiz.116.s1.nabble.com/SQL-Error-tp145761p145763.html

David,

That fixed it. Thank you very much for the quick reply!


David E. Jones wrote:

>
> This is related to the MySQL issue that was reported recently.
>
> There was a bug in the entity engine causing certain settings on the  
> datasource element in the entityengine.xml file to be ignored. The  
> setting in the advantage config, and various others, that was being  
> ignored is the "alias-view-columns" attribute. That was set to true  and
> it looks like Advantage (like many other databases) does NOT  support
> aliased view columns, ie aliases for fields in joins.
>
> To fix this just change alias-view-columns=true to alias-view-
> columns=false. This is now changed in SVN.
>
> -David
>
>
> On Apr 18, 2007, at 3:10 PM, Adrian Crum wrote:
>
>> I'm trying to update my local copy of OFBiz to the latest SVN. Last  
>> version used was back in 2005. Now I'm getting SQL exceptions:
>>
>> SELECT PN.PARTY_ID AS TARGET_PARTY_ID, ND.NOTE_ID AS NOTE_ID,  
>> ND.NOTE_NAME AS NOTE_NAME, ND.NOTE_INFO AS NOTE_INFO,  
>> ND.NOTE_DATE_TIME AS NOTE_DATE_TIME, ND.NOTE_PARTY AS NOTE_PARTY  FROM
>> PARTY_NOTE PN INNER JOIN NOTE_DATA ND ON PN.NOTE_ID =  ND.NOTE_ID
>> WHERE (TARGET_PARTY_ID = ?) ORDER BY NOTE_DATE_TIME DESC  ([Extended
>> Systems][Advantage SQL Engine]Column not found:  TARGET_PARTY_ID --
>> Location of error in the SQL statement is: 259)
>>
>> Any idea what changed or what could be wrong?
>>
>