API tools faq
paste
Guest User

Untitled

a guest
Nov 6th, 2017
410
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.39 KB | None | 0 0
raw download clone embed print report
  1. package com.msoft.crm.daos;
  2. import java.util.ArrayList;
  3. import java.util.HashMap;
  4. import java.util.List;
  5. import java.util.Map;
  6.  
  7. import javax.persistence.EntityManager;
  8. import javax.persistence.PersistenceContext;
  9. import javax.persistence.Query;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
  12. import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
  13. import org.springframework.jdbc.core.namedparam.SqlParameterSource;
  14. import org.springframework.stereotype.Repository;
  15. import org.w3c.dom.ls.LSInput;
  16. import com.msoft.crm.entities.Users;
  17.  
  18. @Repository("UserDao")
  19. public class UserDaoImpl implements UserDao {
  20. @PersistenceContext
  21. private EntityManager entityManager;
  22. public String original,recipientAddress,firstName,userName;
  23. @Override
  24. public List<Users> getAllUsers() {
  25. return new ArrayList<Users>();
  26. }
  27.  
  28. @Override
  29. public List<Users> validateLogin(String username, String password) {
  30. String hql = "from Users u where u.username = :p_username and u.userPassword = :p_password";
  31. Query q = entityManager.createQuery(hql);
  32. q.setParameter("p_username", username);
  33. q.setParameter("p_password", password);
  34. List<Users> users = q.getResultList();
  35. System.out.println("users : " + users);
  36. return users;
  37.  
  38. }
  39.  
  40. @Override
  41. public List<Users> getMenusByRole(long userId) {
  42.  
  43. String hql = " select ur.role_id ,ur.role_name ,ur.speciality ,ms.section_id ,ms.section_name ,ms.section_position ,"
  44. + "ms.section_icon ,mi.menu_id ,mi.menu_name ,mi.menu_action ,mi.menu_position ,mi.parent_menu_id "
  45. + "from MenuPrivileges mp inner join UserRoles ur on mp.role_id = ur.role_id "
  46. + "inner join MenuItems mi on mp.menu_id = mi.menu_id "
  47. + "inner join MenuSections ms on mi.section_id = ms.section_id "
  48. + "where mi.active_ind = '1' and mp.visible_ind = '1' "
  49. + "and mp.role_id = (select role_id from crm_users where user_id = :user_id) order by ms.section_position asc";
  50.  
  51. Query q = entityManager.createNativeQuery(hql);
  52. q.setParameter("user_id", userId);
  53. List<Users> l = q.getResultList();
  54. System.out.println("l : " + l);
  55. return l;
  56. }
  57.  
  58. }
  59.  
  60. package com.msoft.crm.entities;
  61. import javax.persistence.Column;
  62. import javax.persistence.Entity;
  63. import javax.persistence.Id;
  64. import javax.persistence.Table;
  65. @Entity
  66. @Table(name="crm_menu_privileges")
  67. public class MenuPrivileges {
  68.  
  69. @Id
  70. @Column
  71. private int role_id;
  72. @Column
  73. private int menu_id;
  74. @Column
  75. private String visible_ind;
  76.  
  77. public MenuPrivileges() {
  78. this(0,0,"");
  79. }
  80. public MenuPrivileges(int role_id, int menu_id, String visible_ind) {
  81. this.role_id = role_id;
  82. this.menu_id = menu_id;
  83. this.visible_ind = visible_ind;
  84. }
  85. //getter and setter
  86. }
  87.  
  88. @Entity
  89. @Table(name="crm_user_roles")
  90. public class UserRoles {
  91.  
  92. @Id
  93. @Column
  94. private int role_id;
  95. @Column
  96. private String role_name;
  97. @Column
  98. private String speciality;
  99.  
  100. // getters and setters
  101. }
  102.  
  103. @Entity
  104. @Table(name="crm_menu_items")
  105. public class MenuItems {
  106.  
  107. @Id
  108. @Column
  109. private int section_id;
  110. @Column
  111. private int menu_id;
  112. @Column
  113. private String menu_name;
  114. @Column
  115. private String menu_desc;
  116. @Column
  117. private String menu_action;
  118. @Column
  119. private int menu_position;
  120. @Column
  121. private int parent_menu_id;
  122. @Column
  123. private String active_ind;
  124.  
  125. // getter and setter
  126. }
  127.  
  128. @Entity
  129. @Table(name="crm_menu_sections")
  130. public class MenuSections {
  131.  
  132. @Id
  133. @Column
  134. private int id_pk;
  135. @Column
  136. private int section_id;
  137. @Column
  138. private String section_name;
  139. @Column
  140. private String section_desc;
  141. @Column
  142. private String section_icon;
  143. @Column
  144. private int section_position;
  145. //getter and setter
  146. }
  147.  
  148. Hibernate:
  149. select
  150. users0_.user_id as user_id1_5_,
  151. users0_.aadhar_no as aadhar_n2_5_,
  152. users0_.active_ind as active_i3_5_,
  153. users0_.created_by_user_id as created_4_5_,
  154. users0_.created_date_time as created_5_5_,
  155. users0_.email as email6_5_,
  156. users0_.fname as fname7_5_,
  157. users0_.lname as lname8_5_,
  158. users0_.login_status as login_st9_5_,
  159. users0_.mname as mname10_5_,
  160. users0_.mobile as mobile11_5_,
  161. users0_.photo as photo12_5_,
  162. users0_.role_id as role_id13_5_,
  163. users0_.password as passwor14_5_,
  164. users0_.username as usernam15_5_
  165. from
  166. crm_users users0_
  167. where
  168. users0_.username=?
  169. and users0_.password=?
  170. users : [Users [userId=3, roleId=1, sectionId=0, sectionPosition=0, menuId=0, menuPosition=0, parentMenuId=0, specialityId=0, username=shirin, activeInd=1, loginStatus=1, roleName=null, speciality=null, sectionName=null, sectionIcon=null, menuName=null, menuAction=null, firstName=yogiraj, lastName=kulkarni, mobileNumber=9699999999, middleName=, emailAddress=yogirajk@msoft.co.in, aadhaarNumber=123456987456, profileImg=data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxITEhUSEhIVFRUVFRUVFRUVFRAVFhUVFRUWFhUVFRUYHSggGBolHRUVITEhJSkrLi4uFx8zODMtNygtLisBCgoKDg0OGxAQGy0lHyUtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLf/AABEIALcBEwMBIgACEQEDEQH/xAAcAAABBQEBAQAAAAAAAAAAAAADAAIEBQYBBwj/xAA9EAABAwIEAwUGBAQGAwEAAAABAAIRAyEEBRIxQVFhBiJxgaETMpGxwdEUQlLwI6Lh8QczQ2JykiRTgxX/xAAbAQACAwEBAQAAAAAAAAAAAAADBAECBQAGB//EAC0RAAICAQMCBQIGAwAAAAAAAAABAhEDBBIhMUEFEyJRYTJxI1KBobHwFEKR/9oADAMBAAIRAxEAPwCwxGWADZY/NKUVCF6tmVBunyXm2dM/iFKXQWXBTFiYWqY5qjhqlSsHYwWQatVErKJUClOybOe1RKZUUboocr0SWFJ6kB6radRHFRQyCZ7REpAlNy7BOqHotZhMoAGy6MGyGZ0Unckx7DxC15y8DgomJwA5KXiZKZlHFJrkfNMI5twLKvaSh1RYnMKKHqJTRgVBwX2ia4oRK5rXHBkwtXA9OUnAKjFHJU14USoFJwXB3V1hcMdQKq8lZLoW0pYYBoKLCNg5FllNKIWlpYW0rO4arELWZbWBCZiiKK3E4boqjGYexWvxNGQs9jqcSuaJPNe0lCxWSJW47UcVhX7pWS5LREShPKcXIbioLEchJPhJSce7Z1iwAvP8wdqeSrnOcwm0qgmUjmnXAPNLsR6oshtZZHqhItso31AHu4IT6aiYkQrY07KpxhuiYZ7pUdB2yEUVtMo2GoTdSH0oRpZUnRdy5oisCm4DCmo4BCp0SVpezOGGra/FWvmi/RGiyjLQ1ostBSwgTMJS2Vs2km40iEiudhAoeJwSvXUkOpQkKWWoxGZ4MEGyx1elpcR1Xo+dUtIWCzBsvKVyqmSiO0IkprWJxCESMcUwJPXApOHtRQUJoT1xwnFAc1Ecm9FZEMmZIYetpRdLVhsE7S5a7A15CPjYNrklGtAWiyTGbLJYl6scmrRF0RPk43QrghZ/OcQBKJ+KWYz3G73VpukcZbtPiJMLKVgrXMq+pyrKqUbLIjFNKe5qYVJJxJJJcSautX1FPaEDD01IWXqH6hTK/UDIunlqTQiQqzfCRWTBVRZUmIZLleYjZVlKnLkbTOk2Xxvqw+GowE2q28KYRAUXcquJ7pOTJx8u2Po0luezOBDWi3is1lWHkzyW0yh0N8EXHPdOwie5miw1AQFMawKnp47gFY4eo4/lPwT6mgod9NBc1Hq1wN1VZhjLWKKpI4oO09XksLiReVrM4qalmMQ26VyO2WQFoSc1OYU4lDOIrmLgajuClU8DABeY6DeOvJc5JdQuHT5M0tsFZBYzkinCv/Q74FWdGo1ohojruT4lL2zt/hEfdBeZ9kbGPwS165c/BTvwz/0O/wCrkL2ZBuCPIq7/ABLjz+ya+uSfeMqP8h+xZ+Bx/P8AsVUK3y3FcEOnXBsQDP6hx8l11IC9geQP0KJDVJPkWy+CZV9DT/YnYupZFyfGQqr2hI6eSFSxBYU3HLGXKZlZdNlwupxaNs/GiJlZDPsdqmCuYvMyRAVLVJO6mc74BJFfVfdCciVRdCchkg3IbgiFMKk4Gup+lJTZxs3UNIUcqzx/uhVZWXn+sUyfUOphOXGrqFN8lJMDijZBwtNFrp9BtkWL24y6dRGYp0BBwzUepRc891pPgCpVLK6oHuerPuq7tkPucrUSxyoABWFLEuLtLeKpf4lMXY4DmWkD4rWdj8uLv4jhv8lfHdUg2N9jS9ncotqfdaUta0KKyu1jVS5rnJPcYnYuMF8hmgeb4zU7S1UWPpuAV1gMGfeKjZvXYwczyXbjjKVgTuqLGNuVoa9QXJWfxx71tlEpFUyG1dTgF3iqqQROwjsQ2k3m+b9B0UZ+O1GSd7quxVKs4khjjfcNJHPcJlTAV6cGowtBvJ25xI2PRD2uXJ6THmx4UoQ6Fo7GD0XGYokbGOZRezWEovdqqGdJ2dAZMggzMzAcL2v0K1GJwkF7W0m+7LiGiGnUdYZO5hzY6EEKyxWi0tY06Mq2t1TDiQNzC1uaOq4ejTZQoscSGh7YAvs4kkd47m6WJyfCmlrq0v4jp06C5pJAkmBYNFpMKz0/HUDHxS57aMvQxDdQm4m91oMTjaPsgAAXmSXGLDlEKgrZNoIMkAgGDp1DxA92eAKNSoNA5+J+iXarg0Yz3U2Me4cDKWnVaNtipIaOACbVoFwlpl3IQLfVUXD4JyqOWO2StEQUEOph1JpVIMFSq9OydhLcjy2s0rwTrt2MxiaV1EeFe4miqnEU4REJkQhMRYTXBWJEkkCurjja45/dCryjYipYKOsrK7mIzdyChclcJTQhvllH1OOF1YZaKbSHVoLB+Uu06jwBIvHgqXEYkDw+f9ECpiJvueuwWnj03C3DMI+56b/+dl+Jwv4gD8OWuLXOYXOa0t2Oh090y07KgzKhUwzwx7g9rmh9OoNqjTxA4HmE3sJjxVFbBPJ01KZcIttAdp6wQR4FbHE4im2iaQGrutZpIaYptHAuEF7o0jkSCiZtPHIqGNqaMhSzMgQDE/Aq/wAk7QFloEcto6hVWIyunplrAdQIaACwnRpDiwzPee8MBI/LwklQzlVZjRUBZpce6x1RvtD/AMOFRvDVYnkkpaXJj5iBcWuUa3Mc2c46W8dip+S5cT3nb8SslkmZyQCAeYNjbl1W2xGZMZR1NNiP2CiwTcd52PJudPqLOs0bSbpBWP79Z08OaOzDVMS/U6dKta1NlJkWXU3yy92UOMwwAhU+LpBWeOxeo22VXWKFPIVckQdCRYj6UxyCs1FPMPSOw+Ba3BtJAmo5zzI4Tpb6NB81S9q8IXVTSZT1NewksgR3RMjkTPDktL2bf/4lEx+RoTqjG6y/82nTPSVowlwjQgntVHjGGcyhXA0kODtLqdQAgkH8rtp5aoXoWBa50h7AHbuYZBaSLd2drA7QTe8Wxn+JlLTig4D32A+YkfZRez3aF3tGMqveQ1uik8l005B7uoS7TEQL3ARFCuUXjqW3tn/09JAdpIaNUSdPcPDeIDv5fiq7EVRH8UEzGluh5dubAFjWzvAMAbnVsrHCnW1plrmlo75I7zhxmNM8bwQRukHlxIcX8hPtXMN9iQ9wiL3HJS7DwpOzK547utJlh40yWkibzDYA8wCqqnWHA/P5q07QU6eo2DTHDU2YsDpLBPjKpKYE3KSyL1G1gdwJIcOZ+P0Q61Qi7bppeNpPmAh6jsChh0mjuo7kfFTcPWDrfvwUN1S0FRSdLpmL7g79CrQdMU1eJZYNSLSvSVHmDFotUsB6KgzQptHl5KnRVSuOSScUQgHKS4Elxxpy+U5gUXDvkKwpNssqrkIdwLim4iqGUnPO57rfr9vMpVN1UdoK5cadIcBMDiXFG00E8lvsXxxuRWvxRJn9+CKMSOG/yR8dhWUqMuEvNgb2P2CrKFJr9MFzDAkja25laMZ7uUMJ2bf/AA5JOOpkCA1jyTsI0xf4haqtitGIqUiXB4cS3SWsNRr7tfQJ7rz3oLHbkWM2XmOV5p+GqtqUmN7rgTqGoubNw4nmvf25dh8XTBq0WVGOALZADmyJEOFxur1YWL4MvhKwdJlzwBFU0w8vbEg+0o1CHs3cIAdudlWZk0l5e54LTrAcH0jSex1mapOvUwW0gbytTmXZzEU/8kjE0xdtOs91OtSMf6OJb3oMRpJ5X3VNSxJa7XWp4nBVCdDX1hTr4cuPB741AHaS4dCqP2ZKRR5vgjQrD9NQa2nx3B8/mrvJKjasMcbi99j0VNjabnF7AwNbq1BoJLGv2qezO7WuidBAgzzTcrr6Xi/x6IOny43KUExHUweOakbnHZnToNgRPRZXE4x1V0u25KXislqlor3cHCY4jooAYHWu08igTnJumgjlYGq9o2Cj+zJuSpNfDubuPMKLKXnG3yU6g6oAUZxUp8ID2oexLodSRvuyWMLsKxvFhc0/9pHoQrOs4wbGyw/ZTMfZVCw+6+I6OG3x2+C3tQAtBBT+B7kaWKacEeT/AOJz5qUj/sMfELIYVkEuD5+MaoO3kPVajt7Sc97mAHuOIbsBBgwSfEfELIU8PoADiCSSTpIIGwuQU2mAk7ZcZJ2mr4V00iC0mXUyXaH+XA9RfxXpWQ9qqGLBDAWVI7zHQT6bjqF4y4QnYKpUFRhpmHh3dI4f0XMJinJOj1LtbjNTWtgXMneenpKzHgn1sQ55JcblxJ5eSizJSOR3I9NplsxpBQ4hNkhMKZ7WbIdDDnRILnbxI481HZUmVw4mBdDpkPdvHMwrJCuSafBa4fG20ERyhVGZPkqc5rQRcjrwKrcYwyjY5X1MTW4Nst0VwQ1xyfpTCEYSFCS7CS44s8G9XVM91Z7Cuur+l7qRlGmJ0RXGSVDp4acQXnZrRp8T/YqeQugqYvamWXBUZxgXTqb3m8Wm4B5gHZU7y6NNgBwEAT9StgXKHXy6m68QelvRMY89cMJGXuZRxX0Z2VzCMNRBP+my3GwheC1mUqdSHNc8CDAIbq4wTwC2OS/4hsb3a1FzRwLCHgCeUApqMkFiewNqVKh7pAHPe3VcxlOGFj4qNcCHNcLOB3BBVJlXaOk6mHU3hwImQfny81T9pO2VKixx1tdVA7tMGbn9UbDiufIZSS6lD2cx7TUrUgSW06jmscfzUwSGzzgACfBTMywUH2jIHMdeiyvYvFgvc0zqJnbgt5Ww7nMIAleS1E/8bX7lwm19qGfLWbTtM1vYqsKuF0ug6XEeRuPmVX9oez7ZLmCDuoXYjG+yreycIFS3g4CQY+I+C2+OpghetcIy6GRj5jT7HlppOEtPqq7E0INrLX5xhBJIWcxQB8Ql8uLjktsKeow8UFWbgCoWJYAs/LDbygMrQGFruzue/kqG/Pn/AFWSCc1Cx53B2TjzODJXa0sdXA7rmuNj/u69bKlqYCnPuN8hHyRMywPtLteWuF53E9Qu0XvDXGqBLQO80yDNpjcHon/NU/VEaxSUpopcdloExxO1yo+CwZY7WecDw5q/ZQ1kO/Lw81ExtQXM8SGjwBAARVL0my8Md6a+4nPldabAKGKjoE87/VP9sAgtGjHKh1aveI538FEfUcDzCJvJ81Gc+3W8qUhfLNvudwjHOJ5T18VcUgOIg81BwZhgEwePmpTCbyPNWmrA4JxXHclVw2BIBBUN9LS6Ddm29xPzvC66SPDhy3XXu1Nvyg+WyHVB51NckGs0AxPh1UZ4U7GUzEzfgfoopE7iHDcc+RHiEaMvcyc2nUX6QSS4uoooS6YV3hallU1GwpOAqJOQoyTUKYXJ9YIEosIpoPBJoM1ydqQF3UrPGidpTZnhTqLuB9FXzeAL81pntDu6dnWPmoOJyKqwkFthxuieYo8NnUynFZzSYcRPIkfJKmJN0atQ7xjp47QpmXYAvIBB4cOCtKaSs6y17M6adQFpkkgT9F61SbbyWRyHs4xhbUO4FhwWvZOleH8az482VbOa6s19JjlCD3FF+K0Ylj/0vYT4BwPyBXpuJeC2edwvJsewh51Nibg84WwwOeA4dsm7Rp+G3p8l7bRrbpsfwkYrl+NJPuwecVIlY/G1O8p2b5tqJuqGrWlRlzIiU0gr3KM9pN0RolF02SM3uAPkhaVxSHBBLUBwKUNJUfGQGXJvy84+RUhwQMwaSAAJsPKQL/zJrTwGcHEkB/Ewxg27rb8zBmfRV2IIJbHAz42RcQ68cGmAo7nRdF6HpUty+B1She6DWpmR5/KE81DBPJD9rdSS0ug3QU2vho2Rd9uCZVlEVdxXJubddgtFgLG84RRqAhdw5GkW2Anrv90ys5UlL1UJ48m3M7HUKpBP72RXVBzXNEAIFax8iqv6qGcWsUpbQr4c03G0X5qo1EP3tGpvhxHkZ8lOa/mouYUbe04tN/8AiVeMewTK/wDZCbVpu7xME7jqkoZwxNwWx1N0lcU2r2L3FngELB1IKkhkqLWZBS/wZZbOMhR3LmGq2T3rsUqdFscqdCCRXGrjk0HGuK9EqEPoNdH+Y0H/ALCSvOoJMDcmB4leltw+hjGfoYG+YELB8clFRh726HNIrbKN3Z9hOrSFPwOWU6ewv1U4PRaenksGetzTjtlLgcjhgnaQbDgC6O+qTfgmUmtKOQAs+crYfsZnN8e1x0A3lV765DHAG4g+INkbO8M1tZrgIneBv06T9FDc+5tHDUJFvmvo3hmHHHRxjj6M8vq3OWduXYBSE3KOaSawQeaOeSBmwyxvkGqYJgTnBcaUWEIkjlqGQpDwoz3LirG1QhY6oGg9RTHmf7Lr3qBmj4HnR+bintMqUvsGxx9UfuiDQIc50pVKaVBwL3eXqnVHwYQ5dT1OCK2JAnCyZCeTZNbsq2G2oK2mCJG49VHrmyOKsIFS6myriqYXDH+G0jaXB3jwPyR6DNUEhCy93dc3kZ+Ij6KbT90dD+/qmI4VKKl3PM62ThmaAVXXhQ8S8zA/cqZplyDWG8BL03cvYDCVMCWgBJ7pbHSPoulsCCg1AOFvqrp3ybGLKpIr3UgLaSf3ZJS5C4r7jvLRb0XoWIbJXWEQE4IJjAqJhSpUd4TybKj+qyvceHLhchBy7qTaGUXHZfBiriGhwlre8fERE+a39fcrJdkKUQ79RJ8m2HrK17S0nvLzPjiUs0Y30X8j+jfpb+QIEIlGnPBWFPDU4mLoZoxsbLz2RV0Hos422wTMQ4xKI5R69SQUNRp8l30Mnm2L1P2Mfa31UOfgUfMz3vH6H+yizdfUdAk9Njr8q/g8lqbWWX3YemDG8/XxUum7U24AcLnrdQWkKTRf+/FMzxxmqYvvaE1glEcFC9sRU0kQHAlu/vNMPHpPxR3VFh5cbxycWMxaasZVKiVnQi1aig1n8FWMbZaMbY0ulRM2J0j/AOZ+DnBT6VNAz+jFEHl9CHfQp7Fxa+A9qMo/dFTRfDoIiT4bKRUAJMKurVOPUKVQdPG9whSR6HFPsOeLIafWn4JrVShlSOSEyo5dcLoZK4q5cEnK6kaweIHoZUtrjEePz/qqvCOh462+KtKZsE/p/oaPNeJqsifwKlaSVwcSm1jyK4ZAvuVXIklSE4kasJieY8yVzFM7ojgu1LkDk6fgnV3W8igL0QoZxzamiuDkk9rTwCSjg1vMQdriptB4UEFEQWjDJNU3nguyo1OtzTg4c1FlkwhamkojSCm02d4TtInwTGOakqCqXBrMh7r9H6WtHnF1qWskhZLJsUwU313Hvu2HSx+oWyy8yAenzXl/Hsco6ly7Ol+xoaCX4dPqSPaFE1WQY4pNJKwmubZoI4ZPFMriyktgIVQKm62XXQxeekNIPN0T4j7hVdLFtc8NnceXgtB2ipUzRqSYe06h4WEec+iyOFoktDmRqY74iBb0X0rwqbekxpex5nWY15spMtRWg6TxmI6f2RqLyLxy+CrcHVc4y4REiOvGVNoP7oJ6f1WmuTOycMkZlT1gQYOtpB5VLAT0Nmn/AJLlU2lOotD2vadnD5gifUfBUWDxbpcyobnv/H3vWUjrsVpSQTC+GiXXrQojSSV2q6UbD00lFUO41SJeGau5szVScOV/ofQlFohJ95HOyupbZWVkzE3NuVvgj0dz+9kysNLyOukzzGxTqTu8OtkSao2sGRSSYatU262KCHlKobEHyQgUKhvcFc5cYhykSoLbjtUct1Z0HSAenzVQaitMP7o8Am9N3MXxWqTOhpDr7LuLMwF1z7lBq1NydgjyRlQbZxrdk2vv5LtE91pPG/xuhVnff7JLIndsYi+RNKSjNrECEkPaFtjK+KaDY+FimjHDn80klfagdDfxQ5+hRWYpvP0KSShwRFB2YxvP0KL+NbBv+V3A7weiSSrCCUkTRKONYGtAdYN5O3gDkt72czqkMPT11O8Wie6/7LqSB43ijkxpP3GdFJxk/sTKmdUP1/yv+yfRzmh/7P5X/ZJJeZno4e7/AL+hqLKwpzuh+v8AlqfZDrZ5Qj3/AOV/2SSQ46LH7v8Av6FvOlRku0+ZUnhxD+R2f1HLqqLJswYGkF3I7O+3gkkvd+HenTwS+TB1a3OVk4ZhTudXA8HfZcw+YMAI1ceTvskknnJmesaJWCzOmHSXD4P3+Cp8/wARTbWY5jrOmbO4m428/NJJUyO40ExRSmdo4unPvejvspbcdTH5vR32XElm7UOdiQ3Mqf6vR32SdmNL9Xo77JJKu1FKM52gewPDmukOF7O3HkoTscHQ4m+x33HFJJMJXEawScegWpi2kb3HQoRxDefoUkkPajR8xnPxLefoV38Q3n6FJJRtRyysaa7efoVY0MYyBfhyKSSNh4Yjrnvir9xrMWwi7t54Hmo2KxTdtU+RSSR2Z8Y8gxmjYA4i3GPFFGJbBv6FJJAyRTQbakCFdnP5pJJIW0sf/9k=, fullName=null, userPassword=e7202d28c87440d38bd5bf4ff37c7fcc, createdBy=1, createdDate=2017-06-14 11:16:12.0]]
  171. active ind(service):1
  172. In get menus role user id : 3
  173. Hibernate:
  174. select
  175. ur.role_id ,
  176. ur.role_name ,
  177. ur.speciality ,
  178. ms.section_id ,
  179. ms.section_name ,
  180. ms.section_position ,
  181. ms.section_icon ,
  182. mi.menu_id ,
  183. mi.menu_name ,
  184. mi.menu_action ,
  185. mi.menu_position ,
  186. mi.parent_menu_id
  187. from
  188. MenuPrivileges mp
  189. inner join
  190. UserRoles ur
  191. on mp.role_id = ur.role_id
  192. inner join
  193. MenuItems mi
  194. on mp.menu_id = mi.menu_id
  195. inner join
  196. MenuSections ms
  197. on mi.section_id = ms.section_id
  198. where
  199. mi.active_ind = '1'
  200. and mp.visible_ind = '1'
  201. and mp.role_id = (
  202. select
  203. role_id
  204. from
  205. crm_users
  206. where
  207. user_id = ?
  208. )
  209. order by
  210. ms.section_position asc
  211. 2017-11-07 10:27:47.364 WARN 3116 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1146, SQLState: 42S02
  212. 2017-11-07 10:27:47.364 ERROR 3116 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : (conn:143322) Table 'crm_application.MenuPrivileges' doesn't exist
  213. Query is: select ur.role_id ,ur.role_name ,ur.speciality ,ms.section_id ,ms.section_name ,ms.section_position ,ms.section_icon ,mi.menu_id ,mi.menu_name ,mi.menu_action ,mi.menu_position ,mi.parent_menu_id from MenuPrivileges mp inner join UserRoles ur on mp.role_id = ur.role_id inner join MenuItems mi on mp.menu_id = mi.menu_id inner join MenuSections ms on mi.section_id = ms.section_id where mi.active_ind = '1' and mp.visible_ind = '1' and mp.role_id = (select role_id from crm_users where user_id = ?) order by ms.section_position asc, parameters [3]
  214. org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  215. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:261)
  216. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
  217. at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488)
  218. at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
  219. at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
  220. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
  221. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  222. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  223. at com.msoft.crm.daos.UserDaoImpl$$EnhancerBySpringCGLIB$$337e38b5.getMenusByRole(<generated>)
  224. at com.msoft.crm.services.UserService.validateLogin(UserService.java:44)
  225. at com.msoft.crm.controllers.LoginController.validateLogin(LoginController.java:42)
  226. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  227. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  228. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  229. at java.lang.reflect.Method.invoke(Unknown Source)
  230. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  231. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  232. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  233. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  234. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  235. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  236. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  237. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  238. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  239. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  240. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  241. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  242. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  243. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  244. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  245. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  246. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  247. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  248. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  249. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  250. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  251. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  252. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
  253. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  254. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  255. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  256. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  257. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  258. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  259. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  260. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  261. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  262. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  263. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  264. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  265. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  266. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  267. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  268. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  269. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  270. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  271. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  272. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  273. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  274. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1457)
  275. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  276. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  277. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  278. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  279. at java.lang.Thread.run(Unknown Source)
  280. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  281. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
  282. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  283. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
  284. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
  285. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
  286. at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)
  287. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)
  288. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
  289. at org.hibernate.loader.Loader.doQuery(Loader.java:919)
  290. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
  291. at org.hibernate.loader.Loader.doList(Loader.java:2617)
  292. at org.hibernate.loader.Loader.doList(Loader.java:2600)
  293. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)
  294. at org.hibernate.loader.Loader.list(Loader.java:2424)
  295. at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:336)
  296. at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1967)
  297. at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:322)
  298. at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:125)
  299. at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
  300. at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483)
  301. at com.msoft.crm.daos.UserDaoImpl.getMenusByRole(UserDaoImpl.java:115)
  302. at com.msoft.crm.daos.UserDaoImpl$$FastClassBySpringCGLIB$$da03a52e.invoke(<generated>)
  303. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  304. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  305. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  306. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
  307. ... 59 more
  308. Caused by: java.sql.SQLSyntaxErrorException: (conn:143322) Table 'crm_application.MenuPrivileges' doesn't exist
  309. Query is: select ur.role_id ,ur.role_name ,ur.speciality ,ms.section_id ,ms.section_name ,ms.section_position ,ms.section_icon ,mi.menu_id ,mi.menu_name ,mi.menu_action ,mi.menu_position ,mi.parent_menu_id from MenuPrivileges mp inner join UserRoles ur on mp.role_id = ur.role_id inner join MenuItems mi on mp.menu_id = mi.menu_id inner join MenuSections ms on mi.section_id = ms.section_id where mi.active_ind = '1' and mp.visible_ind = '1' and mp.role_id = (select role_id from crm_users where user_id = ?) order by ms.section_position asc, parameters [3]
  310. at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
  311. at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
  312. at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
  313. at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226)
  314. at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeInternal(MariaDbClientPreparedStatement.java:233)
  315. at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeQuery(MariaDbClientPreparedStatement.java:177)
  316. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  317. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  318. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  319. at java.lang.reflect.Method.invoke(Unknown Source)
  320. at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
  321. at com.sun.proxy.$Proxy81.executeQuery(Unknown Source)
  322. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
  323. ... 80 more
  324. Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Table 'crm_application.MenuPrivileges' doesn't exist
  325. Query is: select ur.role_id ,ur.role_name ,ur.speciality ,ms.section_id ,ms.section_name ,ms.section_position ,ms.section_icon ,mi.menu_id ,mi.menu_name ,mi.menu_action ,mi.menu_position ,mi.parent_menu_id from MenuPrivileges mp inner join UserRoles ur on mp.role_id = ur.role_id inner join MenuItems mi on mp.menu_id = mi.menu_id inner join MenuSections ms on mi.section_id = ms.section_id where mi.active_ind = '1' and mp.visible_ind = '1' and mp.role_id = (select role_id from crm_users where user_id = ?) order by ms.section_position asc, parameters [3]
  326. at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144)
  327. at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076)
  328. at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031)
  329. at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:203)
  330. at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeInternal(MariaDbClientPreparedStatement.java:224)
  331. ... 88 more
  332.  
  333. 2017-11-07 10:27:47.383 ERROR 3116 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause
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!