Guest User

Untitled

a guest
Apr 15th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.60 KB | None | 0 0
  1. but in getAllStudents() they are throwing error
  2.  
  3.  
  4. spring config file:
  5.  
  6. <?xml version="1.0" encoding="UTF-8"?>
  7. <beans xmlns="http://www.springframework.org/schema/beans"
  8. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
  9. xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mvc="http://www.springframework.org/schema/mvc"
  10. xsi:schemaLocation="
  11. http://www.springframework.org/schema/beans
  12. http://www.springframework.org/schema/beans/spring-beans.xsd
  13. http://www.springframework.org/schema/context
  14. http://www.springframework.org/schema/context/spring-context.xsd
  15. http://www.springframework.org/schema/mvc
  16. http://www.springframework.org/schema/mvc/spring-mvc.xsd
  17. http://www.springframework.org/schema/tx
  18. http://www.springframework.org/schema/tx/spring-tx.xsd">
  19.  
  20. <!-- Add support for component scanning -->
  21. <context:component-scan base-package="com.srinivas" />
  22.  
  23. <!-- Add support for conversion, formatting and validation support -->
  24. <mvc:annotation-driven />
  25.  
  26. <!-- Define Spring MVC view resolver -->
  27. <bean
  28. class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  29. <property name="prefix" value="/WEB-INF/view/" />
  30. <property name="suffix" value=".jsp" />
  31. </bean>
  32. <bean id="myDataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
  33. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  34. <property name="url"
  35. value="jdbc:mysql://localhost:3306/hb_student_tracker" />
  36. <property name="username" value="hbstudent" />
  37. <property name="password" value="hbstudent" />
  38. </bean>
  39.  
  40. <bean id="mySessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
  41. <property name="dataSource" ref="myDataSource" />
  42. <property name="annotatedClasses">
  43. <list>
  44. <value>com.srinivas.entity.Student</value>
  45. </list>
  46. </property>
  47. <property name="hibernateProperties">
  48. <props>
  49. <prop key="hibernate.dialect"> org.hibernate.dialect.MySQLDialect</prop>
  50. <prop key="hibernate.show_sql">true</prop>
  51. <!-- <prop key="hibernate.hbm2ddl.auto">create</prop> -->
  52. </props>
  53. </property>
  54. </bean>
  55.  
  56.  
  57. <bean id="template" class="org.springframework.orm.hibernate5.HibernateTemplate">
  58. <property name="sessionFactory" ref="mySessionFactory"></property>
  59. </bean>
  60.  
  61. <bean id="studentDAOImpl" class="com.srinivas.DAO.StudentDAOImpl">
  62. <property name="hibernateTemplate" ref="template" />
  63. </bean>
  64. </beans>
  65.  
  66. StudentDaoImpl class:
  67.  
  68. {
  69.  
  70. private HibernateTemplate hibernateTemplate;
  71.  
  72. public void setHibernateTemplate(HibernateTemplate hibernate) {
  73.  
  74. this.hibernateTemplate = hibernate;
  75.  
  76. //hibernateTemplate.clear();
  77. List<Student> students = new ArrayList<>();
  78. students = hibernateTemplate.loadAll(Student.class);
  79. for(Student s:students) {
  80.  
  81. System.out.println(s);
  82. }
  83. System.out.println(this.hibernateTemplate);
  84. }
  85.  
  86. @Override
  87. public List<Student> getAllStudents() {
  88. // TODO Auto-generated method stub
  89.  
  90. List<Student> students = new ArrayList<>();
  91. //hibernateTemplate.clear();
  92.  
  93. students = hibernateTemplate.loadAll(Student.class);
  94.  
  95. for(Student s:students) {
  96.  
  97. System.out.println(s);
  98. }
  99. return students;
  100. }
  101.  
  102. @Override
  103. public Student getStudent(int id) {
  104. // TODO Auto-generated method stub
  105. return null;
  106. }
  107.  
  108. @Override
  109. public void updateStudent(Student student) {
  110. // TODO Auto-generated method stub
  111.  
  112. }
  113.  
  114. @Override
  115. public void deleteStudent(Student student) {
  116. // TODO Auto-generated method stub
  117.  
  118. }
  119.  
  120. }
  121.  
  122.  
  123.  
  124.  
  125.  
  126.  
  127. hibernateTemplate methods are working fine in setHibernateTemplate() setter method
  128.  
  129. but in getAllStudents() they are throwing error
  130.  
  131. Excepiion stacktrace :
  132.  
  133. Apr 16, 2017 12:56:37 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
  134. WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:RigProject' did not find a matching property.
  135. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  136. INFO: Server version: Apache Tomcat/8.0.35
  137. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  138. INFO: Server built: May 11 2016 21:57:08 UTC
  139. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  140. INFO: Server number: 8.0.35.0
  141. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  142. INFO: OS Name: Windows 10
  143. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  144. INFO: OS Version: 10.0
  145. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  146. INFO: Architecture: amd64
  147. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  148. INFO: Java Home: C:Program FilesJavajre1.8.0_91
  149. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  150. INFO: JVM Version: 1.8.0_91-b15
  151. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  152. INFO: JVM Vendor: Oracle Corporation
  153. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  154. INFO: CATALINA_BASE: G:springhb.metadata.pluginsorg.eclipse.wst.server.coretmp0
  155. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  156. INFO: CATALINA_HOME: C:Program FilesApache Software FoundationTomcat 8.0
  157. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  158. INFO: Command line argument: -Dcatalina.base=G:springhb.metadata.pluginsorg.eclipse.wst.server.coretmp0
  159. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  160. INFO: Command line argument: -Dcatalina.home=C:Program FilesApache Software FoundationTomcat 8.0
  161. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  162. INFO: Command line argument: -Dwtp.deploy=G:springhb.metadata.pluginsorg.eclipse.wst.server.coretmp0wtpwebapps
  163. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  164. INFO: Command line argument: -Djava.endorsed.dirs=C:Program FilesApache Software FoundationTomcat 8.0endorsed
  165. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.VersionLoggerListener log
  166. INFO: Command line argument: -Dfile.encoding=Cp1252
  167. Apr 16, 2017 12:56:37 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
  168. INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:Program FilesJavajre1.8.0_91bin;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:/Program Files/Java/jre1.8.0_91/bin/server;C:/Program Files/Java/jre1.8.0_91/bin;C:/Program Files/Java/jre1.8.0_91/lib/amd64;C:ProgramDataOracleJavajavapath;c:MinGWbin;c:MinGWlibexecgccx86_64-pc-mingw326.2.0;C:Userssrinivasgccbin;C:Userssrinivasgcclibexecgccx86_64-pc-mingw326.2.0;C:appsrinivasproduct11.2.0dbhome_1bin;C:Program FilesJavajdk1.7.0_05bin;C:Program Files (x86)MySQLMySQL Fabric 1.5 & MySQL Utilities 1.5;C:Program Files (x86)MySQLMySQL Fabric 1.5 & MySQL Utilities 1.5Doctrine extensions for PHP;C:Program Files (x86)Windows Kits8.1Windows Performance Toolkit;C:Program FilesMicrosoft SQL Server110ToolsBinn;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:WINDOWSSystem32WindowsPowerShellv1.0;C:Program Filesnodejs;C:WindowsSystem32cmd.exe;C:Program FilesJavajdk1.8.0_91bin;C:Program FilesRR-3.2.2bin;C:UserssrinivasAppDataLocalMicrosoftWindowsApps;C:UserssrinivasAppDataRoamingnpm;C:apache-maven-3.3.9bin;C:UserssrinivasDesktop;;.
  169. Apr 16, 2017 12:56:37 AM org.apache.coyote.AbstractProtocol init
  170. INFO: Initializing ProtocolHandler ["http-nio-9000"]
  171. Apr 16, 2017 12:56:37 AM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
  172. INFO: Using a shared selector for servlet write/read
  173. Apr 16, 2017 12:56:37 AM org.apache.coyote.AbstractProtocol init
  174. INFO: Initializing ProtocolHandler ["ajp-nio-8009"]
  175. Apr 16, 2017 12:56:37 AM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
  176. INFO: Using a shared selector for servlet write/read
  177. Apr 16, 2017 12:56:37 AM org.apache.catalina.startup.Catalina load
  178. INFO: Initialization processed in 1027 ms
  179. Apr 16, 2017 12:56:37 AM org.apache.catalina.core.StandardService startInternal
  180. INFO: Starting service Catalina
  181. Apr 16, 2017 12:56:37 AM org.apache.catalina.core.StandardEngine startInternal
  182. INFO: Starting Servlet Engine: Apache Tomcat/8.0.35
  183. Apr 16, 2017 12:56:37 AM org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
  184. INFO: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [122] milliseconds.
  185. Apr 16, 2017 12:56:40 AM org.apache.jasper.servlet.TldScanner scanJars
  186. INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
  187. Apr 16, 2017 12:56:40 AM org.apache.catalina.core.ApplicationContext log
  188. INFO: No Spring WebApplicationInitializer types detected on classpath
  189. Apr 16, 2017 12:56:40 AM org.apache.catalina.core.ApplicationContext log
  190. INFO: Initializing Spring FrameworkServlet 'dispatcher'
  191. Apr 16, 2017 12:56:40 AM org.springframework.web.servlet.DispatcherServlet initServletBean
  192. INFO: FrameworkServlet 'dispatcher': initialization started
  193. Apr 16, 2017 12:56:40 AM org.springframework.web.context.support.XmlWebApplicationContext prepareRefresh
  194. INFO: Refreshing WebApplicationContext for namespace 'dispatcher-servlet': startup date [Sun Apr 16 00:56:40 IST 2017]; root of context hierarchy
  195. Apr 16, 2017 12:56:41 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
  196. INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/spring-mvc-crud-demo-servlet.xml]
  197. Apr 16, 2017 12:56:42 AM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
  198. INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
  199. Apr 16, 2017 12:56:42 AM org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping register
  200. INFO: Mapped "{[/hello]}" onto public java.lang.String com.srinivas.controller.RigController.HelloRig()
  201. Apr 16, 2017 12:56:42 AM org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter initControllerAdviceCache
  202. INFO: Looking for @ControllerAdvice: WebApplicationContext for namespace 'dispatcher-servlet': startup date [Sun Apr 16 00:56:40 IST 2017]; root of context hierarchy
  203. Apr 16, 2017 12:56:42 AM org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter initControllerAdviceCache
  204. INFO: Looking for @ControllerAdvice: WebApplicationContext for namespace 'dispatcher-servlet': startup date [Sun Apr 16 00:56:40 IST 2017]; root of context hierarchy
  205. Apr 16, 2017 12:56:43 AM org.hibernate.Version logVersion
  206. INFO: HHH000412: Hibernate Core {5.2.1.Final}
  207. Apr 16, 2017 12:56:43 AM org.hibernate.cfg.Environment <clinit>
  208. INFO: HHH000206: hibernate.properties not found
  209. Apr 16, 2017 12:56:43 AM org.hibernate.cfg.Environment buildBytecodeProvider
  210. INFO: HHH000021: Bytecode provider name : javassist
  211. Apr 16, 2017 12:56:43 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
  212. INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  213. Sun Apr 16 00:56:43 IST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  214. Sun Apr 16 00:56:43 IST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  215. Apr 16, 2017 12:56:43 AM org.hibernate.dialect.Dialect <init>
  216. INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
  217. Apr 16, 2017 12:56:45 AM org.hibernate.internal.SessionImpl createCriteria
  218. WARN: HHH90000022: Hibernate's legacy org.hibernate.Criteria API is deprecated; use the JPA javax.persistence.criteria.CriteriaQuery instead
  219. Hibernate: select this_.id as id1_0_0_, this_.gender as gender2_0_0_, this_.hobies as hobies3_0_0_, this_.language as language4_0_0_, this_.name as name5_0_0_ from student this_
  220. Student [id=1, name=Srinivas, gender=m, language=Telugu, hobies=cricket]
  221. Student [id=2, name=ABC, gender=m, language=Engilish, hobies=cricket]
  222. org.springframework.orm.hibernate5.HibernateTemplate@3c940b65
  223. Apr 16, 2017 12:56:45 AM org.springframework.web.servlet.DispatcherServlet initServletBean
  224. INFO: FrameworkServlet 'dispatcher': initialization completed in 4442 ms
  225. Apr 16, 2017 12:56:45 AM org.apache.coyote.AbstractProtocol start
  226. INFO: Starting ProtocolHandler ["http-nio-9000"]
  227. Apr 16, 2017 12:56:45 AM org.apache.coyote.AbstractProtocol start
  228. INFO: Starting ProtocolHandler ["ajp-nio-8009"]
  229. Apr 16, 2017 12:56:45 AM org.apache.catalina.startup.Catalina start
  230. INFO: Server startup in 7949 ms
  231. before gas
  232. Apr 16, 2017 12:56:48 AM org.apache.catalina.core.StandardWrapperValve invoke
  233. SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/RigProject] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause
  234. java.lang.NullPointerException
  235. at com.srinivas.DAO.StudentDAOImpl.getAllStudents(StudentDAOImpl.java:37)
  236. at com.srinivas.controller.RigController.HelloRig(RigController.java:17)
  237. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  238. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  239. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  240. at java.lang.reflect.Method.invoke(Unknown Source)
  241. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  242. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
  243. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:114)
  244. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  245. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  246. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  247. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
  248. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
  249. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  250. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  251. at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
  252. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  253. at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  254. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
  255. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
  256. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  257. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
  258. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
  259. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
  260. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  261. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  262. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
  263. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  264. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
  265. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  266. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
  267. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
  268. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
  269. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
  270. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
  271. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  272. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  273. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  274. at java.lang.Thread.run(Unknown Source)
Add Comment
Please, Sign In to add comment