Enable wcs sql query trace log

-
com.ibm.ws.rsadapter.jdbc.WSJdbcCallableStatement=finer:
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement=finer:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement=finer:
com.ibm.ws.rsadapter.jdbc.WSJccCallableStatement=finer:
com.ibm.ws.rsadapter.jdbc.WSJccStatement=finer:
com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement=finer

Comments

Post a Comment

Popular posts from this blog

Merging / Migrating / Combining User Session Data (Cart Merge while User Logon in Websphere Commerce)

-
Cart Merge while User Logon in Websphere Commerce MigrateUserEntriesCmdImpl MigrateUserEntriesCmd will not do merge. It just migrates guest user details to current logged in user. We will have to use OrderItemMoveCmd for merge. OrderitemMoveCmd can only merge different orders of same customer only. That’s the reason we call MigrateUserEntriesCmd from LogonCmd first, followed by OrderItemMoveCmd. Consider the below order flow. Register a new user "testuser" in the site and logout before adding any items to cart.Come back to the site as a guest user.Add an item to cart .During checkout   try to login as "testuser" registered before.Order\OrderItems memberId will be changed from guest to that of registered user. There willn't be any order left for the Guest user.This can be achived with the help of MigrateUserEntriesCmdImpl . This task command is used to migrate resources owned by one user to another. The mandatory resources that are migrated are Address...
Read more

Calculation Framework in Websphere Commerce.

-
  OrderCalculateCmd OrderCalculateCmd invokes the Promotion engine. PromotionEngineOrderCalculateCmdImpl implements OrderCalculateCmd class. OrderCalculateCmd is invoked when we add, delete, update or merge item/s in cart. This command calculates the order  total based on the sequence in which calculationUsageId is passed into the command. WebSphere Commerce provides the below predefined calculation usages: Calusage_id    Description -1                         Discount -2                         Shipping -3                         Sales Tax -4          ...
Read more

Websphere Commerce Catalog Subsystem

-
  Websphere Commerce Catalog Subsystem The Catalog Subsystem contains all logic and data relevant to an online catalog, including catalog groups (or categories), catalog entries, and any associations or relationships among them.    Master Catalog It is the single catalog that contains all products, items, relationships, and standard prices for everything that is for sale in your store. Every store in the Web Sphere Commerce system must have a master catalog. It is possible to share the master catalog across stores. Master Catalog Restrictions 1)The master catalog must be a proper tree, which means that there are no cycles. e.g.The parent category "Women" has a subcategory "WomenDress". It is important that WomenDress and any of WomenDress's subcategories like tops,jeans etc are not the parent category of "Women" category. 2)A catalog entry or category cannot belong to multiple parent categories in the master...
Read more