Advertisement
Guest User

Untitled

a guest
Apr 26th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.04 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
  4. xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mvc="http://www.springframework.org/schema/mvc"
  5. xmlns:aop="http://www.springframework.org/schema/aop"
  6. xsi:schemaLocation="http://www.springframework.org/schema/beans
  7. http://www.springframework.org/schema/beans/spring-beans.xsd
  8. http://www.springframework.org/schema/context
  9. http://www.springframework.org/schema/context/spring-context.xsd
  10. http://www.springframework.org/schema/mvc
  11. http://www.springframework.org/schema/mvc/spring-mvc.xsd
  12. http://www.springframework.org/schema/tx
  13. http://www.springframework.org/schema/tx/spring-tx.xsd
  14. http://www.springframework.org/schema/aop
  15. http://www.springframework.org/schema/aop/spring-aop.xsd">
  16.  
  17. <mvc:annotation-driven />
  18. <!-- <mvc:default-servlet-handler/> -->
  19. <mvc:resources mapping="/resources/**" location="WEB-INF/resources/" />
  20. <context:component-scan base-package="com.slv.controller" />
  21.  
  22. <!-- JDBC Properties -->
  23. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  24. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  25. <property name="url" value="jdbc:mysql://localhost:3306/webslcm" />
  26. <property name="username" value="root" />
  27. <property name="password" value="root" />
  28. </bean>
  29.  
  30. <!-- Accounts -->
  31. <bean id="accountsDaoImpl" class="com.slv.daoimpl.AccountsDaoImpl">
  32. <property name="sessionFactory" ref="sessionFactory" />
  33. </bean>
  34.  
  35. <!-- Hibernate Session properties -->
  36. <bean id="sessionFactory"
  37. class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  38. <property name="dataSource" ref="dataSource" />
  39. <property name="packagesToScan" value="com.slv.model" />
  40. <property name="hibernateProperties">
  41. <props>
  42. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
  43. <prop key="hibernate.show_sql">true</prop>
  44. <prop key="hibernate.hbm2ddl.auto">update</prop>
  45. </props>
  46. </property>
  47. </bean>
  48.  
  49. <!-- ViewResolver Spring Will redirecting -->
  50. <bean
  51. class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  52. <property name="prefix" value="/WEB-INF/resources/jsp/" />
  53. <property name="suffix" value=".jsp" />
  54. </bean>
  55.  
  56. <%
  57. AccountsDaoImpl accountsDaoImpl = new AccountsDaoImpl();
  58. List<Object[]> list = accountsDaoImpl.getSQLObjectValues("SELECT examId, examName FROM examtypes", session);
  59. %>
  60.  
  61. public class AccountsDaoImpl implements AccountsDao{
  62.  
  63. @Autowired
  64. public SessionFactory sessionFactory;
  65.  
  66. @Override
  67. public List<Object[]> getSQLObjectValues(String sqlQuery, HttpSession session2) {
  68. Session session=sessionFactory.openSession(); // Here im getting the below exception
  69. session.beginTransaction();
  70. try{
  71. Query query = session.createSQLQuery(sqlQuery);
  72. List<Object[]> list=query.list();
  73. return list;
  74. }catch(Exception e){
  75. e.printStackTrace();
  76. }finally{
  77. session.close();sessionFactory.close();
  78. }
  79. return null;
  80. }
  81. }
  82.  
  83. java.lang.NullPointerException
  84. at com.slv.daoimpl.AccountsDaoImpl.getSQLObjectValues(AccountsDaoImpl.java:384)
  85. at org.apache.jsp.WEB_002dINF.resources.jsp.reUsableReport_jsp._jspService(reUsableReport_jsp.java:179)
  86. at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
  87. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  88. at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
  89. at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
  90. at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
  91. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  92. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  93. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  94. at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
  95. at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
  96. at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
  97. at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
  98. at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:168)
  99. at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:303)
  100. at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1244)
  101. at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1027)
  102. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:971)
  103. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
  104. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  105. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  106. at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  107. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  108. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  109. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  110. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  111. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  112. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  113. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  114. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  115. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
  116. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
  117. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  118. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  119. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
  120. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
  121. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  122. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  123. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  124. at java.lang.Thread.run(Unknown Source)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement