Advertisement
Guest User

Untitled

a guest
Jun 26th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.90 KB | None | 0 0
  1. @Entity
  2. @Table(name="metalocation")
  3. public class Location implements Serializable {
  4.  
  5. private static final long serialVersionUID = 1L;
  6. @Id
  7. @GeneratedValue(strategy=GenerationType.AUTO)
  8. @Column(name="ID")
  9. private int id;
  10. @Column(name="DB_ID")
  11. private String dbId;
  12. @Column(name="GEO_LAT")
  13. private double geoLAT;
  14. @Column(name="GEO_LNG")
  15. private double geoLNG;
  16. @Column(name="IN_LOCATION")
  17. private int inLocation;
  18. @Column(name="ISO")
  19. private String iso;
  20. @Column(name="LOCAL_NAME")
  21. private String localName;
  22. @Column(name="TYPE")
  23. private char type;
  24.  
  25. @OneToMany(cascade=CascadeType.PERSIST)
  26. @JoinColumn(name="meta_address_fk")
  27. private Set<Address> address;
  28.  
  29. public Location() {
  30.  
  31. }
  32. .......... All setters and getters
  33.  
  34. import java.util.List;
  35.  
  36. import com.platformhouse.clinicsystem.web.model.entity.Address;
  37. import com.platformhouse.clinicsystem.web.model.entity.Location;
  38.  
  39. public interface AddressService {
  40.  
  41.  
  42. public List<Location> getAllCountries();
  43. }
  44.  
  45. @Service("adressService")
  46. @Transactional
  47. public class AddressServiceImplementation implements AddressService {
  48.  
  49. private AddressDAO addressDAO;
  50.  
  51.  
  52. //
  53. public void setPatientDao(AddressDAO addressDAO) {
  54. this.addressDAO = addressDAO;
  55. }
  56.  
  57. @Transactional
  58. public List<Location> getAllCountries() {
  59.  
  60. return this.addressDAO.getAllCountries();
  61. }
  62. }
  63.  
  64. @Repository
  65. @Transactional
  66. public class AddressDAO {
  67.  
  68.  
  69. @Autowired
  70. private SessionFactory session;
  71.  
  72. public void setSession(SessionFactory session) {
  73. this.session = session;
  74. }
  75.  
  76. public Session session(){
  77. return session.getCurrentSession();
  78. }
  79.  
  80. @SuppressWarnings("unchecked")
  81. public List<Location> getAllCountries() {
  82. Query query = session().createQuery("from Location where inLocation <=246");
  83. List<Location> results = query.list();
  84. return results;
  85. }
  86. }
  87.  
  88. @Controller
  89. @RequestMapping(value = "/usersignup")
  90. public class PatientSignupController {
  91.  
  92. private PatientService patientService;
  93. private AddressService addressService;
  94.  
  95.  
  96. @RequestMapping(value = "/usersignup")
  97. public String signup() {
  98. return "usersignup";
  99. }
  100.  
  101.  
  102. @RequestMapping( method = RequestMethod.GET)
  103. public List<Location> getCountries() {
  104.  
  105. return this.addressService.getAllCountries();
  106.  
  107. }
  108. }
  109.  
  110. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
  111. destroy-method="close">
  112. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  113. <property name="url" value="jdbc:mysql://localhost:3306/mydb" />
  114. <property name="username" value="username" />
  115. <property name="password" value="password" />
  116. </bean>
  117.  
  118. <context:component-scan base-package="com.platformhouse.clinicsystem.web.dao">
  119. </context:component-scan>
  120.  
  121.  
  122. <!-- Hibernate 4 SessionFactory Bean definition -->
  123. <bean id="hibernate4AnnotatedSessionFactory"
  124. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  125. <property name="dataSource" ref="dataSource" />
  126. <property name="annotatedClasses">
  127. <list>
  128.  
  129. <value>com.platformhouse.clinicsystem.web.model.entity.User</value>
  130. <value>com.platformhouse.clinicsystem.web.model.entity.UserType</value>
  131. </value>
  132. <value>com.platformhouse.clinicsystem.web.model.entity.Location
  133. </value>
  134. <
  135. </list>
  136. </property>
  137. <property name="hibernateProperties">
  138. <props>
  139. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect
  140. </prop>
  141. <prop key="hibernate.show_sql">true</prop>
  142. <prop key="javax.persistence.validation.group.pre-persist">com.platformhouse.clinicsystem.web.validation.PersistenceValidationGroup
  143. </prop>
  144. <prop key="javax.persistence.validation.group.pre-update">com.platformhouse.clinicsystem.web.validation.PersistenceValidationGroup
  145. </prop>
  146. <prop key="javax.persistence.validation.group.pre-remove">com.platformhouse.clinicsystem.web.validation.PersistenceValidationGroup
  147. </prop>
  148. </props>
  149. </property>
  150.  
  151. <property name="packagesToScan">
  152. <list>
  153. <value>com.platformhouse.clinicsystem.web.dao</value>
  154. <value>com.platformhouse.clinicsystem.web.service.implementation</value>
  155. </list>
  156. </property>
  157. </bean>
  158.  
  159.  
  160. <tx:annotation-driven transaction-manager="transactionManager" />
  161.  
  162.  
  163. <bean id="exceptionTranslator"
  164. class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor">
  165. </bean>
  166.  
  167. <bean id="transactionManager"
  168. class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  169. <property name="sessionFactory" ref="hibernate4AnnotatedSessionFactory" />
  170. </bean>
  171.  
  172. <form method="Get">
  173. <label>Country/region:</label>
  174.  
  175. <select id="iCountry" name="iCountry">
  176. <c:forEach items="${locationList}" var="country">
  177. <option selected="selected" value="">please select country</option>
  178. <option value="${country.id}">${country.localName}</option>
  179. </c:forEach>
  180. <select />
  181.  
  182. HTTP Status 500 - Request processing failed; nested exception is java.lang.NullPointerException
  183.  
  184.  
  185. **type Exception report
  186. message Request processing failed; nested exception is java.lang.NullPointerException
  187. description The server encountered an internal error that prevented it from fulfilling this request.
  188. exception
  189. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException
  190. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
  191. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
  192. javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
  193. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  194. javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
  195. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  196. root cause
  197. java.lang.NullPointerException
  198.  
  199.  
  200. ----------
  201.  
  202. com.platformhouse.clinicsystem.web.controller.PatientSignupController.getCountries(PatientSignupController.java:40)
  203.  
  204.  
  205. ----------
  206.  
  207.  
  208. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  209. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  210. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  211. java.lang.reflect.Method.invoke(Unknown Source)
  212. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  213. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  214. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  215. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  216. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  217. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  218. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  219. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  220. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  221. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
  222. javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
  223. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  224. javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
  225. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  226.  
  227. @Autowired
  228. private PatientService patientService;
  229. @Autowired
  230. private AddressService addressService;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement