API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 18th, 2018
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.40 KB | None | 0 0
raw download clone embed print report
  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"
  4. xmlns:context="http://www.springframework.org/schema/context"
  5. xmlns:mvc="http://www.springframework.org/schema/mvc"
  6. xmlns:tx="http://www.springframework.org/schema/tx"
  7. xmlns:jee="http://www.springframework.org/schema/jee"
  8. xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
  9. http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.3.xsd
  10. http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  11. http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
  12. http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
  13.  
  14.  
  15. <context:annotation-config></context:annotation-config>
  16. <context:component-scan
  17. base-package="com.schoolproject.controllers">
  18. </context:component-scan>
  19. <bean id="views"
  20. class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  21. <property name="prefix" value="/WEB-INF/jsps/"></property>
  22. <property name="suffix" value=".jsp"></property>
  23. </bean>
  24.  
  25. <mvc:annotation-driven></mvc:annotation-driven>
  26.  
  27. <mvc:resources mapping="/static/**" location="/static/"
  28. cache-period="31556926"/>
  29.  
  30.  
  31. </beans>
  32.  
  33. <?xml version="1.0" encoding="UTF-8"?>
  34. <beans xmlns="http://www.springframework.org/schema/beans"
  35. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  36. xmlns:context="http://www.springframework.org/schema/context"
  37. xmlns:mvc="http://www.springframework.org/schema/mvc"
  38. xmlns:tx="http://www.springframework.org/schema/tx"
  39. xmlns:jee="http://www.springframework.org/schema/jee"
  40. xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
  41. http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.3.xsd
  42. http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  43. http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
  44. http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
  45.  
  46. <context:annotation-config></context:annotation-config>
  47. <context:component-scan base-package="com.schoolproject.service"></context:component-scan>
  48.  
  49.  
  50.  
  51. <bean id="dataSource"
  52. class="org.apache.commons.dbcp.BasicDataSource">
  53. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  54. <property name="url" value="jdbc:mysql://localhost:3306/schoolproject" />
  55. <property name="username" value="root" />
  56. <property name="password" value="" />
  57. </bean>
  58.  
  59. <bean id="sessionFactory"
  60. class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
  61. <property name="dataSource" ref="dataSource" />
  62. <property name="packagesToScan" value="com.schoolproject.dao"/>
  63.  
  64.  
  65. <property name="hibernateProperties">
  66. <props>
  67. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
  68. <prop key="hibernate.current_session_context_class">thread</prop>
  69.  
  70. </props>
  71. </property>
  72. </bean>
  73. <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
  74. <property name="sessionFactory" ref="sessionFactory" />
  75. </bean>
  76.  
  77.  
  78. <tx:annotation-driven transaction-manager="transactionManager" />
  79. </beans>
  80.  
  81. <?xml version="1.0" encoding="UTF-8"?>
  82. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
  83. <display-name>schoolproject</display-name>
  84. <welcome-file-list>
  85. <welcome-file>index.html</welcome-file>
  86. <welcome-file>index.htm</welcome-file>
  87. <welcome-file>index.jsp</welcome-file>
  88. <welcome-file>default.html</welcome-file>
  89. <welcome-file>default.htm</welcome-file>
  90. <welcome-file>default.jsp</welcome-file>
  91. </welcome-file-list>
  92. <servlet>
  93. <servlet-name>home</servlet-name>
  94. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  95. <load-on-startup>1</load-on-startup>
  96. </servlet>
  97.  
  98. <servlet-mapping>
  99. <servlet-name>home</servlet-name>
  100. <url-pattern>/</url-pattern>
  101. </servlet-mapping>
  102.  
  103. <listener>
  104. <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  105. </listener>
  106. <context-param>
  107. <param-name>contextConfigLocation</param-name>
  108. <param-value>/WEB-INF/service-context.xml</param-value>
  109. </context-param>
  110. </web-app>
  111.  
  112. package com.schoolproject.service;
  113.  
  114. import com.schoolproject.dao.AdminDao;
  115.  
  116. import java.util.List;
  117.  
  118. import org.hibernate.Session;
  119. import org.hibernate.SessionFactory;
  120. import org.hibernate.cfg.Configuration;
  121. import org.springframework.beans.factory.annotation.Autowired;
  122. import org.springframework.stereotype.Component;
  123. import org.springframework.stereotype.Service;
  124. import org.springframework.transaction.annotation.Transactional;
  125.  
  126. @Service
  127. public class MyConnection {
  128.  
  129. private SessionFactory sessionFactory;
  130.  
  131. @Autowired
  132. public void setSessionFactory(SessionFactory sessionFactory) {
  133. this.sessionFactory = sessionFactory;
  134. }
  135.  
  136. @Transactional
  137. public List<AdminDao> getAdmin(){
  138. Session session=sessionFactory.getCurrentSession();
  139.  
  140. List<AdminDao>admin=(List<AdminDao>)session.createQuery("from AdminDao").list();
  141. return admin;
  142.  
  143. }
  144.  
  145.  
  146. }
  147.  
  148. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  149. <modelVersion>4.0.0</modelVersion>
  150. <groupId>com.school.beta</groupId>
  151. <artifactId>schoolproject</artifactId>
  152. <version>0.0.1-SNAPSHOT</version>
  153. <packaging>war</packaging>
  154. <dependencies>
  155. <!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
  156. <dependency>
  157. <groupId>org.springframework</groupId>
  158. <artifactId>spring-web</artifactId>
  159. <version>4.3.9.RELEASE</version>
  160. </dependency>
  161. <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
  162. <dependency>
  163. <groupId>org.springframework</groupId>
  164. <artifactId>spring-webmvc</artifactId>
  165. <version>4.3.9.RELEASE</version>
  166. </dependency>
  167. <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
  168. <dependency>
  169. <groupId>org.hibernate</groupId>
  170. <artifactId>hibernate-core</artifactId>
  171. <version>5.2.10.Final</version>
  172. </dependency>
  173. <!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
  174. <dependency>
  175. <groupId>org.springframework</groupId>
  176. <artifactId>spring-orm</artifactId>
  177. <version>4.3.9.RELEASE</version>
  178. </dependency>
  179.  
  180.  
  181. <dependency>
  182. <groupId>commons-dbcp</groupId>
  183. <artifactId>commons-dbcp</artifactId>
  184. <version>1.4</version>
  185. </dependency>
  186.  
  187. <!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
  188. <dependency>
  189. <groupId>org.springframework</groupId>
  190. <artifactId>spring-tx</artifactId>
  191. <version>4.3.9.RELEASE</version>
  192. </dependency>
  193.  
  194. <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjrt -->
  195. <dependency>
  196. <groupId>org.aspectj</groupId>
  197. <artifactId>aspectjrt</artifactId>
  198. <version>1.7.3</version>
  199. </dependency>
  200.  
  201. </dependencies>
  202.  
  203. </project>
  204.  
  205. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.HibernateException: createQuery is not valid without active transaction
  206. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
  207. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  208. javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  209. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  210. javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  211. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  212. Root Cause
  213.  
  214. org.hibernate.HibernateException: createQuery is not valid without active transaction
  215. org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:351)
  216. com.sun.proxy.$Proxy25.createQuery(Unknown Source)
  217. com.schoolproject.service.MyConnection.getAdmin(MyConnection.java:29)
  218. com.schoolproject.service.MyConnection$$FastClassBySpringCGLIB$$3f115519.invoke(<generated>)
  219. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  220. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
  221. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  222. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  223. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
  224. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  225. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  226. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
  227. com.schoolproject.service.MyConnection$$EnhancerBySpringCGLIB$$39d60569.getAdmin(<generated>)
  228. com.schoolproject.controllers.MainController.registeruser(MainController.java:32)
  229. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  230. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  231. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  232. java.lang.reflect.Method.invoke(Unknown Source)
  233. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  234. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  235. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  236. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  237. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  238. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  239. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  240. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  241. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  242. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  243. javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  244. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  245. javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  246. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!