[
https://issues.apache.org/jira/browse/OFBIZ-1321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533475
]
Adam Heath commented on OFBIZ-1321:
-----------------------------------
582338 works fine for me. I took the line you pasted from the code, ran it,
then looked at the generated sql from the postgresql.log, and got this:
==
2007-10-09 14:53:41 CDT LOG: statement: SELECT PN.PARTY_ID AS TARGET_PARTY_ID,
ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME, ND.NOTE_INF
O AS NOTE_INFO, ND.NOTE_DATE_TIME AS NOTE_DATE_TIME, ND.NOTE_PARTY AS
NOTE_PARTY FROM public.PARTY_NOTE PN INNER JOIN public.NOTE_DATA ND ON
PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = 1234) ORDER BY NOTE_DATE_TIME DESC;
==
Do you have local changes? There are no changes from 582338 to HEAD that touch
the code that generates these queries.
Also, please give the exact svn version you were running before, *and* after.
And run svn status to see if you have local changes. And do ant clean/ant at
the top level.
> SQL creation has changed format in ver 4.0
> ------------------------------------------
>
> Key: OFBIZ-1321
> URL: https://issues.apache.org/jira/browse/OFBIZ-1321
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 4.0
> Reporter: BJ Freeman
> Assignee: David E. Jones
> Fix For: Release Branch 4.0
>
>
> I update from the latest 4.0 release
> all of a suddent the SQL has under scores where it did not before.
> example
> viewprofile.bsh
> Method Invocation delegator.findByAnd : at Line: 86 : in file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh :
> delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap ( "targetPartyId" ,
> partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> now produces
> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following: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
> public.PARTY_NOTE PN INNER JOIN public.NOTE_DATA ND ON PN.NOTE_ID =
> ND.NOTE_ID WHERE (TARGET_PARTY_ID = ?) ORDER BY NOTE_DATE_TIME DESC (ERROR:
> column "target_party_id" does not exist)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
