Advertisement
Guest User

Untitled

a guest
Apr 21st, 2015
281
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.34 KB | None | 0 0
  1. Caused by: org.hibernate.TransactionException: unable to commit against JDBC connection
  2. at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:116) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]
  3. at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:180) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]
  4. ... 194 more
  5. Caused by: java.sql.SQLException: You cannot commit during a managed transaction!
  6. at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1065)
  7. at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758)
  8. at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]
  9. ... 195 more
  10.  
  11. <?xml version='1.0' encoding='utf-8'?>
  12. <!DOCTYPE hibernate-configuration PUBLIC
  13. "-//Hibernate/Hibernate Configuration DTD//EN"
  14. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  15. <hibernate-configuration>
  16. <session-factory>
  17. <property name="connection.datasource">java:/jdbc/salome-database</property>
  18. <property name="hibernate.current_session_context_class">thread</property>
  19. <property name="hibernate.show_sql">true</property>
  20. <property name="hibernate.archive.autodetection">class</property>
  21. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  22.  
  23. <mapping resource="hibernate-mapping.xml"/>
  24.  
  25. </session-factory>
  26. </hibernate-configuration>
  27.  
  28. public static SessionFactory getSessionFactory()
  29. {
  30. if (sessionFactory == null)
  31. {
  32. // loads configuration and mappings
  33. Configuration configuration = new Configuration().configure();
  34. ServiceRegistry serviceRegistry
  35. = new StandardServiceRegistryBuilder()
  36. .applySettings(configuration.getProperties()).build();
  37.  
  38. // builds a session factory from the service registry
  39. sessionFactory = configuration.buildSessionFactory(serviceRegistry);
  40. }
  41.  
  42. return sessionFactory;
  43. }
  44.  
  45. public Event getById(int id)
  46. {
  47. List<Event> eventList = new ArrayList<Event>();
  48.  
  49. Session session = sessionFactory.getCurrentSession();
  50. session.getTransaction().begin();
  51.  
  52. try
  53. {
  54. Query q = session.createQuery("from Event as event where event.id='" + id + "'");
  55. q.setCacheable(true);
  56. eventList = (List<Event>) q.list();
  57. session.getTransaction().commit();
  58. }
  59.  
  60. catch (RuntimeException e)
  61. {
  62. throw e;
  63. }
  64.  
  65. finally
  66. {
  67. }
  68.  
  69. if (eventList.isEmpty())
  70. {
  71. return null;
  72. }
  73. else
  74. {
  75. return eventList.get(0);
  76. }
  77. }
  78.  
  79. public void addEvent(Event event)
  80. {
  81. Session session = sessionFactory.getCurrentSession();
  82. session.getTransaction().begin();
  83.  
  84. try
  85. {
  86. session.save(event);
  87. session.getTransaction().commit();
  88. }
  89.  
  90. catch (RuntimeException e)
  91. {
  92. throw e;
  93. }
  94.  
  95. finally
  96. {
  97. }
  98. }
  99.  
  100. public void deleteEvent(Event event)
  101. {
  102. Session session = sessionFactory.getCurrentSession();
  103. session.getTransaction().begin();
  104.  
  105. try
  106. {
  107. session.delete(event);
  108. session.getTransaction().commit();
  109. }
  110.  
  111. catch (RuntimeException e)
  112. {
  113. throw e;
  114. }
  115.  
  116. finally
  117. {
  118. }
  119. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement