Develop > Business logic layer > Work with the data service layer > Create a query


Trace queries and query parameters

You can use the WebSphere Application Server administrative console to trace queries serviced by the data service layer. You can also enable tracing for query parameters.


Procedure

  1. To trace the data service layer SELECT queries:

    1. Set the log level setting to 'fine' for the com.ibm.commerce.foundation.server.services.dataaccess component in the WebSphere Application Server Administrative console, following the steps in Enabling trace at server startup in the WebSphere Application Server information center.

      To trace the UPDATE and INSERT queries, set the log level setting to 'all' for all classes under component com.ibm.ws.sdo.mediator.jdbc (com.ibm.ws.sdo.mediator.jdbc*=all). Restart the server after enabling this trace.

    2. The query name, SQL statement and the template file where the query is defined is displayed in the trace. An example of a trace entry is shown in the following sample:

      getGraph(DMSQueryData) Query name: 
      
      /CatalogEntry[CatalogEntryDisplayPageName[(UniqueId=)]]+IBM_CatalogEntryDisplayPage_Get
      [1/31/08 15:08:11:234 EST] 00000034 jdbc 1 com.ibm.commerce.foundation.internal.server.services.dataaccess.graphbuilderservice.jdbc.JDBCMediatorSupplyQuery 
      
      getGraph(DMSQueryData) SQL query: SELECT DISPENTREL.CATENTRY_ID, DISPENTREL.DISPENTREL_ID, DISPENTREL.LANGUAGE_ID, DISPENTREL.DEVICEFMT_ID, DISPENTREL.STOREENT_ID, DISPENTREL.PAGENAME, DISPENTREL.CATENTTYPE_ID, DISPENTREL.AUCTIONSTATE, DISPENTREL.MBRGRP_ID, DISPENTREL.DESCRIPTION, DISPENTREL.FIELD1, DISPENTREL.RANK, DISPENTREL.FIELD2, DISPENTREL.OID, DISPENTREL.OPTCOUNTER FROM DISPENTREL WHERE DISPENTREL.CATENTRY_ID in (?, ?, ?, ?, ?, ?) OR DISPENTREL.CATENTRY_ID =0 AND DISPENTREL.STOREENT_ID IN ( ? ) [ '10651' '10655' '10660' '10665' '10670' '10675' '10702' ]
      [1/31/08 15:08:11:234 EST] 00000034 jdbc 1 
      com.ibm.commerce.foundation.internal.server.services.dataaccess.graphbuilderservice.jdbc.JDBCMediatorSupplyQuery getGraph(DMSQueryData) Template file: D:\WCToolkitEE60\xml\config\com.ibm.commerce.catalog\wc-query-CatalogEntry-admin-get.tpl 
      

  2. To trace query parameters:

    1. Open the wc-attribute-masking.xml file:

      • WC_EAR/xml/config/wc-attribute-masking.xml

      • workspace_dir/wc/xml/config/wc-attribute-masking.xml

    2. Find the following line:

      <wc:MaskedAttribute name="extendedDataValue" compareType="starts" />
      

    3. Replace it with the following line, which simply comments the line out by adding <!-- and --> blocks around it:

      <!--
      <wc:MaskedAttribute name="extendedDataValue" compareType="starts" /> -->
      

    4. Restart the server.


+

Search Tips   |   Advanced Search