Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Configuration
- @EnableTransactionManagement
- public class DBConfig {
- /**
- * Créer la base de données et associe les entités utilisables pendant la
- * session
- */
- @Bean
- public SessionFactory sessionFactory() {
- return new LocalSessionFactoryBuilder(getDataSource()).scanPackages("pro.logikal.testdbconnexionspring.entity")
- .buildSessionFactory();
- }
- /**
- * Configure l'accès à la base de données. La configuration à la base de données
- * se trouve dans le fichier de contexte (WebContent / Meta-inf / Context.xml)
- *
- * @return Datasource
- */
- @Bean
- public DataSource getDataSource() {
- try {
- InitialContext initialContext = new InitialContext();
- DataSource dataSource = (DataSource) initialContext.lookup("java:/comp/env/jdbc/logdb");
- return dataSource;
- } catch (NamingException e) {
- e.printStackTrace();
- return null;
- }
- }
- @Bean
- public HibernateTransactionManager hibernateTransactionManager() {
- return new HibernateTransactionManager(this.sessionFactory());
- }
- }
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE xml>
- <Context docBase="TestDBConnexionSpring"
- path="TestDBConnexionSpring" reloadable="true"
- allowCasualMultiParsing="true">
- <Resources cachingAllowed="true" cacheMaxSize="100000"/>
- <Resource
- name="jdbc/logdb"
- auth="Container"
- type="javax.sql.DataSource"
- url="jdbc:mysql://localhost:3306/logdb"
- username="root"
- password="g5tn4gfs"
- maxActive="200"
- maxIdle="5"
- maxWait="-1"
- removeAbandonned="true"
- removeAbandonnedTimeout="60"
- logAbandonned="true">
- </Resource>
- </Context>
- <!DOCTYPE web-app PUBLIC
- "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
- "http://java.sun.com/dtd/web-app_2_3.dtd" >
- <web-app>
- <display-name>Archetype Created Web Application</display-name>
- <resource-ref>
- <description>DB Connexion</description>
- <res-ref-name>jdbc/logdb</res-ref-name>
- <res-type>javax.sql.DataSource</res-type>
- <res-auth>Container</res-auth>
- </resource-ref>
- </web-app>
- <project xmlns="http://maven.apache.org/POM/4.0.0"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
- http://maven.apache.org/maven-v4_0_0.xsd">
- <modelVersion>4.0.0</modelVersion>
- <groupId>pro.logikal</groupId>
- <artifactId>TestDBConnexionSpring</artifactId>
- <packaging>war</packaging>
- <version>0.0.1-SNAPSHOT</version>
- <name>TestDBConnexionSpring Maven Webapp</name>
- <url>http://maven.apache.org</url>
- <properties>
- <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
- <hibernate-version>4.3.10.Final</hibernate-version>
- <dbcp-version>2.1.1</dbcp-version>
- <mysql-version>6.0.5</mysql-version>
- <springboot-version>1.4.1.RELEASE</springboot-version>
- <spring-version>4.2.0.RELEASE</spring-version>
- </properties>
- <dependencies>
- <!-- Begin Spring -->
- <dependency>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-starter-web</artifactId>
- <version>${springboot-version}</version>
- </dependency>
- <!-- JPA Data (We are going to use Repositories, Entities, Hibernate, etc...) -->
- <dependency>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-starter-data-jpa</artifactId>
- <version>${springboot-version}</version>
- </dependency>
- <dependency>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-starter-security</artifactId>
- <version>${springboot-version}</version>
- </dependency>
- <dependency>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-starter-aop</artifactId>
- <version>${springboot-version}</version>
- </dependency>
- <!-- Spring security -->
- <dependency>
- <groupId>org.springframework.security</groupId>
- <artifactId>spring-security-ldap</artifactId>
- <version>${spring-version}</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-websocket</artifactId>
- <version>${spring-version}</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-messaging</artifactId>
- <version>${spring-version}</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-context-support</artifactId>
- <version>${spring-version}</version>
- </dependency>
- <!-- Use MySQL Connector-J -->
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>5.1.44</version>
- </dependency>
- <dependency>
- <groupId>jstl</groupId>
- <artifactId>jstl</artifactId>
- <version>1.2</version>
- </dependency>
- <dependency>
- <groupId>org.hibernate</groupId>
- <artifactId>hibernate-core</artifactId>
- <version>${hibernate-version}</version>
- </dependency>
- <dependency>
- <groupId>org.hibernate</groupId>
- <artifactId>hibernate-jpamodelgen</artifactId>
- <version>5.2.11.Final</version>
- </dependency>
- <dependency>
- <groupId>org.hibernate</groupId>
- <artifactId>hibernate-entitymanager</artifactId>
- <version>4.3.6.Final</version>
- </dependency>
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- <version>4.12</version>
- </dependency>
- </dependencies>
- <build>
- <plugins>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven.compiler-plugin</artifactId>
- <version>3.1</version>
- <configuration>
- <source>1.8</source>
- <targert>1.8</targert>
- </configuration>
- </plugin>
- <plugin>
- <groupId>org.apache.maven.plugins</groupId>
- <artifactId>maven-war-plugin</artifactId>
- <version>2.6</version>
- <configuration>
- <failOnMissingWebXml>false</failOnMissingWebXml>
- </configuration>
- </plugin>
- </plugins>
- </build>
- </project>
Add Comment
Please, Sign In to add comment