Spring起動時のSpringデータJPA Oracleの例
この記事では、SpringBoot + SpringデータJPA + Oracle + HikariCP接続プールの例を作成する方法を説明します。
この記事で使用されているツール:
-
春のブート1.5.1.RELEASE
-
Springデータ1.13.0.RELEASE
-
休止状態5
-
Oracleデータベース11g Express
-
Oracle JDBCドライバojdbc7.jar
-
HikariCP 2.6
-
Maven
-
Java 8
1.プロジェクトの構成
標準のMavenプロジェクト構造。
プロジェクトの依存関係
`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)
参考文献
-
リンク://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:主キーの構成方法
。
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