Re: SQL Error

Posted by David E Jones on
URL: http://ofbiz.116.s1.nabble.com/SQL-Error-tp145761p145762.html


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?
>