Guest User

Untitled

a guest
Oct 23rd, 2017
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.87 KB | None | 0 0
  1. @Configuration
  2. @EnableTransactionManagement
  3. public class DBConfig {
  4.  
  5. /**
  6. * Créer la base de données et associe les entités utilisables pendant la
  7. * session
  8. */
  9.  
  10. @Bean
  11. public SessionFactory sessionFactory() {
  12. return new LocalSessionFactoryBuilder(getDataSource()).scanPackages("pro.logikal.testdbconnexionspring.entity")
  13. .buildSessionFactory();
  14. }
  15.  
  16. /**
  17. * Configure l'accès à la base de données. La configuration à la base de données
  18. * se trouve dans le fichier de contexte (WebContent / Meta-inf / Context.xml)
  19. *
  20. * @return Datasource
  21. */
  22.  
  23. @Bean
  24. public DataSource getDataSource() {
  25. try {
  26. InitialContext initialContext = new InitialContext();
  27. DataSource dataSource = (DataSource) initialContext.lookup("java:/comp/env/jdbc/logdb");
  28. return dataSource;
  29. } catch (NamingException e) {
  30. e.printStackTrace();
  31. return null;
  32. }
  33.  
  34.  
  35.  
  36. }
  37.  
  38. @Bean
  39. public HibernateTransactionManager hibernateTransactionManager() {
  40. return new HibernateTransactionManager(this.sessionFactory());
  41. }
  42.  
  43.  
  44. }
  45.  
  46. <?xml version="1.0" encoding="UTF-8"?>
  47. <!DOCTYPE xml>
  48. <Context docBase="TestDBConnexionSpring"
  49. path="TestDBConnexionSpring" reloadable="true"
  50. allowCasualMultiParsing="true">
  51.  
  52. <Resources cachingAllowed="true" cacheMaxSize="100000"/>
  53.  
  54. <Resource
  55. name="jdbc/logdb"
  56. auth="Container"
  57. type="javax.sql.DataSource"
  58. url="jdbc:mysql://localhost:3306/logdb"
  59. username="root"
  60. password="g5tn4gfs"
  61. maxActive="200"
  62. maxIdle="5"
  63. maxWait="-1"
  64. removeAbandonned="true"
  65. removeAbandonnedTimeout="60"
  66. logAbandonned="true">
  67.  
  68. </Resource>
  69.  
  70.  
  71. </Context>
  72.  
  73. <!DOCTYPE web-app PUBLIC
  74. "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
  75. "http://java.sun.com/dtd/web-app_2_3.dtd" >
  76.  
  77. <web-app>
  78. <display-name>Archetype Created Web Application</display-name>
  79.  
  80. <resource-ref>
  81. <description>DB Connexion</description>
  82. <res-ref-name>jdbc/logdb</res-ref-name>
  83. <res-type>javax.sql.DataSource</res-type>
  84. <res-auth>Container</res-auth>
  85.  
  86. </resource-ref>
  87.  
  88. </web-app>
  89.  
  90. <project xmlns="http://maven.apache.org/POM/4.0.0"
  91. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  92. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
  93. http://maven.apache.org/maven-v4_0_0.xsd">
  94. <modelVersion>4.0.0</modelVersion>
  95. <groupId>pro.logikal</groupId>
  96. <artifactId>TestDBConnexionSpring</artifactId>
  97. <packaging>war</packaging>
  98. <version>0.0.1-SNAPSHOT</version>
  99. <name>TestDBConnexionSpring Maven Webapp</name>
  100. <url>http://maven.apache.org</url>
  101. <properties>
  102. <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  103. <hibernate-version>4.3.10.Final</hibernate-version>
  104. <dbcp-version>2.1.1</dbcp-version>
  105. <mysql-version>6.0.5</mysql-version>
  106. <springboot-version>1.4.1.RELEASE</springboot-version>
  107. <spring-version>4.2.0.RELEASE</spring-version>
  108. </properties>
  109.  
  110. <dependencies>
  111.  
  112. <!-- Begin Spring -->
  113. <dependency>
  114. <groupId>org.springframework.boot</groupId>
  115. <artifactId>spring-boot-starter-web</artifactId>
  116. <version>${springboot-version}</version>
  117. </dependency>
  118.  
  119. <!-- JPA Data (We are going to use Repositories, Entities, Hibernate, etc...) -->
  120.  
  121. <dependency>
  122. <groupId>org.springframework.boot</groupId>
  123. <artifactId>spring-boot-starter-data-jpa</artifactId>
  124. <version>${springboot-version}</version>
  125. </dependency>
  126.  
  127. <dependency>
  128. <groupId>org.springframework.boot</groupId>
  129. <artifactId>spring-boot-starter-security</artifactId>
  130. <version>${springboot-version}</version>
  131. </dependency>
  132.  
  133. <dependency>
  134. <groupId>org.springframework.boot</groupId>
  135. <artifactId>spring-boot-starter-aop</artifactId>
  136. <version>${springboot-version}</version>
  137. </dependency>
  138.  
  139. <!-- Spring security -->
  140.  
  141. <dependency>
  142. <groupId>org.springframework.security</groupId>
  143. <artifactId>spring-security-ldap</artifactId>
  144. <version>${spring-version}</version>
  145. </dependency>
  146.  
  147. <dependency>
  148. <groupId>org.springframework</groupId>
  149. <artifactId>spring-websocket</artifactId>
  150. <version>${spring-version}</version>
  151. </dependency>
  152.  
  153. <dependency>
  154. <groupId>org.springframework</groupId>
  155. <artifactId>spring-messaging</artifactId>
  156. <version>${spring-version}</version>
  157. </dependency>
  158.  
  159. <dependency>
  160. <groupId>org.springframework</groupId>
  161. <artifactId>spring-context-support</artifactId>
  162. <version>${spring-version}</version>
  163. </dependency>
  164.  
  165.  
  166. <!-- Use MySQL Connector-J -->
  167.  
  168. <dependency>
  169. <groupId>mysql</groupId>
  170. <artifactId>mysql-connector-java</artifactId>
  171. <version>5.1.44</version>
  172. </dependency>
  173.  
  174.  
  175. <dependency>
  176. <groupId>jstl</groupId>
  177. <artifactId>jstl</artifactId>
  178. <version>1.2</version>
  179. </dependency>
  180.  
  181. <dependency>
  182. <groupId>org.hibernate</groupId>
  183. <artifactId>hibernate-core</artifactId>
  184. <version>${hibernate-version}</version>
  185. </dependency>
  186.  
  187. <dependency>
  188. <groupId>org.hibernate</groupId>
  189. <artifactId>hibernate-jpamodelgen</artifactId>
  190. <version>5.2.11.Final</version>
  191. </dependency>
  192.  
  193. <dependency>
  194. <groupId>org.hibernate</groupId>
  195. <artifactId>hibernate-entitymanager</artifactId>
  196. <version>4.3.6.Final</version>
  197. </dependency>
  198.  
  199. <dependency>
  200. <groupId>junit</groupId>
  201. <artifactId>junit</artifactId>
  202. <version>4.12</version>
  203. </dependency>
  204.  
  205.  
  206.  
  207.  
  208. </dependencies>
  209.  
  210.  
  211.  
  212.  
  213.  
  214. <build>
  215. <plugins>
  216. <plugin>
  217. <groupId>org.apache.maven.plugins</groupId>
  218. <artifactId>maven.compiler-plugin</artifactId>
  219. <version>3.1</version>
  220. <configuration>
  221. <source>1.8</source>
  222. <targert>1.8</targert>
  223. </configuration>
  224. </plugin>
  225. <plugin>
  226. <groupId>org.apache.maven.plugins</groupId>
  227. <artifactId>maven-war-plugin</artifactId>
  228. <version>2.6</version>
  229. <configuration>
  230. <failOnMissingWebXml>false</failOnMissingWebXml>
  231. </configuration>
  232. </plugin>
  233. </plugins>
  234. </build>
  235. </project>
Add Comment
Please, Sign In to add comment