この記事では、SpringBoot + SpringデータJPA + Oracle + HikariCP接続プールの例を作成する方法を説明します。

この記事で使用されているツール:

  1. 春のブート1.5.1.RELEASE

  2. Springデータ1.13.0.RELEASE

  3. 休止状態5

  4. Oracleデータベース11g Express

  5. Oracle JDBCドライバojdbc7.jar

  6. HikariCP 2.6

  7. Maven

  8. Java 8

1.プロジェクトの構成

標準のMavenプロジェクト構造。


image

プロジェクトの依存関係

`spring-boot-startter-data-jpa`を宣言し、Spring Data、HibernateおよびJPA関連のものを取得します。

pom.xml 

<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>com.mkyong</groupId>
    <artifactId>spring-boot-jpa-oracle-example</artifactId>
    <packaging>jar</packaging>
    <version>1.0</version>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.1.RELEASE</version>
    </parent>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <!-- Spring data JPA, default tomcat pool, exclude it -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
            <exclusions>
                <exclusion>
                    <groupId>org.apache.tomcat</groupId>
                    <artifactId>tomcat-jdbc</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <!-- Oracle JDBC driver -->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc7</artifactId>
            <version>12.1.0</version>
        </dependency>

        <!-- HikariCP connection pool -->
        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>2.6.0</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <!-- Package as an executable jar/war -->
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>

        </plugins>
    </build>

</project>

プロジェクトの依存関係を詳しく見直してください。

ターミナル 

$ mvn dependency:tree[INFO]------------------------------------------------------------------------[INFO]Building spring-boot-jpa-oracle-example 1.0[INFO]------------------------------------------------------------------------[INFO][INFO]--- maven-dependency-plugin:2.10:tree (default-cli) @ spring-boot-jpa-oracle-example ---[INFO]com.mkyong:spring-boot-jpa-oracle-example:jar:1.0[INFO]+- org.springframework.boot:spring-boot-starter:jar:1.5.1.RELEASE:compile[INFO]|  +- org.springframework.boot:spring-boot:jar:1.5.1.RELEASE:compile[INFO]|  |  \- org.springframework:spring-context:jar:4.3.6.RELEASE:compile[INFO]|  |     \- org.springframework:spring-expression:jar:4.3.6.RELEASE:compile[INFO]|  +- org.springframework.boot:spring-boot-autoconfigure:jar:1.5.1.RELEASE:compile[INFO]|  +- org.springframework.boot:spring-boot-starter-logging:jar:1.5.1.RELEASE:compile[INFO]|  |  +- ch.qos.logback:logback-classic:jar:1.1.9:compile[INFO]|  |  |  \- ch.qos.logback:logback-core:jar:1.1.9:compile[INFO]|  |  +- org.slf4j:jcl-over-slf4j:jar:1.7.22:compile[INFO]|  |  +- org.slf4j:jul-to-slf4j:jar:1.7.22:compile[INFO]|  |  \- org.slf4j:log4j-over-slf4j:jar:1.7.22:compile[INFO]|  +- org.springframework:spring-core:jar:4.3.6.RELEASE:compile[INFO]|  \- org.yaml:snakeyaml:jar:1.17:runtime[INFO]+- org.springframework.boot:spring-boot-starter-data-jpa:jar:1.5.1.RELEASE:compile[INFO]|  +- org.springframework.boot:spring-boot-starter-aop:jar:1.5.1.RELEASE:compile[INFO]|  |  +- org.springframework:spring-aop:jar:4.3.6.RELEASE:compile[INFO]|  |  \- org.aspectj:aspectjweaver:jar:1.8.9:compile[INFO]|  +- org.springframework.boot:spring-boot-starter-jdbc:jar:1.5.1.RELEASE:compile[INFO]|  |  \- org.springframework:spring-jdbc:jar:4.3.6.RELEASE:compile[INFO]|  +- org.hibernate:hibernate-core:jar:5.0.11.Final:compile[INFO]|  |  +- org.jboss.logging:jboss-logging:jar:3.3.0.Final:compile[INFO]|  |  +- org.hibernate.javax.persistence:hibernate-jpa-2.1-api:jar:1.0.0.Final:compile[INFO]|  |  +- org.javassist:javassist:jar:3.21.0-GA:compile[INFO]|  |  +- antlr:antlr:jar:2.7.7:compile[INFO]|  |  +- org.jboss:jandex:jar:2.0.0.Final:compile[INFO]|  |  +- dom4j:dom4j:jar:1.6.1:compile[INFO]|  |  \- org.hibernate.common:hibernate-commons-annotations:jar:5.0.1.Final:compile[INFO]|  +- org.hibernate:hibernate-entitymanager:jar:5.0.11.Final:compile[INFO]|  +- javax.transaction:javax.transaction-api:jar:1.2:compile[INFO]|  +- org.springframework.data:spring-data-jpa:jar:1.11.0.RELEASE:compile[INFO]|  |  +- org.springframework.data:spring-data-commons:jar:1.13.0.RELEASE:compile[INFO]|  |  +- org.springframework:spring-orm:jar:4.3.6.RELEASE:compile[INFO]|  |  +- org.springframework:spring-tx:jar:4.3.6.RELEASE:compile[INFO]|  |  \- org.springframework:spring-beans:jar:4.3.6.RELEASE:compile[INFO]|  \- org.springframework:spring-aspects:jar:4.3.6.RELEASE:compile[INFO]+- com.oracle:ojdbc7:jar:12.1.0:compile[INFO]\- com.zaxxer:HikariCP:jar:2.6.0:compile[INFO]   \- org.slf4j:slf4j-api:jar:1.7.22:compile[INFO]------------------------------------------------------------------------[INFO]BUILD SUCCESS[INFO]------------------------------------------------------------------------

3. Java Persistence API – JPA

3.1顧客モデル。 JPAアノテーションを追加し、「シーケンス」を使用して自動増分プライマリIDを生成します。

Customer.java 

package com.mkyong.model;

import javax.persistence.** ;
import java.util.Date;

@Entity
public class Customer {

   //"customer__seq" is Oracle sequence name.
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "CUST__SEQ")
    @SequenceGenerator(sequenceName = "customer__seq", allocationSize = 1, name = "CUST__SEQ")
    Long id;

    String name;

    String email;

    @Column(name = "CREATED__DATE")
    Date date;

   //getters and setters, contructors
}

4.構成+データベースの初期化

4.1 Oracleデータソース、HikariCP設定を構成し、Hibernateクエリを表示します。

application.properties 

spring.main.banner-mode=off

# create and drop tables and sequences, loads import.sql
spring.jpa.hibernate.ddl-auto=create-drop

# Oracle settings
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:xe
spring.datasource.username=system
spring.datasource.password=password
spring.datasource.driver-class-oracle.jdbc.driver.OracleDriver

# HikariCP settings
# spring.datasource.hikari.**

spring.datasource.hikari.connection-timeout=60000
spring.datasource.hikari.maximum-pool-size=5

# logging
logging.pattern.console=%d{yyyy-MM-dd HH:mm:ss} %-5level %logger{36} - %msg%n
logging.level.org.hibernate.SQL=debug
#logging.level.org.hibernate.type.descriptor.sql=trace
logging.level.=error

4.2クラスパスに `import.sql`がある場合、Hibernateはそれを自動的にロードします。

import.sql 

INSERT INTO "CUSTOMER" (ID, NAME, EMAIL, CREATED__DATE) VALUES(1, 'mkyong','[email protected]', TO__DATE('2017-02-11', 'yyyy-mm-dd'));
INSERT INTO "CUSTOMER" (ID, NAME, EMAIL, CREATED__DATE) VALUES(2, 'yflow','[email protected]', TO__DATE('2017-02-12', 'yyyy-mm-dd'));
INSERT INTO "CUSTOMER" (ID, NAME, EMAIL, CREATED__DATE) VALUES(3, 'zilap','[email protected]', TO__DATE('2017-02-13', 'yyyy-mm-dd'));

5.リポジトリ

5.1インターフェースを作成し、Springデータ `CrudRepository`を拡張します。

CustomerRepository.java 

package com.mkyong.dao;

import com.mkyong.model.Customer;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

import java.util.Date;
import java.util.List;
import java.util.stream.Stream;

public interface CustomerRepository extends CrudRepository<Customer, Long> {

    List<Customer> findByEmail(String email);

    List<Customer> findByDate(Date date);

   //custom query example and return a stream
    @Query("select c from Customer c where c.email = :email")
    Stream<Customer> findByEmailReturnStream(@Param("email") String email);

}

  • Note ** +実装は必要ありませんが、SpringデータはfindByfieldName（）のようにフィールド名で共通の実装を作成します。このhttp://docs.spring.io/spring-data/data-commons/docs/current/reference/html/#repositories– Springデータリポジトリの使用を参照してください。

6.スプリングブートスターター

Application.java 

package com.mkyong;

import com.mkyong.dao.CustomerRepository;
import com.mkyong.model.Customer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.transaction.annotation.Transactional;

import javax.sql.DataSource;
import java.text.SimpleDateFormat;
import java.util.stream.Stream;

import static java.lang.System.exit;

@SpringBootApplication
public class Application implements CommandLineRunner {

    private static final SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

    @Autowired
    DataSource dataSource;

    @Autowired
    CustomerRepository customerRepository;

    public static void main(String[]args) throws Exception {
        SpringApplication.run(Application.class, args);
    }

    @Transactional(readOnly = true)
    @Override
    public void run(String... args) throws Exception {

        System.out.println("DATASOURCE = " + dataSource);

        System.out.println("\n1.findAll()...");
        for (Customer customer : customerRepository.findAll()) {
            System.out.println(customer);
        }

        System.out.println("\n2.findByEmail(String email)...");
        for (Customer customer : customerRepository.findByEmail("[email protected]")) {
            System.out.println(customer);
        }

        System.out.println("\n3.findByDate(Date date)...");
        for (Customer customer : customerRepository.findByDate(sdf.parse("2017-02-12"))) {
            System.out.println(customer);
        }

       //For Stream, need @Transactional
        System.out.println("\n4.findByEmailReturnStream(@Param(\"email\") String email)...");
        try (Stream<Customer> stream = customerRepository.findByEmailReturnStream("[email protected]")) {
            stream.forEach(x -> System.out.println(x));
        }

        System.out.println("Done!");

        exit(0);
    }

}

8.デモ

それを実行して、わかりやすいようにコンソールを読んでください。

ターミナル 

2017-02-22 12:36:49 DEBUG org.hibernate.SQL - drop table customer cascade constraints
2017-02-22 12:36:49 ERROR o.h.tool.hbm2ddl.SchemaExport - HHH000389: Unsuccessful: drop table customer cascade constraints
2017-02-22 12:36:49 ERROR o.h.tool.hbm2ddl.SchemaExport - ORA-00942: table or view does not exist

2017-02-22 12:36:49 DEBUG org.hibernate.SQL - drop sequence customer__seq
2017-02-22 12:36:49 ERROR o.h.tool.hbm2ddl.SchemaExport - HHH000389: Unsuccessful: drop sequence customer__seq
2017-02-22 12:36:49 ERROR o.h.tool.hbm2ddl.SchemaExport - ORA-02289: sequence does not exist

2017-02-22 12:36:49 DEBUG org.hibernate.SQL - create sequence customer__seq start with 1 increment by 1
2017-02-22 12:36:49 DEBUG org.hibernate.SQL - create table customer (id number(19,0) not null, created__date timestamp, email varchar2(255 char), name varchar2(255 char), primary key (id))
DATASOURCE = HikariDataSource (HikariPool-1)

1.findAll()...
2017-02-22 12:36:50 DEBUG org.hibernate.SQL - select customer0__.id as id1__0__, customer0__.created__date as created__date2__0__, customer0__.email as email3__0__, customer0__.name as name4__0__ from customer customer0__
Customer{id=1, name='mkyong', email='[email protected]', date=2017-02-11 00:00:00.0}
Customer{id=2, name='yflow', email='[email protected]', date=2017-02-12 00:00:00.0}
Customer{id=3, name='zilap', email='[email protected]', date=2017-02-13 00:00:00.0}

2.findByEmail(String email)...
2017-02-22 12:36:50 DEBUG org.hibernate.SQL - select customer0__.id as id1__0__, customer0__.created__date as created__date2__0__, customer0__.email as email3__0__, customer0__.name as name4__0__ from customer customer0__ where customer0__.email=?
Customer{id=2, name='yflow', email='[email protected]', date=2017-02-12 00:00:00.0}

3.findByDate(Date date)...
2017-02-22 12:36:50 DEBUG org.hibernate.SQL - select customer0__.id as id1__0__, customer0__.created__date as created__date2__0__, customer0__.email as email3__0__, customer0__.name as name4__0__ from customer customer0__ where customer0__.created__date=?
Customer{id=2, name='yflow', email='[email protected]', date=2017-02-12 00:00:00.0}

4.findByEmailReturnStream(@Param("email") String email)...
2017-02-22 12:36:50 DEBUG org.hibernate.SQL - select customer0__.id as id1__0__, customer0__.created__date as created__date2__0__, customer0__.email as email3__0__, customer0__.name as name4__0__ from customer customer0__ where customer0__.email=?
Customer{id=3, name='zilap', email='[email protected]', date=2017-02-13 00:00:00.0}
Done!
2017-02-22 12:36:50 DEBUG org.hibernate.SQL - drop table customer cascade constraints
2017-02-22 12:36:50 DEBUG org.hibernate.SQL - drop sequence customer__seq

Process finished with exit code 0

ソースコードをダウンロードする

ダウンロード:

spring-boot-jpa-oracle-example.zip

（6 KB）

参考文献

  1. リンク://maven/how-to-add-oracle-jdbc-driver-in-your-maven-local-repository/[Maven

Oracle JDBCドライバをインストール]。

https://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html

[Initialize

JPAを使用したデータベース]。

http://stackoverflow.com/questions/21113154/spring-boot-ddl-auto-generator

[Spring

ブートddl自動発電機]。

http://docs.spring.io/spring-data/data-commons/docs/current/reference/html/

[Spring

データコモンズ – リファレンスドキュメント]。

https://spring.io/guides/gs/accessing-data-jpa/

[データへのアクセス

JPA]。

http://www.oracle.com/technetwork/middleware/ias/id-generation-083058.html

[トップリンク

JPA:主キーの構成方法
。

https://www.techonthenet.com/oracle/sequences.php

[Oracle/PLSQL:

シーケンス（オートナンバー）]。リンク://spring-boot/spring-boot-jdbc-oracle-database-commons-dbcp2-example/[Spring

ブートJDBC + Oracleデータベース+コモンズDBCP2の例]


hibernate


hikaricp

リンク://タグ/jpa/[jpa]

oracle


シーケンス


spring boot


spring-data