Guest User

Untitled

a guest
Oct 17th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.64 KB | None | 0 0
  1. @Entity
  2. @Table(name = "user", schema = "public")
  3. public class User extends BaseEntity {
  4.  
  5. private Integer id;
  6. private String name;
  7. private Integer contractId;
  8.  
  9. public User() {
  10. }
  11.  
  12. public User(Integer id) {
  13. super(id);
  14. }
  15.  
  16. @Id
  17. @Column(name = "usr_id", nullable = false)
  18. @GeneratedValue(strategy= GenerationType.IDENTITY)
  19. public Integer getId() {
  20. return id;
  21. }
  22.  
  23. public void setId(Integer id) {
  24. this.id = id;
  25. }
  26.  
  27. @Basic
  28. @Column(name = "usr_name", nullable = true, length = -1)
  29. public String getName() {
  30. return name;
  31. }
  32.  
  33. public void setName(String name) {
  34. this.name = name;
  35. }
  36.  
  37. @Basic
  38. @Column(name = "usr_contract_id", nullable = true)
  39. public Integer getContractId() {
  40. return contractId;
  41. }
  42.  
  43. public void setContractId(Integer contractId) {
  44. this.contractId = contractId;
  45. }
  46.  
  47. }
  48.  
  49. @Configuration
  50. @EnableTransactionManagement(proxyTargetClass = true)
  51. @PropertySources({
  52. @PropertySource(value = "classpath:application.properties")})
  53. @ConfigurationProperties(prefix = "spring.datasource")
  54. public class HibernateConfig {
  55.  
  56. @Autowired
  57. private Environment environment;
  58.  
  59. @Autowired
  60. private DataSource dataSource;
  61.  
  62. @Autowired
  63. private MultiTenantConnectionProvider multiTenantConnectionProvider;
  64.  
  65. @Autowired
  66. private CurrentTenantIdentifierResolver currentTenantIdentifierResolver;
  67.  
  68. public HibernateConfig() {}
  69.  
  70. @Bean
  71. public LocalSessionFactoryBean sessionFactory() throws Exception {
  72.  
  73. LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
  74. sessionFactory.setDataSource(dataSource);
  75. sessionFactory.setHibernateProperties(hibernateProperties());
  76.  
  77. sessionFactory.setPackagesToScan(new String[] {
  78. "com.xxx.xxx.model",
  79. });
  80.  
  81. return sessionFactory;
  82. }
  83.  
  84. private Properties hibernateProperties() {
  85. Properties properties = new Properties();
  86. properties.put(DIALECT, environment.getRequiredProperty(DIALECT));
  87. properties.put(SHOW_SQL, environment.getRequiredProperty(SHOW_SQL));
  88. properties.put(FORMAT_SQL, environment.getRequiredProperty(FORMAT_SQL));
  89. properties.put(HBM2DDL_AUTO, environment.getRequiredProperty(HBM2DDL_AUTO));
  90.  
  91. return properties;
  92. }
  93.  
  94. @Bean
  95. @Primary
  96. @Autowired
  97. public HibernateTransactionManager transactionManager(SessionFactory s) {
  98. HibernateTransactionManager txManager = new HibernateTransactionManager();
  99. txManager.setSessionFactory(s);
  100. return txManager;
  101. }
  102.  
  103. @Bean
  104. @Autowired
  105. public HibernateTemplate hibernateTemplate(SessionFactory s) {
  106. HibernateTemplate hibernateTemplate = new HibernateTemplate(s);
  107. return hibernateTemplate;
  108. }
  109. }
  110.  
  111. # Database connection settings:
  112. jdbc.driverClassName=org.postgresql.Driver
  113. jdbc.url=jdbc:postgresql://localhost:5432/database
  114. jdbc.username=postgres
  115. jdbc.password=111111
  116.  
  117. hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
  118. hibernate.show_sql=false
  119. hibernate.format_sql=false
  120. hibernate.hbm2ddl.auto=update
  121.  
  122. spring.datasource.initialSize=50
  123. spring.datasource.maxActive=200
  124. spring.datasource.maxIdle=200
  125. spring.datasource.minIdle=50
  126.  
  127. spring.jpa.hibernate.ddl-auto=update
  128. spring.jpa.generate-ddl=true
  129. spring.jpa.database-platform=org.hibernate.dialect.PostgreSQL94Dialect
  130.  
  131. spring.datasource.driverClassName=org.postgresql.Driver
  132. spring.datasource.url= jdbc:postgresql://localhost:5432/postgres
  133. spring.datasource.username=postgres
  134. spring.datasource.password=123
  135.  
  136. spring.jpa.show-sql=true
  137. spring.session.store-type=none
  138.  
  139. spring.jpa.properties.hibernate.hbm2ddl.auto=update
Add Comment
Please, Sign In to add comment