· 7 years ago · Nov 26, 2018, 04:18 PM
1testCompile group: 'com.h2database', name: 'h2', version: '1.4.197'
2
3runtime('org.hsqldb:hsqldb')
4
5#spring.datasource.driver-class-name=org.h2.Driver
6#spring.dataSource.url=jdbc:h2:mem:testdb
7#spring.dataSource.username=sa
8#spring.dataSource.password=
9
10spring.h2.console.enabled=true
11
12spring.jpa.properties.hibernate.generate_statistics=true
13logging.level.org.hibernate.stat=debug
14
15spring.jpa.show-sql=true
16spring.jpa.properties.hibernate.format_sql=true
17logging.level.org.hibernate.type=trace
18
19CREATE TABLE number_entity(
20 name VARCHAR (30),
21 value INTEGER (10)
22);
23
24INSERT INTO number_entity
25VALUES ('test1', 2);
26
27INSERT INTO number_entity
28VALUES ('test2', 3);
29
30Hibernate:
31
32 drop table number_entity if exists
33Hibernate:
34
35 create table number_entity (
36 name varchar(255) not null,
37 value integer,
38 primary key (name)
39 )
40
41@Entity
42@Table(name = "number_entity")
43public class NumberEntity {
44
45 @Id
46 @Column(name = "name")
47 private String name;
48
49 @Column(name = "value")
50 private int value;
51
52 // constructors, getters and setters //
53
54}