Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <beans xmlns="http://www.springframework.org/schema/beans"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
- xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mvc="http://www.springframework.org/schema/mvc"
- xmlns:aop="http://www.springframework.org/schema/aop"
- xsi:schemaLocation="http://www.springframework.org/schema/beans
- http://www.springframework.org/schema/beans/spring-beans.xsd
- http://www.springframework.org/schema/context
- http://www.springframework.org/schema/context/spring-context.xsd
- http://www.springframework.org/schema/mvc
- http://www.springframework.org/schema/mvc/spring-mvc.xsd
- http://www.springframework.org/schema/tx
- http://www.springframework.org/schema/tx/spring-tx.xsd
- http://www.springframework.org/schema/aop
- http://www.springframework.org/schema/aop/spring-aop.xsd">
- <mvc:annotation-driven />
- <!-- <mvc:default-servlet-handler/> -->
- <mvc:resources mapping="/resources/**" location="WEB-INF/resources/" />
- <context:component-scan base-package="com.slv.controller" />
- <!-- JDBC Properties -->
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
- <property name="driverClassName" value="com.mysql.jdbc.Driver" />
- <property name="url" value="jdbc:mysql://localhost:3306/webslcm" />
- <property name="username" value="root" />
- <property name="password" value="root" />
- </bean>
- <!-- Accounts -->
- <bean id="accountsDaoImpl" class="com.slv.daoimpl.AccountsDaoImpl">
- <property name="sessionFactory" ref="sessionFactory" />
- </bean>
- <!-- Hibernate Session properties -->
- <bean id="sessionFactory"
- class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
- <property name="dataSource" ref="dataSource" />
- <property name="packagesToScan" value="com.slv.model" />
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
- <prop key="hibernate.show_sql">true</prop>
- <prop key="hibernate.hbm2ddl.auto">update</prop>
- </props>
- </property>
- </bean>
- <!-- ViewResolver Spring Will redirecting -->
- <bean
- class="org.springframework.web.servlet.view.InternalResourceViewResolver">
- <property name="prefix" value="/WEB-INF/resources/jsp/" />
- <property name="suffix" value=".jsp" />
- </bean>
- <%
- AccountsDaoImpl accountsDaoImpl = new AccountsDaoImpl();
- List<Object[]> list = accountsDaoImpl.getSQLObjectValues("SELECT examId, examName FROM examtypes", session);
- %>
- public class AccountsDaoImpl implements AccountsDao{
- @Autowired
- public SessionFactory sessionFactory;
- @Override
- public List<Object[]> getSQLObjectValues(String sqlQuery, HttpSession session2) {
- Session session=sessionFactory.openSession(); // Here im getting the below exception
- session.beginTransaction();
- try{
- Query query = session.createSQLQuery(sqlQuery);
- List<Object[]> list=query.list();
- return list;
- }catch(Exception e){
- e.printStackTrace();
- }finally{
- session.close();sessionFactory.close();
- }
- return null;
- }
- }
- java.lang.NullPointerException
- at com.slv.daoimpl.AccountsDaoImpl.getSQLObjectValues(AccountsDaoImpl.java:384)
- at org.apache.jsp.WEB_002dINF.resources.jsp.reUsableReport_jsp._jspService(reUsableReport_jsp.java:179)
- at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
- at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
- at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
- at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
- at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
- at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
- at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
- at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
- at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:168)
- at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:303)
- at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1244)
- at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1027)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:971)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
- at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
- at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
- at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
- at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
- at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
- at java.lang.Thread.run(Unknown Source)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement