API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.47 KB | None | 0 0
raw download clone embed print report
  1. org.springframework.dao.InvalidDataAccessApiUsageException: Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query
  2. at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:413)
  3. at org.springframework.orm.hibernate5.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:55)
  4. at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
  5. at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
  6. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
  7. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  8. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  9. at com.sun.proxy.$Proxy39.deleteWalletInfoById(Unknown Source)
  10. at mobi.puut.services.WalletServiceImpl.deleteWalletInfoById(WalletServiceImpl.java:279)
  11. at mobi.puut.controllers.WalletRestController.deleteWalletInfoById(WalletRestController.java:83)
  12. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  13. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  14. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  15. at java.lang.reflect.Method.invoke(Method.java:498)
  16. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  17. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  18. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  19. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  20. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  21. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  22. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  23. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  24. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  25. at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkServlet.java:894)
  26. at javax.servlet.http.HttpServlet.service(HttpServlet.java:667)
  27. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  28. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  29. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  30. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  31. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  32. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  33. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  34. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  35. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  36. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  37. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  38. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  39. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
  40. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  41. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  42. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  43. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  44. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  45. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  46. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  47. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  48. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  49. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  50. at java.lang.Thread.run(Thread.java:748)
  51. Caused by: javax.persistence.TransactionRequiredException: Executing an update/delete query
  52. at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1496)
  53. at mobi.puut.database.WalletInfoDaoHibernate.deleteWalletInfoById(WalletInfoDaoHibernate.java:83)
  54. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  55. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  56. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  57. at java.lang.reflect.Method.invoke(Method.java:498)
  58. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
  59. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  60. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  61. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
  62. ... 44 more
  63.  
  64. Caused by: javax.persistence.TransactionRequiredException: Executing an update/delete query
  65. at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1496)
  66. at mobi.puut.database.WalletInfoDaoHibernate.deleteWalletInfoById(WalletInfoDaoHibernate.java:83)
  67. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  68. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  69. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  70. at java.lang.reflect.Method.invoke(Method.java:498)
  71.  
  72. @Entity
  73. @Table(name = "wallet_info")
  74. public class WalletInfo {
  75.  
  76. @Id
  77. @Column(name = "id")
  78. @NotNull
  79. @GeneratedValue(strategy = GenerationType.AUTO)
  80. private Long id;
  81.  
  82. @NotNull
  83. @Column(name = "name")
  84. private String name;
  85.  
  86. @NotNull
  87. @Column(name = "address")
  88. private String address;
  89.  
  90.  
  91. public Long getId() {
  92. return id;
  93. }
  94.  
  95. public void setId(Long id) {
  96. this.id = id;
  97. }
  98.  
  99. public String getName() {
  100. return name;
  101. }
  102.  
  103. public void setName(String name) {
  104. this.name = name;
  105. }
  106.  
  107. public String getAddress() {
  108. return address;
  109. }
  110.  
  111. public void setAddress(String address) {
  112. this.address = address;
  113. }
  114. }
  115.  
  116. @Configuration
  117. @EnableWebMvc
  118. @EnableTransactionManagement
  119. @ComponentScan(basePackages = {"mobi.puut.controllers"})
  120. class ApplicationConfiguration extends WebMvcConfigurerAdapter {
  121.  
  122. @Override
  123. public void configureDefaultServletHandling(DefaultServletHandlerConfigurer configurer) {
  124. configurer.enable();
  125. }
  126.  
  127. @Bean
  128. public InternalResourceViewResolver jspViewResolver() {
  129. InternalResourceViewResolver bean = new InternalResourceViewResolver();
  130. bean.setPrefix("/WEB-INF/jsps/");
  131. bean.setSuffix(".jsp");
  132. return bean;
  133. }
  134.  
  135. @Bean
  136. public PlatformTransactionManager transactionManager(EntityManagerFactory emf){
  137. JpaTransactionManager transactionManager = new JpaTransactionManager();
  138. transactionManager.setEntityManagerFactory(emf);
  139. return transactionManager;
  140. }
  141.  
  142. @Bean
  143. public PersistenceExceptionTranslationPostProcessor exceptionTranslation(){
  144. return new PersistenceExceptionTranslationPostProcessor();
  145. }
  146.  
  147. @Override
  148. public void addResourceHandlers(ResourceHandlerRegistry registry) {
  149. registry.addResourceHandler("/static/**").addResourceLocations("/resources/");
  150. }
  151.  
  152. // @Bean(name = "multipartResolver")
  153. // public CommonsMultipartResolver getMultipartResolver() {
  154. // return new CommonsMultipartResolver();
  155. // }
  156.  
  157. // @Bean
  158. // public MultipartResolver multipartResolver() {
  159. // CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver();
  160. // multipartResolver.setMaxUploadSize(5242880);
  161. // return multipartResolver;
  162. // }
  163.  
  164. // @Bean(name = "messageSource")
  165. // public ReloadableResourceBundleMessageSource getMessageSource() {
  166. // ReloadableResourceBundleMessageSource resource = new ReloadableResourceBundleMessageSource();
  167. // resource.setBasename("classpath:messages");
  168. // resource.setDefaultEncoding("UTF-8");
  169. // return resource;
  170. // }
  171.  
  172. // @Bean
  173. // public InternalResourceViewResolver htmlViewResolver() {
  174. // InternalResourceViewResolver bean = new InternalResourceViewResolver();
  175. // bean.setPrefix("/WEB-INF/html/");
  176. // bean.setSuffix(".html");
  177. // bean.setOrder(2);
  178. // return bean;
  179. // }
  180. }
  181.  
  182. @Configuration
  183. @EnableWebMvc
  184. @EnableTransactionManagement
  185. @ComponentScan(basePackages = {"mobi.puut.database"})
  186. public class DatabaseConfig {
  187.  
  188. @Bean
  189. public LocalSessionFactoryBean sessionFactory() {
  190.  
  191. LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
  192. sessionFactory.setDataSource(dataSource());
  193. sessionFactory.setPackagesToScan(
  194. new String[]{"com.form.handler.entities"});
  195. sessionFactory.setHibernateProperties(hibernateProperties());
  196.  
  197. return sessionFactory;
  198. }
  199.  
  200. // @Bean
  201. // public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
  202. //
  203. // LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
  204. // em.setDataSource(dataSource());
  205. //
  206. // em.setPackagesToScan(new String[]{"com.form.handler.entities"});
  207. //
  208. // JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
  209. // em.setJpaVendorAdapter(vendorAdapter);
  210. //
  211. // // set the hibernate properties for the project
  212. // em.setJpaProperties(hibernateProperties());
  213. //
  214. // return em;
  215. // }
  216.  
  217. @Bean
  218. @Autowired
  219. public HibernateTransactionManager transactionManager(
  220. SessionFactory sessionFactory) {
  221.  
  222. HibernateTransactionManager txManager
  223. = new HibernateTransactionManager();
  224. txManager.setSessionFactory(sessionFactory);
  225.  
  226. return txManager;
  227. }
  228.  
  229. @Bean
  230. public PersistenceExceptionTranslationPostProcessor exceptionTranslation() {
  231. return new PersistenceExceptionTranslationPostProcessor();
  232. }
  233.  
  234. @Bean
  235. public DataSource dataSource() {
  236.  
  237. DriverManagerDataSource dataSource = new DriverManagerDataSource();
  238. dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
  239.  
  240. // dataSource.setUrl("jdbc:mysql://localhost:3306/wallet?createDatabaseIfNotExist=true");
  241. dataSource.setUrl("jdbc:mysql://localhost:3306/wallet1");
  242. dataSource.setUsername("testuser");
  243. dataSource.setPassword("testpassword");
  244.  
  245. return dataSource;
  246. }
  247.  
  248. Properties hibernateProperties() {
  249. Properties properties = new Properties();
  250. // properties.setProperty("hibernate.hbm2ddl.auto", "create-drop");
  251. properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
  252. return properties;
  253. }
  254. }
  255.  
  256. @Configuration
  257. @EnableWebMvc
  258. @ComponentScan(basePackages = {"mobi.puut.services"})
  259. public class ServiceConfig {
  260.  
  261. }
  262.  
  263. public class WebInitializer implements WebApplicationInitializer {
  264.  
  265.  
  266. public void onStartup(ServletContext container) throws ServletException {
  267.  
  268. AnnotationConfigWebApplicationContext ctx = new AnnotationConfigWebApplicationContext();
  269.  
  270. ctx.register(ApplicationConfiguration.class, ServiceConfig.class,
  271. DatabaseConfig.class);
  272.  
  273. ctx.setServletContext(container);
  274.  
  275. // Manage the lifecycle of the root application context
  276. container.addListener(new ContextLoaderListener(ctx));
  277.  
  278. ServletRegistration.Dynamic servlet = container.addServlet("dispatcher-servlet", new DispatcherServlet(ctx));
  279.  
  280. servlet.setLoadOnStartup(1);
  281. servlet.addMapping("/");
  282.  
  283. }
  284.  
  285. // @Override
  286. // public void onStartup(ServletContext container) {
  287. // // Create the 'root' Spring application context
  288. // AnnotationConfigWebApplicationContext rootContext = new AnnotationConfigWebApplicationContext();
  289. // rootContext.register(ServiceConfig.class, JPAConfig.class, SecurityConfig.class);
  290. //
  291. // // Manage the lifecycle of the root application context
  292. // container.addListener(new ContextLoaderListener(rootContext));
  293. //
  294. // // Create the dispatcher servlet's Spring application context
  295. // AnnotationConfigWebApplicationContext dispatcherServlet = new AnnotationConfigWebApplicationContext();
  296. // dispatcherServlet.register(MvcConfig.class);
  297. //
  298. // // Register and map the dispatcher servlet
  299. // ServletRegistration.Dynamic dispatcher = container.addServlet("dispatcher", new DispatcherServlet(dispatcherServlet));
  300. // dispatcher.setLoadOnStartup(1);
  301. // dispatcher.addMapping("/");
  302. //
  303. // }
  304. }
  305.  
  306. @Service
  307. @Transactional
  308. public class WalletServiceImpl implements WalletService {
  309.  
  310. @Autowired
  311. private UserDao userDao;
  312.  
  313. @Autowired
  314. private StatusDao statusDao;
  315.  
  316. @Autowired
  317. private WalletInfoDao walletInfoDao;
  318.  
  319. @Override
  320. public void deleteWalletInfoById(Long id) {
  321. walletInfoDao.deleteWalletInfoById(id);
  322. }
  323. }
  324.  
  325. @Repository
  326. public class WalletInfoDaoHibernate
  327. extends HibernateDaoSupport
  328. implements WalletInfoDao {
  329.  
  330.  
  331. @Override
  332. public void deleteWalletInfoById(Long id) {
  333.  
  334. try (Session session = getSessionFactory().openSession()) {
  335.  
  336. Query query = session.createQuery("delete WalletInfo where id = :id");
  337. query.setParameter("id", id);
  338. int result = query.executeUpdate();
  339.  
  340. System.out.println("Result = " + result);
  341.  
  342. } catch (HibernateException e) {
  343.  
  344. System.out.println("No result");
  345. e.printStackTrace();
  346. }
  347. }
  348. }
  349.  
  350. // delete a wallet with the Id
  351. @RequestMapping(value = "/delete/{id}", method = RequestMethod.DELETE)
  352. public ResponseEntity<WalletInfo> deleteWalletInfoById(@PathVariable("id") long id) {
  353.  
  354. WalletInfo walletInfo = walletService.getWalletInfo(id);
  355.  
  356. if (walletInfo == null) {
  357. System.out.println("The WalletInfo obj with id = " + id + " is not found");
  358. return new ResponseEntity<WalletInfo>(HttpStatus.NOT_FOUND);
  359. }
  360.  
  361. walletService.deleteWalletInfoById(id);
  362. return new ResponseEntity<WalletInfo>(HttpStatus.NO_CONTENT);
  363. }
  364.  
  365. @Override
  366. public void deleteWalletInfoById(Long theId) {
  367.  
  368. // get the current hibernate session
  369. Session currentSession = getSessionFactory().getCurrentSession();
  370.  
  371. // delete object with primary key
  372. Query theQuery =
  373. currentSession.createQuery("delete WalletInfo where id=:walletId");
  374. theQuery.setParameter("walletId", theId);
  375.  
  376. theQuery.executeUpdate();
  377. }
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!