Merchant list not displaying saved merchants.....until you search for them

I have a merchant created. I went and made some orders with that merchant just fine. I returned to the merchant screen and didn't see any merchants listed. I tried refreshing to no avail. I then tried searching for my merchant in the merchant search field and lo and behold, the merchant popped back into the list. Merchants need to be listed all the time.

Here is a snippet from the tomcat log. (note the last few lines are from the search query, the rest is after I just clicked on the merchants tab)

2012-11-09 13:47:33,243-58656625 [http-8080-8] INFO org.apache.cxf.interceptor.LoggingInInterceptor - Inbound Message
----------------------------
ID: 39
Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/merchants
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11], x-tsa-authenticate=[CLOAF7Q4ZQAPFKLAYCNSZOJMJ7Y5VJQM2UBBHMACZIM4WRJLB6H4QQODX2BYZQFEX2MUCNV655X3LHF7BMBSEV5KWZLLREGOCD7JQI5ANVDDERCX4SBWOGTH4546LJY36P4PZT4LGTKSLR5YXCBA7IKDXOHCR24HOOWCFYMX5BCCHN2H634H336ZAL7QH34W]}

--------------------------------------
2012-11-09 13:47:33,243-58656625 [http-8080-8] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
2012-11-09 13:47:33,243-58656625 [http-8080-8] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: null
2012-11-09 13:47:33,243-58656625 [http-8080-8] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Using context from header: X-TSA-Authenticate
2012-11-09 13:47:33,243-58656625 [http-8080-8] DEBUG com.thesearchagency.security.TokenizedSecurityContext - Token:CLOAF7Q4ZQAPFKLAYCNSZOJMJ7Y5VJQM2UBBHMACZIM4WRJLB6H4QQODX2BYZQFEX2MUCNV655X3LHF7BMBSEV5KWZLLREGOCD7JQI5ANVDDERCX4SBWOGTH4546LJY36P4PZT4LGTKSLR5YXCBA7IKDXOHCR24HOOWCFYMX5BCCHN2H634H336ZAL7QH34W
2012-11-09 13:47:33,245-58656627 [http-8080-8] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 3737727321545471:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:

{realm=com.reseller1}) context to message
2012-11-09 13:47:33,247-58656629 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
2012-11-09 13:47:33,247-58656629 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 3737727321545471:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}

)
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.reseller1.properties is {}
2012-11-09 13:47:33,248-58656630 [http-8080-8] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String)
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Excuting getMerchants
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants
2012-11-09 13:47:33,248-58656630 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Getting connection for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2012-11-09 13:47:33,251-58656633 [http-8080-8] INFO jdbc.sqltiming - SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='273c4aab-e844-42d1-8c5a-2063ca535bba'

{executed in 0 msec}
2012-11-09 13:47:33,251-58656633 [http-8080-8] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba
2012-11-09 13:47:33,252-58656634 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U' {executed in 0 msec}

2012-11-09 13:47:33,253-58656635 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U'

{executed in 1 msec}
2012-11-09 13:47:33,254-58656636 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U' {executed in 0 msec}
2012-11-09 13:47:33,255-58656637 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id IN ('8a7ab076-822b-4053-9f7a-8fe4ddd9ff31') {executed in 0 msec}
2012-11-09 13:47:33,257-58656639 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}

2012-11-09 13:47:33,257-58656639 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R'

{executed in 0 msec}
2012-11-09 13:47:33,258-58656640 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 0 msec}

2012-11-09 13:47:33,259-58656641 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE groups.id IN ('2a6fd615-07c0-4420-b6e5-524ac0360ccf','4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59')

{executed in 1 msec}
2012-11-09 13:47:33,260-58656642 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G' {executed in 0 msec}
2012-11-09 13:47:33,261-58656643 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G' {executed in 0 msec}
2012-11-09 13:47:33,262-58656644 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G' {executed in 0 msec}
2012-11-09 13:47:33,263-58656645 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id IN ('8a7ab076-822b-4053-9f7a-8fe4ddd9ff31') {executed in 1 msec}

2012-11-09 13:47:33,264-58656646 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R'

{executed in 0 msec}
2012-11-09 13:47:33,265-58656647 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}
2012-11-09 13:47:33,266-58656648 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}
2012-11-09 13:47:33,267-58656649 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 1 msec}
2012-11-09 13:47:33,268-58656650 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 1 msec}
2012-11-09 13:47:33,268-58656650 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 0 msec}

2012-11-09 13:47:33,269-58656651 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id IN ('183219bc-0a71-4e4d-9232-dafc1fb09c1f')

{executed in 0 msec}
2012-11-09 13:47:33,270-58656652 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R' {executed in 0 msec}

2012-11-09 13:47:33,271-58656653 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R'

{executed in 1 msec}
2012-11-09 13:47:33,272-58656654 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R' {executed in 0 msec}
2012-11-09 13:47:33,272-58656654 [http-8080-8] INFO jdbc.sqltiming - SELECT permissions.name,permissions.active,permissions.data,permissions.description,permissions.type,permissions.created_by,permissions.created_on,permissions.realm_id,permissions.modified_on,permissions.id,permissions.modified_by
FROM permissions WHERE permissions.id IN ('b59fa344-7ae0-47ec-a5a3-dd8e51caac9d','04518081-0906-4c0e-8fb4-e279b50b4829')
{executed in 0 msec}
2012-11-09 13:47:33,273-58656655 [http-8080-8] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager - matching 'SAPI:execute:com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants'.matches('.:.:.*') -> true
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 3737727321545471:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1})
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.reseller1.properties is {}
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Getting all merchants for reseller
2012-11-09 13:47:33,274-58656656 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,275-58656657 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - Count objects using query sql:
SELECT COUNT AS TSA_COUNT_RESULT FROM roles WHERE (1 = 1) LIMIT 0 , 1024
2012-11-09 13:47:33,276-58656658 [http-8080-8] INFO jdbc.sqltiming - SELECT COUNT AS TSA_COUNT_RESULT FROM roles WHERE (1 = 1) LIMIT 0 , 1024 {executed in 1 msec}

2012-11-09 13:47:33,276-58656658 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - query: SELECT *
WHERE 1 = 1

2012-11-09 13:47:33,276-58656658 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - current 0 offset 0
2012-11-09 13:47:33,276-58656658 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - ret.size() == 0 desired 1024
2012-11-09 13:47:33,276-58656658 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - snarf data: ret.size() == 0 desired 1024
2012-11-09 13:47:33,277-58656659 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - Fetch objects using query sql:
SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display FROM roles WHERE (1 = 1) LIMIT 0 , 150
2012-11-09 13:47:33,277-58656659 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE (1 = 1) LIMIT 0 , 150

{executed in 0 msec}
2012-11-09 13:47:33,282-58656664 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - snarf data: ret.size() == 11 desired 1024
2012-11-09 13:47:33,283-58656665 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - Fetch objects using query sql:
SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display FROM roles WHERE (1 = 1) LIMIT 150 , 150
2012-11-09 13:47:33,284-58656666 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE (1 = 1) LIMIT 150 , 150 {executed in 1 msec}
2012-11-09 13:47:33,284-58656666 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,286-58656668 [http-8080-8] INFO jdbc.sqltiming - SELECT users.work_phone,users.type,users.modified_on,users.organization,users.password,users.modified_by,users.salt,users.last_name,users.home_phone,users.birthday,users.login,users.realm_id,users.timezone,users.first_name,users.country,users.mobile_phone,users.description,users.display,users.active,users.email,users.gender,users.homepage,users.created_by,users.created_on,users.id,users.language
FROM users WHERE users.id='273c4aab-e844-42d1-8c5a-2063ca535bba' {executed in 1 msec}
2012-11-09 13:47:33,286-58656668 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,288-58656670 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U' {executed in 0 msec}

2012-11-09 13:47:33,289-58656671 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G'

{executed in 1 msec}
2012-11-09 13:47:33,290-58656672 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 1 msec}

2012-11-09 13:47:33,290-58656672 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,292-58656674 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE groups.id='2a6fd615-07c0-4420-b6e5-524ac0360ccf'

{executed in 1 msec}
2012-11-09 13:47:33,292-58656674 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,294-58656676 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G' {executed in 1 msec}

2012-11-09 13:47:33,294-58656676 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R'

{executed in 0 msec}
2012-11-09 13:47:33,294-58656676 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,296-58656678 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31' {executed in 1 msec}
2012-11-09 13:47:33,296-58656678 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,298-58656680 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE groups.id='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59' {executed in 1 msec}
2012-11-09 13:47:33,298-58656680 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,300-58656682 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 1 msec}
2012-11-09 13:47:33,300-58656682 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R' {executed in 0 msec}

2012-11-09 13:47:33,301-58656683 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,302-58656684 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id='183219bc-0a71-4e4d-9232-dafc1fb09c1f'

{executed in 0 msec}
2012-11-09 13:47:33,303-58656685 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:47:33,305-58656687 [http-8080-8] INFO jdbc.sqltiming - SELECT `principal`, `type` from `assigned_members` WHERE `group`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
{executed in 1 msec}
2012-11-09 13:47:33,306-58656688 [http-8080-8] INFO org.apache.cxf.interceptor.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 39
Response-Code: 200
Content-Type: application/json
Headers: {Date=[Fri, 09 Nov 2012 13:47:33 GMT]}
Payload: {"total":0,"results":[]}
--------------------------------------
2012-11-09 13:49:47,081-58790463 [http-8080-8] INFO org.apache.cxf.interceptor.LoggingInInterceptor - Inbound Message
----------------------------
ID: 40
Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/merchants?q=SELECT%20WHERE%20(Name%20CONTAINS%20'%25m%25')%20OR%20(DisplayName%20CONTAINS%20'%25m%25')
Http-Method: GET
Content-Type:
Headers: {Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11], x-tsa-authenticate=[CLOAF7Q4ZQAPFKLAYCNSZOJMJ7Y5VJQM2UBBHMACZIM4WRJLB6H4QQODX2BYZQFEX2MUCNV655X3LHF7BMBSEV5KWZLLREGOCD7JQI5ANVDDERCX4SBWOGTH4546LJY36P4PZT4LGTKSLR5YXCBA7IKDXOHCR24HOOWCFYMX5BCCHN2H634H336ZAL7QH34W]}
--------------------------------------
2012-11-09 13:49:47,082-58790464 [http-8080-8] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
2012-11-09 13:49:47,082-58790464 [http-8080-8] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: q=SELECT%20WHERE%20(Name%20CONTAINS%20'%25m%25')%20OR%20(DisplayName%20CONTAINS%20'%25m%25')
2012-11-09 13:49:47,082-58790464 [http-8080-8] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Extracted parameters: {q=[SELECT%20WHERE%20(Name%20CONTAINS%20'%25m%25')%20OR%20(DisplayName%20CONTAINS%20'%25m%25')]}
2012-11-09 13:49:47,082-58790464 [http-8080-8] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Using context from header: X-TSA-Authenticate
2012-11-09 13:49:47,082-58790464 [http-8080-8] DEBUG com.thesearchagency.security.TokenizedSecurityContext - Token:CLOAF7Q4ZQAPFKLAYCNSZOJMJ7Y5VJQM2UBBHMACZIM4WRJLB6H4QQODX2BYZQFEX2MUCNV655X3LHF7BMBSEV5KWZLLREGOCD7JQI5ANVDDERCX4SBWOGTH4546LJY36P4PZT4LGTKSLR5YXCBA7IKDXOHCR24HOOWCFYMX5BCCHN2H634H336ZAL7QH34W
2012-11-09 13:49:47,084-58790466 [http-8080-8] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 3737727321545471:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message
2012-11-09 13:49:47,086-58790468 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
2012-11-09 13:49:47,086-58790468 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba
2012-11-09 13:49:47,086-58790468 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 3737727321545471:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1})
2012-11-09 13:49:47,086-58790468 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
2012-11-09 13:49:47,087-58790469 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1
2012-11-09 13:49:47,087-58790469 [http-8080-8] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.reseller1.properties is {}
2012-11-09 13:49:47,087-58790469 [http-8080-8] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
2012-11-09 13:49:47,087-58790469 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String)
2012-11-09 13:49:47,087-58790469 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Excuting getMerchants
2012-11-09 13:49:47,087-58790469 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants
2012-11-09 13:49:47,087-58790469 [http-8080-8] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Getting connection for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2012-11-09 13:49:47,197-58790579 [http-8080-8] INFO jdbc.sqltiming - SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='273c4aab-e844-42d1-8c5a-2063ca535bba'
{executed in 1 msec}
2012-11-09 13:49:47,197-58790579 [http-8080-8] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba
2012-11-09 13:49:47,198-58790580 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U' {executed in 1 msec}
2012-11-09 13:49:47,198-58790580 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U' {executed in 0 msec}

2012-11-09 13:49:47,199-58790581 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
AND `type`='U'

{executed in 0 msec}
2012-11-09 13:49:47,200-58790582 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id IN ('8a7ab076-822b-4053-9f7a-8fe4ddd9ff31') {executed in 0 msec}

2012-11-09 13:49:47,201-58790583 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R'

{executed in 0 msec}
2012-11-09 13:49:47,202-58790584 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}
2012-11-09 13:49:47,203-58790585 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}
2012-11-09 13:49:47,204-58790586 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE groups.id IN ('2a6fd615-07c0-4420-b6e5-524ac0360ccf','4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59')
{executed in 1 msec}
2012-11-09 13:49:47,205-58790587 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G' {executed in 0 msec}

2012-11-09 13:49:47,207-58790589 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G'

{executed in 2 msec}

2012-11-09 13:49:47,207-58790589 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
AND `type`='G'

{executed in 0 msec}
2012-11-09 13:49:47,208-58790590 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id IN ('8a7ab076-822b-4053-9f7a-8fe4ddd9ff31') {executed in 1 msec}
2012-11-09 13:49:47,209-58790591 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}
2012-11-09 13:49:47,210-58790592 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 1 msec}
2012-11-09 13:49:47,210-58790592 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
AND `type`='R' {executed in 0 msec}

2012-11-09 13:49:47,211-58790593 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G'

{executed in 1 msec}
2012-11-09 13:49:47,211-58790593 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 0 msec}
2012-11-09 13:49:47,212-58790594 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
AND `type`='G' {executed in 0 msec}
2012-11-09 13:49:47,214-58790596 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id IN ('183219bc-0a71-4e4d-9232-dafc1fb09c1f') {executed in 1 msec}

2012-11-09 13:49:47,215-58790597 [http-8080-8] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R'

{executed in 1 msec}
2012-11-09 13:49:47,215-58790597 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R' {executed in 0 msec}
2012-11-09 13:49:47,216-58790598 [http-8080-8] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
AND `type`='R' {executed in 0 msec}
2012-11-09 13:49:47,217-58790599 [http-8080-8] INFO jdbc.sqltiming - SELECT permissions.name,permissions.active,permissions.data,permissions.description,permissions.type,permissions.created_by,permissions.created_on,permissions.realm_id,permissions.modified_on,permissions.id,permissions.modified_by
FROM permissions WHERE permissions.id IN ('b59fa344-7ae0-47ec-a5a3-dd8e51caac9d','04518081-0906-4c0e-8fb4-e279b50b4829')
{executed in 1 msec}

2012-11-09 13:49:47,218-58790600 [http-8080-8] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager - matching 'SAPI:execute:com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants'.matches('.:.:.*') -> true
2012-11-09 13:49:47,218-58790600 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
2012-11-09 13:49:47,218-58790600 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba
2012-11-09 13:49:47,218-58790600 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 3737727321545471:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:

{realm=com.reseller1}

)
2012-11-09 13:49:47,218-58790600 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
2012-11-09 13:49:47,218-58790600 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1
2012-11-09 13:49:47,218-58790600 [http-8080-8] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.reseller1.properties is {}
2012-11-09 13:49:47,219-58790601 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:49:47,222-58790604 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - Count objects using query sql:
SELECT COUNT AS TSA_COUNT_RESULT FROM groups WHERE ((groups.name LIKE '%m%') OR ((groups.display LIKE '%m%') AND (groups.realm_id = 'com.reseller1'))) LIMIT 0 , 1024
2012-11-09 13:49:47,222-58790604 [http-8080-8] INFO jdbc.sqltiming - SELECT COUNT AS TSA_COUNT_RESULT FROM groups WHERE ((groups.name LIKE '%m%') OR ((groups.display
LIKE '%m%') AND (groups.realm_id = 'com.reseller1'))) LIMIT 0 , 1024

{executed in 0 msec}
2012-11-09 13:49:47,223-58790605 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - query: SELECT *
WHERE (Name contains '%m%') OR ((DisplayName contains '%m%') AND (Realm = 'com.reseller1'))

2012-11-09 13:49:47,223-58790605 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - current 0 offset 0
2012-11-09 13:49:47,224-58790606 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - ret.size() == 0 desired 1024
2012-11-09 13:49:47,224-58790606 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - snarf data: ret.size() == 0 desired 1024
2012-11-09 13:49:47,224-58790606 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - Fetch objects using query sql:
SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display FROM groups WHERE ((groups.name LIKE '%m%') OR ((groups.display LIKE '%m%') AND (groups.realm_id = 'com.reseller1'))) LIMIT 0 , 150
2012-11-09 13:49:47,225-58790607 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE ((groups.name LIKE '%m%') OR ((groups.display LIKE '%m%') AND (groups.realm_id
= 'com.reseller1'))) LIMIT 0 , 150 {executed in 1 msec}
2012-11-09 13:49:47,226-58790608 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - snarf data: ret.size() == 4 desired 1024
2012-11-09 13:49:47,226-58790608 [http-8080-8] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager - Fetch objects using query sql:
SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display FROM groups WHERE ((groups.name LIKE '%m%') OR ((groups.display LIKE '%m%') AND (groups.realm_id = 'com.reseller1'))) LIMIT 150 , 150
2012-11-09 13:49:47,227-58790609 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE ((groups.name LIKE '%m%') OR ((groups.display LIKE '%m%') AND (groups.realm_id
= 'com.reseller1'))) LIMIT 150 , 150 {executed in 1 msec}
2012-11-09 13:49:47,227-58790609 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:49:47,229-58790611 [http-8080-8] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='149d5274-2a25-45cc-872d-c11279009657'
AND `type`='G' {executed in 0 msec}

2012-11-09 13:49:47,229-58790611 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:49:47,230-58790612 [http-8080-8] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
FROM roles WHERE roles.id='2c7ac5ab-aacf-42fe-8256-436b2c0efe1c'

{executed in 0 msec}

2012-11-09 13:49:47,231-58790613 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:49:47,232-58790614 [http-8080-8] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
FROM groups WHERE groups.id='149d5274-2a25-45cc-872d-c11279009657'

{executed in 1 msec}
2012-11-09 13:49:47,232-58790614 [http-8080-8] DEBUG com.thesearchagency.saas.core.services.content.internal.ContentServiceComponent - Attempting to locate content in com.reseller1 using the id '149d5274-2a25-45cc-872d-c11279009657'
2012-11-09 13:49:47,250-58790632 [http-8080-8] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao - Attempting to find '149d5274-2a25-45cc-872d-c11279009657' in 'com.reseller1'.
2012-11-09 13:49:47,252-58790634 [http-8080-8] INFO jdbc.sqltiming - select persistent0_.`id` as id1_0_1_, persistent0_.`realm_id` as realm2_0_1_, persistent0_.`created_on`
as created3_0_1_, persistent0_.`created_by` as created4_0_1_, persistent0_.`deleted_at` as
deleted5_0_1_, persistent0_.`last_modified_on` as last6_0_1_, persistent0_.`last_modified_by`
as last7_0_1_, persistent0_.name as name0_1_, persistent0_.`parent_id` as parent9_0_1_, persistent0_.`version`
as version10_0_1_, persistent0_.type as type0_1_, persistent0_.value as value0_1_, thechildre1_.`parent_id`
as parent9_0_3_, thechildre1_.`realm_id` as realm2_0_3_, thechildre1_.`id` as id1_3_, thechildre1_.`realm_id`
as realm2_3_, thechildre1_.`id` as id1_0_0_, thechildre1_.`realm_id` as realm2_0_0_, thechildre1_.`created_on`
as created3_0_0_, thechildre1_.`created_by` as created4_0_0_, thechildre1_.`deleted_at` as
deleted5_0_0_, thechildre1_.`last_modified_on` as last6_0_0_, thechildre1_.`last_modified_by`
as last7_0_0_, thechildre1_.name as name0_0_, thechildre1_.`parent_id` as parent9_0_0_, thechildre1_.`version`
as version10_0_0_, thechildre1_.type as type0_0_, thechildre1_.value as value0_0_, themetadat2_.`content_id`
as content1_0_4_, themetadat2_.`realm_id` as realm2_0_4_, themetadat2_.`value` as value3_4_,
themetadat2_.`key` as key4_4_ from content persistent0_ left outer join content thechildre1_
on persistent0_.`id`=thechildre1_.`parent_id` and persistent0_.`realm_id`=thechildre1_.`realm_id`
and ( thechildre1_.`deleted_at` IS NULL) left outer join `content_metadata` themetadat2_ on
thechildre1_.`id`=themetadat2_.`content_id` and thechildre1_.`realm_id`=themetadat2_.`realm_id`
where persistent0_.`id`='149d5274-2a25-45cc-872d-c11279009657' and persistent0_.`realm_id`='com.reseller1'
and ( persistent0_.`deleted_at` IS NULL) {executed in 1 msec}

2012-11-09 13:49:47,254-58790636 [http-8080-8] INFO jdbc.sqltiming - select themetadat0_.`content_id` as content1_0_0_, themetadat0_.`realm_id` as realm2_0_0_,
themetadat0_.`value` as value3_0_, themetadat0_.`key` as key4_0_ from `content_metadata` themetadat0_
where themetadat0_.`content_id`='149d5274-2a25-45cc-872d-c11279009657' and themetadat0_.`realm_id`='com.reseller1'

{executed in 1 msec}
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.saas.core.services.content.internal.ContentServiceComponent - Found content by ID 149d5274-2a25-45cc-872d-c11279009657? true!
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Retrieving properties
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Retrieving properties from content service: resellerAssignedId = ID
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Retrieving properties from content service: email = ted@merchant.com
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Retrieving properties from content service: contact name = ted merchant
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Retrieving properties from content service: phone = 123123123213213
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService - Retrieving properties from content service: comments =
2012-11-09 13:49:47,257-58790639 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:49:47,259-58790641 [http-8080-8] INFO jdbc.sqltiming - SELECT users.work_phone,users.type,users.modified_on,users.organization,users.password,users.modified_by,users.salt,users.last_name,users.home_phone,users.birthday,users.login,users.realm_id,users.timezone,users.first_name,users.country,users.mobile_phone,users.description,users.display,users.active,users.email,users.gender,users.homepage,users.created_by,users.created_on,users.id,users.language
FROM users WHERE users.id='273c4aab-e844-42d1-8c5a-2063ca535bba' {executed in 1 msec}

2012-11-09 13:49:47,259-58790641 [http-8080-8] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting connection for com_thesearchagency_saas_core_services_user_managers_UserManager
2012-11-09 13:49:47,261-58790643 [http-8080-8] INFO jdbc.sqltiming - SELECT users.work_phone,users.type,users.modified_on,users.organization,users.password,users.modified_by,users.salt,users.last_name,users.home_phone,users.birthday,users.login,users.realm_id,users.timezone,users.first_name,users.country,users.mobile_phone,users.description,users.display,users.active,users.email,users.gender,users.homepage,users.created_by,users.created_on,users.id,users.language
FROM users WHERE users.id='273c4aab-e844-42d1-8c5a-2063ca535bba'

{executed in 1 msec}

2012-11-09 13:49:47,263-58790645 [http-8080-8] INFO org.apache.cxf.interceptor.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 40
Response-Code: 200
Content-Type: application/json
Headers:

{Date=[Fri, 09 Nov 2012 13:49:47 GMT]}

Payload: {"total":1,"results":[

{"name":"ID","id":"149d5274-2a25-45cc-872d-c11279009657","displayName":"merchant","description":"","realm":"com.reseller1","lastModifiedDate":"2012-11-08T22:06:30.000+0000","active":true,"email":"ted@merchant.com","resellerAssignedId":"ID","phone":"123123123213213","createdBy":"273c4aab-e844-42d1-8c5a-2063ca535bba","createdDate":"2012-11-08T22:06:30.000+0000","lastModifiedBy":"273c4aab-e844-42d1-8c5a-2063ca535bba","comments":"","contactName":"ted merchant","createdByName":"Reseller1 admin user","lastModifiedByName":"Reseller1 admin user"}

]}
--------------------------------------