Striim 3.9.4 / 3.9.5 documentation

Creating the checkpoint table

DatabaseWriter uses the table specified by the CheckpointTable property to store information used to ensure that there are no missing or duplicate events after recovery (see Recovering applications). Before starting DatabaseWriter, use the following DDL to create the table, and grant insert, update, and delete privileges to the user specified in the Username property. The table and column names are case-sensitive, do not change them.

Cassandra:

CREATE TABLE chkpoint (
  id varchar PRIMARY KEY,
  sourceposition blob,
  pendingddl int,
  ddl ascii);

Microsoft SQL Server:

CREATE TABLE CHKPOINT (
  id VARCHAR(100) PRIMARY KEY,
  sourceposition VARBINARY(MAX), 
  pendingddl BIT, 
  ddl VARCHAR(MAX));

MySQL:

CREATE TABLE CHKPOINT (
  id VARCHAR(100) PRIMARY KEY, 
  sourceposition BLOB, 
  pendingddl BIT(1), 
  ddl LONGTEXT);

Oracle:

CREATE TABLE CHKPOINT (
  ID VARCHAR2(100) PRIMARY KEY, 
  SOURCEPOSITION BLOB, 
  PENDINGDDL NUMBER(1), 
  DDL CLOB);

PostgreSQL:

create table chkpoint (
  id character varying(100) primary key,
  sourceposition bytea,
  pendingddl numeric(1), 
  ddl text);