In 《ApacheOFBizDevelopmentTheBeginnersTutorial.pdf》page 204 ,section Seeing the
SQL Equivalent
I found :
All underlying queries and communications to the database can be obtained by
accessing the main Webtools page and selecting Adjust Debugging Levels,
ticking
the Verbose checkbox, and clicking OK. This change will only last the duration
of this session. To make the change permanent, edit the debug.properties file
in
${OFBizInstallFolder}\framework\base\config and set print.verbose=true.
OFBiz produces the following Query:
SELECT HotelGuest.FIRST_NAME, HotelGuest.LAST_NAME, Hotel.HOTEL_NAME,
HotelOwner.FIRST_NAME, HotelOwner.LAST_NAME FROM
(OFBIZ.PERSON_L HotelGuest INNER JOIN OFBIZ.HOTEL_L Hotel ON
HotelGuest.HOUSED_AT = Hotel.HOTEL_ID)
INNER JOIN OFBIZ.PERSON_L HotelOwner ON Hotel.OWNED_BY =
HotelOwner.PERSON_ID
i do set print.verbose=true but i cannt see the sql still.
who can help me?
thanks
