Advertisement
Guest User

Untitled

a guest
Jul 18th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.43 KB | None | 0 0
  1. @Entity
  2. @Table(name = "MESSAGE_HISTORY_RECORD")
  3.  
  4. public class MessageHistoryRecord {
  5.  
  6. @EmbeddedId
  7. private MessageCompoundKey compoundKey;
  8.  
  9. @Column
  10. private String responseChannel;
  11.  
  12. @ElementCollection
  13. private List<Trace> traces;
  14.  
  15. @Column
  16. private byte[] payload;
  17.  
  18. //getters and setters
  19. }
  20.  
  21. @Embeddable
  22. public class MessageCompoundKey implements Serializable {
  23.  
  24. private static final long serialVersionUID = 9084329307727034214L;
  25.  
  26. @Column
  27. private String correlatedMsgId;
  28.  
  29. @Column
  30. private String messageId;
  31.  
  32. @Column
  33. private String endpointId;
  34.  
  35. //getters and setters
  36. }
  37.  
  38. @Embeddable
  39. public class Trace implements Serializable{
  40.  
  41. private static final long serialVersionUID = 9084329307727034214L;
  42.  
  43. private Long timestamp;
  44.  
  45. private String description;
  46.  
  47. //getters and setters
  48. }
  49.  
  50. CREATE TABLE "public"."message_history_record"
  51. (
  52. correlatedmsgid varchar(255) NOT NULL,
  53. endpointid varchar(255) NOT NULL,
  54. messageid varchar(255) NOT NULL,
  55. payload bytea,
  56. responsechannel varchar(255),
  57. CONSTRAINT message_history_record_pkey PRIMARY KEY (correlatedmsgid,endpointid,messageid)
  58. )
  59. ;
  60. CREATE UNIQUE INDEX message_history_record_pkey ON "public"."message_history_record"
  61. (
  62. correlatedmsgid,
  63. endpointid,
  64. messageid
  65. )
  66. ;
  67.  
  68. CREATE TABLE "public"."messagehistoryrecord_traces"
  69. (
  70. messagehistoryrecord_correlatedmsgid varchar(255) NOT NULL,
  71. messagehistoryrecord_endpointid varchar(255) NOT NULL,
  72. messagehistoryrecord_messageid varchar(255) NOT NULL,
  73. description varchar(255),
  74. timestamp bigint
  75. )
  76.  
  77. hibernate.connection.driver_class=org.postgresql.Driver
  78. hibernate.connection.url=jdbc:postgresql://192.xx.xx.xx:5432/testdb
  79. hibernate.connection.username=***
  80. hibernate.connection.password=****
  81. hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
  82. hibernate.connection.pool_size=10
  83. hibernate.show_sql=true
  84. hibernate.hbm2ddl.auto=update
  85.  
  86. @ElementCollection
  87. @CollectionTable(name = "mhr_traces",
  88. joinColumns={@JoinColumn(name="mhr_correlatedmsgid", referencedColumnName="correlatedmsgid"),
  89. @JoinColumn(name="mhr_endpointid", referencedColumnName="endpointid"),
  90. @JoinColumn(name = "mhr_messageid", referencedColumnName = "messageid")})
  91. private List<Trace> traces = new ArrayList<>();
  92.  
  93. CONSTRAINT mrFK FOREIGN KEY (mhr_correlatedmsgid, mhr_endpointid, mhr_messageid) REFERENCES MESSAGE_HISTORY_RECORD (correlatedmsgid,endpointid,messageid)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement