###
#   Database Settings
###
spring.datasource.url=jdbc:h2:file:~/testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.platform=h2
spring.datasource.username = sa
spring.datasource.password =
spring.datasource.driverClassName = org.h2.Driver
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect

###
#   H2 Settings
###
spring.h2.console.enabled=true
spring.h2.console.path=/console
spring.h2.console.settings.trace=false
spring.h2.console.settings.web-allow-others=false

CREATE TABLE MSG_RCV
(MSG_ID IDENTITY PRIMARY KEY,
PHN_ID VARCHAR(50),
PHN_MSG_ID VARCHAR(50),
MSG_RCPT_DTM TIMESTAMP,
DATA_SRC_CD VARCHAR(20),
MSG_BODY CLOB,
DATA_LOAD_STATUS CHAR,
NOTE VARCHAR(100))