API tools faq
paste
Guest User

Untitled

a guest
May 22nd, 2018
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 48.59 KB | None | 0 0
raw download clone embed print report
  1. 2012-01-13 17:13:29,750 INFO hibernate.ejb.Ejb3Configuration:523 -> Processing PersistenceUnitInfo [
  2. name: wrsPU
  3. ...]
  4. 2012-01-13 17:13:30,093 INFO hibernate.cfg.Configuration:845 -> Mapping package com.sec.wrs.dbaccess.bean
  5. 2012-01-13 17:13:30,109 INFO hibernate.cfg.AnnotationBinder:1330 -> Binding type definition: zzz
  6. 2012-01-13 17:13:30,109 INFO hibernate.cfg.AnnotationBinder:1334 -> Binding type definition: org.hibernate.type.EnumType
  7. 2012-01-13 17:13:30,109 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopServiceLevel
  8. 2012-01-13 17:13:30,109 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopServiceLevel on table shop_service_level
  9. 2012-01-13 17:13:30,125 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ZipCodeContainer
  10. 2012-01-13 17:13:30,125 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ZipCodeContainer on table zip_code_container
  11. 2012-01-13 17:13:30,140 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.HairStylist
  12. 2012-01-13 17:13:30,140 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: HairStylist.getByShopId => select hs from HairStylist hs where hs.shop.id = :shopId
  13. 2012-01-13 17:13:30,140 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: HairStylist.getEnabledByShopId => select hs from HairStylist hs where hs.enabled = true and hs.shop.id = :shopId
  14. 2012-01-13 17:13:30,140 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: HairStylist.getEnabledByStyleId => select hs from HairStylist hs, HairStylist2HairStyle ss where hs.enabled = true and hs.id = ss.stylist.id and ss.style.id = :styleId
  15. 2012-01-13 17:13:30,140 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.HairStylist on table hair_stylist
  16. 2012-01-13 17:13:30,140 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRole
  17. 2012-01-13 17:13:30,140 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.UserRole on table user_role
  18. 2012-01-13 17:13:30,140 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleAgent
  19. 2012-01-13 17:13:30,140 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findUserRoleAgentsByIds => from UserRoleAgent where id in (:id)
  20. 2012-01-13 17:13:30,140 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Email
  21. 2012-01-13 17:13:30,140 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Email.findByApplication => select em from Email em where em.application = :application
  22. 2012-01-13 17:13:30,140 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Email on table email
  23. 2012-01-13 17:13:30,156 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.AgentCategory
  24. 2012-01-13 17:13:30,156 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.AgentCategory on table agent_category
  25. 2012-01-13 17:13:30,156 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ZipCode
  26. 2012-01-13 17:13:30,156 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ZipCodeDao.getByZip => from ZipCode where name = :name
  27. 2012-01-13 17:13:30,156 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ZipCodeDao.getStartingWith => from ZipCode where name like concat(:name, '%')
  28. 2012-01-13 17:13:30,156 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ZipCodeDao.getByZipCodeContainer => select zc from ZipCode zc inner join zc.zipCodeContainers zcc where zcc = :ZipCodeContainer
  29. 2012-01-13 17:13:30,156 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ZipCodeDao.getForGeocoding => from ZipCode where enabled = true and (longitude is null or latitude is null)
  30. 2012-01-13 17:13:30,156 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ZipCode.getByIds => select z from ZipCode z where z.id in (:ids)
  31. 2012-01-13 17:13:30,156 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ZipCode on table zip_code
  32. 2012-01-13 17:13:30,171 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserAccountRegData
  33. 2012-01-13 17:13:30,171 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: userAccountRegData.findRegDataByLogin => select reg from UserAccountRegData reg where reg.login = :login
  34. 2012-01-13 17:13:30,171 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.UserAccountRegData on table user_account_reg_data
  35. 2012-01-13 17:13:30,171 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.FileContent
  36. 2012-01-13 17:13:30,171 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.FileContent on table file_content
  37. 2012-01-13 17:13:30,171 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.Invitation
  38. 2012-01-13 17:13:30,171 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Invitation.getByEmail => select i from Invitation i where i.email = :email
  39. 2012-01-13 17:13:30,171 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Invitation.findByMessageCode => select i from Invitation i where i.msgCode = :messageCode
  40. 2012-01-13 17:13:30,171 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Invitation.findByInvited => select i from Invitation i where i.invitedUserRole.userAccount.id = :invitedId
  41. 2012-01-13 17:13:30,171 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Invitation.findInvitedByInviter => select i from Invitation i where i.invitedUserRole is not null and i.inviterUserRole.userAccount.id = :inviterId
  42. 2012-01-13 17:13:30,187 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Invitation.findAllByInviter => select i from Invitation i where i.inviterUserRole.userAccount.id = :inviterId
  43. 2012-01-13 17:13:30,187 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.invitation.Invitation on table invitation
  44. 2012-01-13 17:13:30,187 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.WhatsNew
  45. 2012-01-13 17:13:30,187 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findWhatsNewMostPopular => select whatsNew from WhatsNew whatsNew order by date desc
  46. 2012-01-13 17:13:30,187 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: WhatsNew.getByIds => select w from WhatsNew w where w.id in (:ids)
  47. 2012-01-13 17:13:30,187 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.WhatsNew on table whats_new
  48. 2012-01-13 17:13:30,187 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopMetadata
  49. 2012-01-13 17:13:30,187 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findShopMetadataByShop => from ShopMetadata where shopId = :shopId
  50. 2012-01-13 17:13:30,187 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopMetadata on table shop_metadata
  51. 2012-01-13 17:13:30,203 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Server
  52. 2012-01-13 17:13:30,203 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ServerDao.getByIdentity => select s from Server s where identity = :identity
  53. 2012-01-13 17:13:30,203 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Server on table server
  54. 2012-01-13 17:13:30,203 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleAdmin
  55. 2012-01-13 17:13:30,203 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.CityArea
  56. 2012-01-13 17:13:30,203 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityAreaDao.getByCity => select ca from CityArea ca where ca.cityId = :cityId
  57. 2012-01-13 17:13:30,203 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityAreaDao.getByCityAndName => select ca from CityArea ca where ca.cityId = :cityId and ca.name = :name
  58. 2012-01-13 17:13:30,203 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityAreaDao.getAllFull => select distinct c.id, c.name, ca.name, cc.id, cc.areaName, cc.prefectureName, ccp.name from CityArea ca join ca.city c left join c.cityContainer cc left join cc.prefecture ccp
  59. 2012-01-13 17:13:30,203 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityArea.getByIds => select ca from CityArea ca where ca.id in (:ids)
  60. 2012-01-13 17:13:30,203 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.CityArea on table city_area
  61. 2012-01-13 17:13:30,203 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.GlobalProperty
  62. 2012-01-13 17:13:30,203 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: globalProperty.findAll => from GlobalProperty
  63. 2012-01-13 17:13:30,218 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: globalProperty.findByCode => from GlobalProperty where code = ?
  64. 2012-01-13 17:13:30,218 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.GlobalProperty on table global_property
  65. 2012-01-13 17:13:30,218 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Region
  66. 2012-01-13 17:13:30,218 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findRegionByName => from Region where name = :name
  67. 2012-01-13 17:13:30,218 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Region.getByIds => select r from Region r where r.id in (:ids)
  68. 2012-01-13 17:13:30,218 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Region on table region
  69. 2012-01-13 17:13:30,218 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.HairStyle
  70. 2012-01-13 17:13:30,218 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: HairStyle.getByShopId => select hs from HairStyle hs where hs.shop.id = :shopId
  71. 2012-01-13 17:13:30,218 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.HairStyle on table hair_style
  72. 2012-01-13 17:13:30,218 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.LostPasswordChangeRequest
  73. 2012-01-13 17:13:30,218 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: LostPasswordChangeRequest.getBySecretCode => from LostPasswordChangeRequest where secretCode = :secretCode
  74. 2012-01-13 17:13:30,234 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.LostPasswordChangeRequest on table lost_password_change_request
  75. 2012-01-13 17:13:30,234 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleCompany
  76. 2012-01-13 17:13:30,234 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.FinancialOperation
  77. 2012-01-13 17:13:30,234 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: activeByOperation => select operation from FinancialOperation operation where operation.operationCode = :opId and operation.cosignatoryId = :csId and operation.status <> 2
  78. 2012-01-13 17:13:30,234 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: performedByCosignatoryWithDate => select operation from FinancialOperation operation where operation.date <= :date and operation.cosignatoryId = :csId and operation.status = 0
  79. 2012-01-13 17:13:30,234 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.FinancialOperation on table financial_operation
  80. 2012-01-13 17:13:30,234 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.TariffPlan
  81. 2012-01-13 17:13:30,234 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findTariffPlansByCode => select e from TariffPlan e where code = :code
  82. 2012-01-13 17:13:30,234 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.TariffPlan on table tariff_plan
  83. 2012-01-13 17:13:30,250 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.CityContainer
  84. 2012-01-13 17:13:30,250 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.CityContainer on table city_container
  85. 2012-01-13 17:13:30,250 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopCategory
  86. 2012-01-13 17:13:30,250 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopCategory.findShopCategoryByAlias => from ShopCategory where alias = :alias
  87. 2012-01-13 17:13:30,250 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopCategory.getByIds => select sc from ShopCategory sc where sc.id in (:ids)
  88. 2012-01-13 17:13:30,250 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopCategory on table shop_category
  89. 2012-01-13 17:13:30,250 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopUserCategory
  90. 2012-01-13 17:13:30,250 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopUserCategory on table shop_user_category
  91. 2012-01-13 17:13:30,250 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Shop
  92. 2012-01-13 17:13:30,250 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.getTObyId => SELECT sh FROM Shop sh left join fetch sh.prefecture WHERE sh.id in ( :id)
  93. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.countAllTO => SELECT COUNT(*) FROM Shop sh
  94. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.getAllTO => SELECT sh FROM Shop sh left join fetch sh.prefecture
  95. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopDao.getActiveShopsForCloudTags => SELECT sh FROM Shop sh left join fetch sh.prefecture where sh.company.enabled = true and sh.published = true and sh.enabled = true order by sh.id
  96. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: getByUserRoleShop => SELECT sh FROM Shop sh left join fetch sh.prefecture inner join sh.userRoleShops as urs where urs = :UserRoleShop
  97. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopDao.getByIds => select sh from Shop sh where sh.id in (:id)
  98. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findShopsByEmail => from Shop where emailTo = :emailTo
  99. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findMostPopular => select shop from Shop shop where shop.company.enabled = true and shop.prefecture is not null and shop.displayName is not null and shop.buildingName is not null and shop.company.name is not null and shop.slogan is not null and shop.cityName is not null and shop.address is not null and shop.phone is not null and exists (select staff from Staff staff where staff.shopId=shop.id) order by shop.id
  100. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopDao.getByPrefectureArea => select s from Shop s, City c where s.cityName = c.name and c.cityContainer = :PrefectureArea
  101. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.getOtherInPrefecture => select s from Shop s where s.cityName not in (select c.name from City c, PrefectureArea a where c.cityContainer = :prefecture or (c.cityContainer = a and a.prefecture = :prefecture))
  102. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopDao.getByCity => select shop from Shop shop, City c where shop.company.enabled = true and c.name=shop.cityName and c = :City
  103. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findShopByRegionAlias => select shop from Shop shop where shop.prefecture.region.alias like :alias and shop.company.enabled = true
  104. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findShopByQuery => select s from Shop s where s.company.enabled = true and (s.displayName like :q or s.prefecture.name like :q or s.cityName like :q or s.address like :q or s.phone like :phoneQ)
  105. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findShopByQueryNoPhone => select s from Shop s where s.company.enabled = true and (s.displayName like :q or s.prefecture.name like :q or s.cityName like :q or s.address like :q)
  106. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findWithAdBlocks => select s from Shop s left join fetch s.adBlocks ads left join fetch ads.picture.content where s.id = :id
  107. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findWithUser => select s from Shop s inner join s.userRoleShops as urs
  108. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: countWithUser => select count(*) from Shop s inner join s.userRoleShops as usr
  109. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: getIdsByShopNameCompanyId => select s.id from Shop s where displayName = :name and company.id = :companyId
  110. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findByShopNameCompanyId => from Shop where displayName = :name and company.id = :companyId
  111. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopDao.getByShopService => select s from Shop s inner join s.services as ss where ss = :services
  112. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: getServicesByShop => select ser from Shop s inner join s.services as ser where s.id = :id
  113. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findActiveServicesByShop => select s.services from Shop s inner join s.services ser where s.id = :shopId and ser.enabled = 1
  114. 2012-01-13 17:13:30,265 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.findShopWithMap => select s from Shop s where latitude is not null and longitude is not null
  115. 2012-01-13 17:13:30,281 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.getOtherByPrefectureId => select s from Shop s where s.prefecture.id =:prefId and not exists (select c.name from City c where c.name = s.cityName)
  116. 2012-01-13 17:13:30,281 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.getByPrefectureId => select s from Shop s where s.prefecture.id =:prefId
  117. 2012-01-13 17:13:30,281 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.getByPrefIdAndPrefAreaId => select s from Shop s, City c where s.prefecture.id = :prefId and s.cityName = c.name and c.cityContainer.id in (:pref_areaIds)
  118. 2012-01-13 17:13:30,281 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.findByCompany => select sh from Shop sh where sh.company.id = :company
  119. 2012-01-13 17:13:30,281 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Shop.findByAgent => select sh from Shop sh join sh.company cmp where cmp.id in (select c.id from InvitationUserRoleCompany i join i.company c where i.invitedUserRole is not null and i.path like :path )
  120. 2012-01-13 17:13:30,281 INFO cfg.annotations.QueryBinder:202 -> Binding named native query: Shop.getByMapDistance => select * from shop s where map_enabled and (|/((s.latitude - :lat)^2 + (s.longitude - :lon)^2) <= :distance)
  121. 2012-01-13 17:13:30,281 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Shop on table shop
  122. 2012-01-13 17:13:30,296 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleShop
  123. 2012-01-13 17:13:30,296 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.AreaMaster
  124. 2012-01-13 17:13:30,296 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.AreaMaster on table area_master_temp
  125. 2012-01-13 17:13:30,296 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationUserRolePr
  126. 2012-01-13 17:13:30,296 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationUserRoleWeb
  127. 2012-01-13 17:13:30,296 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Tariff
  128. 2012-01-13 17:13:30,296 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findTariffByPlanAndCode => select e from Tariff e where tariffPlanId = :tariffPlanId and operationCode = :operationCode
  129. 2012-01-13 17:13:30,296 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Tariff on table tariff
  130. 2012-01-13 17:13:30,312 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserAccount
  131. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.findByLogin => from UserAccount where username = :login
  132. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.findByLoginNoCase => from UserAccount where UPPER(username) = :login
  133. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.findByRole => select ua from UserAccount ua, UserRole ur where ua.userRole = ur
  134. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.findByRoleAndPath => select ua from Invitation i join i.invitedUserRole ur join ur.userAccount ua where i.path like :path
  135. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.getByEmailTo => select ua from UserAccount ua where ua.emailTo = :emailTo
  136. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.getByCredentials => select ua from UserAccount ua where lower(username) = :username and password = :password
  137. 2012-01-13 17:13:30,312 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: UserAccount.countByUsername => select count(ua) from UserAccount ua where lower(username) = :username
  138. 2012-01-13 17:13:30,312 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.UserAccount on table user_account
  139. 2012-01-13 17:13:30,328 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationUserRoleBlog
  140. 2012-01-13 17:13:30,328 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Bill
  141. 2012-01-13 17:13:30,328 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findBillsBySubmitFile => select e from Bill e where submitFile = :submitFile
  142. 2012-01-13 17:13:30,328 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Bill on table bill
  143. 2012-01-13 17:13:30,328 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.AdBlock
  144. 2012-01-13 17:13:30,328 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: AdBlock.getByIds => select ab from AdBlock ab where ab.id in (:ids)
  145. 2012-01-13 17:13:30,328 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: AdBlock.getByShopIds => select ab from AdBlock ab where ab.shopId in (:ids)
  146. 2012-01-13 17:13:30,328 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.AdBlock on table ad_block
  147. 2012-01-13 17:13:30,343 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRolePr
  148. 2012-01-13 17:13:30,343 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.PrefectureArea
  149. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: PrefectureAreaDao.getByIds => select pa from PrefectureArea pa where pa.id in (:id)
  150. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: PrefectureAreaDao.getByPrefecture => select pa from PrefectureArea pa where prefecture =:prefecture
  151. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: PrefectureAreaDao.getByPrefectureAndName => select pa from PrefectureArea pa where prefecture = :prefecture and name = :name
  152. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: PrefectureAreaDao.getIdsByPrefecture => select pa.id from PrefectureArea pa where prefecture =:prefecture
  153. 2012-01-13 17:13:30,343 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.PrefectureArea on table prefecture_area
  154. 2012-01-13 17:13:30,343 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopRate
  155. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopRate.getByShopIdAndSessionId => select sr from ShopRate sr left join sr.shopRateDetails srd where sr.shopId =:shopId and srd.sessionId =:sessionId
  156. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopRate.getByShopIdWithFetchedRateDetails => select sr from ShopRate sr left join fetch sr.shopRateDetails where sr.shopId =:shopId
  157. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopRate.getByShopId => select sr from ShopRate sr where sr.shop.id =:shopId
  158. 2012-01-13 17:13:30,343 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopRate.deleteAllData => DELETE FROM ShopRate
  159. 2012-01-13 17:13:30,343 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopRate on table shop_rate
  160. 2012-01-13 17:13:30,359 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleRoot
  161. 2012-01-13 17:13:30,359 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleBlog
  162. 2012-01-13 17:13:30,359 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findAllUserRoleBlog => select b from UserRoleBlog b
  163. 2012-01-13 17:13:30,359 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: getAllBlogsForActiveUser => select b from UserRoleBlog b where b.userAccount.enabled=true
  164. 2012-01-13 17:13:30,359 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.HairStylist2HairStyle
  165. 2012-01-13 17:13:30,359 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.HairStylist2HairStyle on table hair_stylist_2_hair_style
  166. 2012-01-13 17:13:30,359 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Campaign
  167. 2012-01-13 17:13:30,359 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Campaign on table campaign
  168. 2012-01-13 17:13:30,375 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Staff
  169. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findStaffsByShop => from Staff where shopId = :shopId and deleted = false order by seq
  170. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findStaffByShopId => select s from Staff s where s.shopId = :shopId and s.deleted = false order by s.seq
  171. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findStaffIdsByShopId => select s.id from Staff s where s.shopId = :shopId and s.deleted = false order by s.seq
  172. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findActiveStaffIdsByShopId => select s from Staff s where s.shopId = :shopId and s.enabled = true and s.deleted = false order by s.seq
  173. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findActiveStaffsByShop => from Staff where shopId = :shopId and deleted = false and enabled = true order by seq
  174. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findByNameAndShop => from Staff where shopId = :shopId and lastName = :lastName and firstName = :firstName and deleted = false
  175. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findNextSequence => select MAX(seq) + 1 from Staff where shopId = :shopId and deleted = false
  176. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findClosestLowerSequence => select MAX(seq) from Staff where seq < :seqVal and shopId = :shopId and deleted = false
  177. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findClosestHigherSequence => select MIN(seq) from Staff where seq > :seqVal and shopId = :shopId and deleted = false
  178. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: getStaffBySeqAndShopId => from Staff where seq = :seqVal and shopId = :shopId and deleted = false
  179. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findStaffIdsByShopAndService => select st.id from Staff st join st.shopServices ss where st.deleted = false and st.shopId = :shopId and ss.id = :serviceId order by st.seq
  180. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findEnabledStaffIdsByShopAndService => select st.id from Staff st join st.shopServices ss where st.shopId = :shopId and ss.id = :serviceId and st.deleted = false and st.enabled = true order by st.seq
  181. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Staff.getByIds => select s from Staff s where s.id in (:ids)
  182. 2012-01-13 17:13:30,375 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Staff.getByShopIds => select s from Staff s where s.shopId in (:shopIds)
  183. 2012-01-13 17:13:30,375 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Staff on table staff
  184. 2012-01-13 17:13:30,390 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.TagClouds
  185. 2012-01-13 17:13:30,390 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findTagCloudsPopular => select tc from TagCLouds tc where tc.tagSearch = :search
  186. 2012-01-13 17:13:30,390 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: getAllTagClouds => select t from TagCLouds t order by t.frequency desc
  187. 2012-01-13 17:13:30,390 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.TagClouds on table tag_clouds
  188. 2012-01-13 17:13:30,390 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopRateDetails
  189. 2012-01-13 17:13:30,390 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopRateDetails.deleteAllData => DELETE FROM ShopRateDetails
  190. 2012-01-13 17:13:30,390 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopRateDetails.deleteRedundantDetails => DELETE FROM ShopRateDetails srd WHERE srd.shopRateId =:shopRateId and srd.expirationDate <=:expirationDate
  191. 2012-01-13 17:13:30,390 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopRateDetails on table shop_rate_details
  192. 2012-01-13 17:13:30,406 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Prefecture
  193. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Prefecture.findPrefecturesByName => from Prefecture where name = :name
  194. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: PrefectureDao.getByName => from Prefecture where name = :name
  195. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: PrefectureDao.getByRegion => from Prefecture where region =:region
  196. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Prefecture.getByNameAndRegionId => from Prefecture where name =:prefName and regionId = :regionId
  197. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Prefecture.getByIds => select p from Prefecture p where p.id in (:ids)
  198. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Prefecture.findEnabled => SELECT p FROM Prefecture p WHERE p.enabled = TRUE
  199. 2012-01-13 17:13:30,406 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Prefecture on table prefecture
  200. 2012-01-13 17:13:30,406 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopService
  201. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopServiceDao.getByIds => from ShopService where id in (:ids)
  202. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findActiveServicesIds => from ShopService ss where ss.enabled = 1
  203. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findActiveServicesByStaff => select s from ShopService s inner join s.staffs st where st.id = :staffId and s.enabled = 1
  204. 2012-01-13 17:13:30,406 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: ShopService.getByShopIds => from ShopService where shopId in (:staffId)
  205. 2012-01-13 17:13:30,406 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopService on table shop_service
  206. 2012-01-13 17:13:30,406 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationUserRoleAgent
  207. 2012-01-13 17:13:30,421 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.PrPage
  208. 2012-01-13 17:13:30,421 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.PrPage on table pr_page
  209. 2012-01-13 17:13:30,421 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ShopSchedule
  210. 2012-01-13 17:13:30,421 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ShopSchedule on table shop_schedule
  211. 2012-01-13 17:13:30,421 WARN hibernate.cfg.AnnotationBinder:175 -> Placing @Access(AccessType.FIELD) on a property does not have any effect.
  212. 2012-01-13 17:13:30,421 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Reservation
  213. 2012-01-13 17:13:30,421 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: countOfActiveReservationsForStaff => select COUNT(e) from Reservation e join e.employees employees where e.reservationStatus IN (:activeStatuses) AND employees.staff.id = :staffId AND e.toDate >= :dateNow
  214. 2012-01-13 17:13:30,421 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: countOfActiveReservationsForShopService => select COUNT(e) from Reservation e where e.reservationStatus IN (:activeStatuses) AND e.service.id = :shopServiceId AND e.toDate >= :dateNow
  215. 2012-01-13 17:13:30,421 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findReservationForShop => select r from Reservation r, Shop s inner join s.services as ss where r.service = ss and s.id = :shopId
  216. 2012-01-13 17:13:30,421 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findReservationByDate => select e from Reservation e where e.reservDate >= :date and e.reservDate < :nextDate
  217. 2012-01-13 17:13:30,421 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Reservation.getByIds => select r from Reservation r where r.id in (:ids)
  218. 2012-01-13 17:13:30,421 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Reservation on table reservation
  219. 2012-01-13 17:13:30,437 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationUserRoleShop
  220. 2012-01-13 17:13:30,437 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.City
  221. 2012-01-13 17:13:30,437 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityDao.getAll => select c from City c order by c.name
  222. 2012-01-13 17:13:30,437 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityDao.getByPrefectureArea => select c from City c where c.cityContainer = :PrefectureArea
  223. 2012-01-13 17:13:30,437 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityDao.getByPrefectureAndName => select c from City c where (c.cityContainer in(select p from Prefecture p where p=:Prefecture) or c.cityContainer in(select pa from PrefectureArea pa join pa.prefecture pap where pap=:Prefecture))and c.name = :name
  224. 2012-01-13 17:13:30,437 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: CityDao.getByPrefecture => select c from City c where c.cityContainer in(select p from Prefecture p where p=:Prefecture)
  225. 2012-01-13 17:13:30,437 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: City.getByIds => select c from City c where c.id in (:ids)
  226. 2012-01-13 17:13:30,437 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: City.getByPrefectureAreaIds => select c.id from City c where c.cityContainer.id in (:ids)
  227. 2012-01-13 17:13:30,453 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.City on table city
  228. 2012-01-13 17:13:30,453 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Post
  229. 2012-01-13 17:13:30,453 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Post.findByAccountId => SELECT p FROM Post p WHERE p.userAccount.id = :accountId
  230. 2012-01-13 17:13:30,453 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Post.findByAccountIdOrderByCreated => SELECT p FROM Post p WHERE p.userAccount.id = :accountId ORDER BY p.created DESC
  231. 2012-01-13 17:13:30,453 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Post.findAllDateByAccountId => select p.created from Post p where p.userAccount.id = :accountId
  232. 2012-01-13 17:13:30,453 INFO cfg.annotations.QueryBinder:148 -> Binding named native query: Post.findByAccountIdAndDate => select p.* from Post p where p.user_account_id = :accountId and extract(month from p.created AT TIME ZONE 'JST') = :month and extract(year from p.created AT TIME ZONE 'JST') = :year
  233. 2012-01-13 17:13:30,453 INFO cfg.annotations.QueryBinder:148 -> Binding named native query: Post.findByAccountIdAndDateOrdered => SELECT * FROM post WHERE user_account_id = :accountId and extract(month from created AT TIME ZONE 'JST') = :month and extract(year from created AT TIME ZONE 'JST') = :year ORDER BY created DESC
  234. 2012-01-13 17:13:30,453 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Post on table post
  235. 2012-01-13 17:13:30,453 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationUserRoleCompany
  236. 2012-01-13 17:13:30,453 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.ReservedStaff
  237. 2012-01-13 17:13:30,453 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: findReservedStaffsByReservation => select e from ReservedStaff e where e.reservedFor.id = :reservationId
  238. 2012-01-13 17:13:30,453 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.ReservedStaff on table reserved_staff
  239. 2012-01-13 17:13:30,468 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.Company
  240. 2012-01-13 17:13:30,468 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Company.findAll => select c from Company c
  241. 2012-01-13 17:13:30,468 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Company.findByName => select c from Company c where c.name = :name
  242. 2012-01-13 17:13:30,468 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Company.findFreeCompanies => select c from Company c where c.shopUserCategory.id = 3
  243. 2012-01-13 17:13:30,468 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Company.getIdsByName => select c.id from Company c where c.name = :name
  244. 2012-01-13 17:13:30,468 INFO cfg.annotations.QueryBinder:86 -> Binding Named query: Company.findByInvitationPath => select c from InvitationUserRoleCompany i join i.company c where i.invitedUserRole is not null and i.path like :path
  245. 2012-01-13 17:13:30,468 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.Company on table company
  246. 2012-01-13 17:13:30,484 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.UserRoleWeb
  247. 2012-01-13 17:13:30,484 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.PrPageShop
  248. 2012-01-13 17:13:30,484 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.PrPageShop on table pr_page_shop
  249. 2012-01-13 17:13:30,484 INFO hibernate.cfg.AnnotationBinder:532 -> Binding entity from annotated class: com.sec.wrs.dbaccess.bean.invitation.InvitationMessageStatus
  250. 2012-01-13 17:13:30,484 INFO cfg.annotations.EntityBinder:530 -> Bind entity com.sec.wrs.dbaccess.bean.invitation.InvitationMessageStatus on table invitation_message_status
  251. 2012-01-13 17:13:30,484 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.ShopRate.shopRateDetails -> shop_rate_details
  252. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Shop.staffs -> staff
  253. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Shop.services -> shop_service
  254. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Shop.adBlocks -> ad_block
  255. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.invitation.Invitation.messageStatuses -> invitation_message_status
  256. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Shop.userRoleShops -> user_role
  257. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.UserAccount.reservation -> reservation
  258. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.ShopService.reservations -> reservation
  259. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Reservation.employees -> reserved_staff
  260. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Company.shops -> shop
  261. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Company.userRoleCompanies -> user_role
  262. 2012-01-13 17:13:30,500 INFO cfg.annotations.CollectionBinder:762 -> Mapping collection: com.sec.wrs.dbaccess.bean.Company.userRoleShops -> user_role
  263. 2012-01-13 17:13:30,500 INFO hibernate.cfg.Configuration:1676 -> Hibernate Validator not found: ignoring
  264. 2012-01-13 17:13:31,250 INFO cfg.search.HibernateSearchEventListenerRegister:75 -> Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
  265. 2012-01-13 17:13:31,281 INFO hibernate.connection.ConnectionProviderFactory:173 -> Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
  266. 2012-01-13 17:13:31,296 INFO ejb.connection.InjectedDataSourceConnectionProvider:62 -> Using provided datasource
  267. 2012-01-13 17:13:31,296 INFO hibernate.dialect.Dialect:135 -> Using dialect: com.sec.wrs.dbaccess.postgres.WrsSQLDialect
  268. 2012-01-13 17:13:31,296 INFO engine.jdbc.JdbcSupportLoader:108 -> Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
  269. 2012-01-13 17:13:31,296 INFO hibernate.cfg.SettingsFactory:126 -> Database ->
  270. name : PostgreSQL
  271. version : 8.4rc1
  272. major : 8
  273. minor : 4
  274. 2012-01-13 17:13:31,296 INFO hibernate.cfg.SettingsFactory:132 -> Driver ->
  275. name : PostgreSQL Native Driver
  276. version : PostgreSQL 8.4 JDBC4 (build 701)
  277. major : 8
  278. minor : 4
  279. 2012-01-13 17:13:31,296 INFO hibernate.transaction.TransactionFactoryFactory:62 -> Using default transaction strategy (direct JDBC transactions)
  280. 2012-01-13 17:13:31,312 INFO hibernate.transaction.TransactionManagerLookupFactory:83 -> No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  281. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:179 -> Automatic flush during beforeCompletion(): disabled
  282. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:183 -> Automatic session close at end of transaction: disabled
  283. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:190 -> JDBC batch size: 15
  284. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:193 -> JDBC batch updates for versioned data: disabled
  285. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:198 -> Scrollable result sets: enabled
  286. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:206 -> JDBC3 getGeneratedKeys(): enabled
  287. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:214 -> Connection release mode: auto
  288. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:241 -> Default batch fetch size: 1
  289. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:245 -> Generate SQL with comments: disabled
  290. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:249 -> Order SQL updates by primary key: disabled
  291. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:253 -> Order SQL inserts for batching: disabled
  292. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:431 -> Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
  293. 2012-01-13 17:13:31,312 INFO hql.ast.ASTQueryTranslatorFactory:47 -> Using ASTQueryTranslatorFactory
  294. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:261 -> Query language substitutions: {}
  295. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:266 -> JPA-QL strict compliance: enabled
  296. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:271 -> Second-level cache: enabled
  297. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:275 -> Query cache: disabled
  298. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:406 -> Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
  299. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:285 -> Optimize cache for minimal puts: disabled
  300. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:294 -> Structured second-level cache entries: disabled
  301. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:314 -> Echoing all SQL to stdout
  302. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:323 -> Statistics: disabled
  303. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:327 -> Deleted entity synthetic identifier rollback: disabled
  304. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:343 -> Default entity-mode: pojo
  305. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:347 -> Named query checking : enabled
  306. 2012-01-13 17:13:31,312 INFO hibernate.cfg.SettingsFactory:351 -> Check Nullability in Core (should be disabled when Bean Validation is on): disabled
  307. 2012-01-13 17:13:31,328 INFO hibernate.impl.SessionFactoryImpl:202 -> building session factory
  308. 2012-01-13 17:13:31,328 INFO hibernate.type.BasicTypeRegistry:150 -> Type registration [materialized_blob] overrides previous : org.hibernate.type.MaterializedBlobType@126ac06
  309. 2012-01-13 17:13:33,968 INFO hibernate.impl.SessionFactoryObjectFactory:105 -> Not binding factory to JNDI, no JNDI name configured
  310. 2012-01-13 17:13:33,968 INFO tool.hbm2ddl.SchemaValidator:121 -> Running schema validator
  311. 2012-01-13 17:13:33,968 INFO tool.hbm2ddl.SchemaValidator:129 -> fetching database metadata
  312. 2012-01-13 17:13:34,250 INFO tool.hbm2ddl.TableMetadata:65 -> table found: public.ad_block
  313. 2012-01-13 17:13:34,250 INFO tool.hbm2ddl.TableMetadata:66 -> columns: [id, slogan, text, idx, file_size, shop_id, file_content_id, file_name]
  314. 2012-01-13 17:13:34,250 INFO tool.hbm2ddl.TableMetadata:65 -> table found: public.agent_category
  315. 2012-01-13 17:13:34,250 INFO tool.hbm2ddl.TableMetadata:66 -> columns: [fee, category]
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!