hi, I am a freshman of ofbiz I want see the query ofbiz produced,but i dnot know how to do that.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

hi, I am a freshman of ofbiz I want see the query ofbiz produced,but i dnot know how to do that.

于向军
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
Reply | Threaded
Open this post in threaded view
|

Re: hi, I am a freshman of ofbiz I want see the query ofbiz produced,but i dnot know how to do that.

Jacques Le Roux
Administrator
I wonder if this was working with R4.0 and is not anymore. Could you try the same with the R4.0?
http://svn.apache.org/repos/asf/ofbiz/branches/release4.0

Thanks

Jacques

From: "于向军" <[hidden email]>
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