Guest User

Untitled

a guest
Nov 26th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. testCompile group: 'com.h2database', name: 'h2', version: '1.4.197'
  2.  
  3. runtime('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.  
  10. spring.h2.console.enabled=true
  11.  
  12. spring.jpa.properties.hibernate.generate_statistics=true
  13. logging.level.org.hibernate.stat=debug
  14.  
  15. spring.jpa.show-sql=true
  16. spring.jpa.properties.hibernate.format_sql=true
  17. logging.level.org.hibernate.type=trace
  18.  
  19. CREATE TABLE number_entity(
  20. name VARCHAR (30),
  21. value INTEGER (10)
  22. );
  23.  
  24. INSERT INTO number_entity
  25. VALUES ('test1', 2);
  26.  
  27. INSERT INTO number_entity
  28. VALUES ('test2', 3);
  29.  
  30. Hibernate:
  31.  
  32. drop table number_entity if exists
  33. Hibernate:
  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")
  43. public 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. }
Add Comment
Please, Sign In to add comment