Advertisement
Guest User

Untitled

a guest
Jan 13th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.67 KB | None | 0 0
  1. <datasource jta="true" jndi-name="java:jboss/datasources/mydb"
  2. pool-name="DB" enabled="true" use-ccm="true">
  3. <connection-url>jdbc:mysql://localhost:3306/mydb</connection-url>
  4. <driver-class>com.mysql.jdbc.Driver</driver-class>
  5. <driver>mysql</driver>
  6. <security>
  7. <user-name>****</user-name>
  8. <password>****</password>
  9. </security>
  10. <validation>
  11. <valid-connection-checker
  12. class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker" />
  13. <background-validation>true</background-validation>
  14. <exception-sorter
  15. class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter" />
  16. </validation>
  17. </datasource>
  18.  
  19. <persistence-unit name="PU_DB" transaction-type="RESOURCE_LOCAL">
  20. <non-jta-data-source>java:jboss/datasources/mydb</non-jta-data-source>
  21. <class>X.Y.Z.model.Employee</class>
  22. <properties>
  23. <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform"/>
  24. </properties>
  25.  
  26. <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />
  27.  
  28. <bean id="employeeService" class="X.Y.Z.service.EmployeeServiceImpl" />
  29. <bean id="employeeDao" class="X.Y.Z.dao.EmployeeDaoImpl" />
  30.  
  31. <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" >
  32. <property name="dataSource" ref="dataSource" />
  33. <property name="jpaVendorAdapter">
  34. <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
  35. <property name="database" value="MYSQL" />
  36. <property name="showSql" value="true" />
  37. </bean>
  38. </property>
  39. <property name="persistenceUnitName" value="PU_DB" />
  40. </bean>
  41.  
  42. <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  43. <property name="jndiName" value="java:jboss/datasources/mydb"/>
  44. </bean>
  45.  
  46. <bean id="TU_DB"
  47. class="org.springframework.orm.jpa.JpaTransactionManager">
  48. <property name="entityManagerFactory" ref="entityManagerFactory" />
  49. </bean>
  50.  
  51. <tx:annotation-driven transaction-manager="TU_DB" />
  52.  
  53. @Repository
  54. @Transactional(X.Y.Z.utils.ClassUtil.TU_DB)
  55. public class EmployeeDaoImpl implements EmployeeDao {
  56. @PersistenceContext(unitName = X.Y.Z.utils.ClassUtil.PU_DB)
  57. private EntityManager em;
  58. public List<Employee> getEmployes() {
  59. TypedQuery<Employee> queryList = em.createQuery("from Employee",Employee.class);
  60. return queryList.getResultList();
  61. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement