DbServer

Exploring eventing in H2 database server mode

Getting Started

Reference Documentation

For further reference, please consider the following sections:

• Official Apache Maven documentation
• Spring Boot Maven Plugin Reference Guide
• Spring Data JDBC
• Spring Boot Actuator
• Spring Boot DevTools
• Spring Web
• Spring Configuration Processor
• Spring for RabbitMQ

Guides

The following guides illustrate how to use some features concretely:

• Using Spring Data JDBC
• Building a RESTful Web Service with Spring Boot Actuator
• Building a RESTful Web Service
• Serving Web Content with Spring MVC
• Building REST services with Spring
• Messaging with RabbitMQ

ALTER TABLE AUDIT.EVENTS ADD "TDAY" integer NULL;

UPDATE AUDIT.EVENTS SET TDAY=DATEDIFF(DAY, CAST('1970-01-01' as DATE), TDATE);

ALTER TABLE AUDIT.EVENTS ALTER COLUMN "TDAY" integer NOT NULL;

ALTER TABLE AUDIT.EVENTS DROP PRIMARY KEY;

ALTER TABLE EVENTS DROP COLUMN "TDATE";

ALTER TABLE AUDIT.EVENTS ADD CONSTRAINT PRIMARY_KEY PRIMARY KEY ("TDAY", "TSEQ");

ALTER TABLE AUDIT.EVENTS ADD COLUMN "TCATALOG" VARCHAR NULL;

UPDATE AUDIT.EVENTS SET TCATALOG = 'BIGQUERY';

ALTER TABLE AUDIT.EVENTS ALTER COLUMN "TCATALOG" VARCHAR NOT NULL;

UPDATE AUDIT.EVENTS SET PAYLOAD='{ "newRow" : ' || PAYLOAD || ' }'