Create a pekko.projection.Projection with at-least-once processing semantics.

It stores the offset in a relational database table using JDBC after the handler has processed the envelope. This means that if the projection is restarted from previously stored offset then some elements may be processed more than once.

The JdbcHandler.process() in handler will be wrapped in a transaction. It is highly recommended to use a sessionFactory that provides java.sql.Connection's with setAutoCommit(false). The transaction will be committed after invoking JdbcHandler.process().

The offset is stored after a time window, or limited by a number of envelopes, whatever happens first. This window can be defined with AtLeastOnceProjection.withSaveOffset of the returned AtLeastOnceProjection. The default settings for the window is defined in configuration section pekko.projection.at-least-once.

Create a pekko.projection.Projection with at-least-once processing semantics.

Compared to JdbcProjection.atLeastOnce the Handler is not storing the projected result in the database, but is integrating with something else.

It stores the offset in a relational database table using JDBC after the handler has processed the envelope. This means that if the projection is restarted from previously stored offset then some elements may be processed more than once.

The offset is stored after a time window, or limited by a number of envelopes, whatever happens first. This window can be defined with AtLeastOnceProjection.withSaveOffset of the returned AtLeastOnceProjection. The default settings for the window is defined in configuration section pekko.projection.at-least-once.

Create a pekko.projection.Projection with a FlowWithContext as the envelope handler. It has at-least-once processing semantics.

The flow should emit a Done element for each completed envelope. The offset of the envelope is carried in the context of the FlowWithContext and is stored in the database when corresponding Done is emitted. Since the offset is stored after processing the envelope it means that if the projection is restarted from previously stored offset then some envelopes may be processed more than once.

If the flow filters out envelopes the corresponding offset will not be stored, and such envelope will be processed again if the projection is restarted and no later offset was stored.

The flow should not duplicate emitted envelopes (mapConcat) with same offset, because then it can result in that the first offset is stored and when the projection is restarted that offset is considered completed even though more of the duplicated enveloped were never processed.

The flow must not reorder elements, because the offsets may be stored in the wrong order and and when the projection is restarted all envelopes up to the latest stored offset are considered completed even though some of them may not have been processed. This is the reason the flow is restricted to FlowWithContext rather than ordinary Flow.

For testing purposes the projection offset and management tables can be created programmatically. For production it's recommended to create the table with DDL statements before the system is started.

Create a pekko.projection.Projection with exactly-once processing semantics.

It stores the offset in a relational database table using JDBC in the same transaction as the user defined handler.

Create a pekko.projection.Projection that groups envelopes and calls the handler with a group of Envelopes. The envelopes are grouped within a time window, or limited by a number of envelopes, whatever happens first. This window can be defined with GroupedProjection.withGroup of the returned GroupedProjection. The default settings for the window is defined in configuration section pekko.projection.grouped.

It stores the offset in a relational database table using JDBC in the same transaction as the user defined handler.

Create a pekko.projection.Projection that groups envelopes and calls the handler with a group of Envelopes. The envelopes are grouped within a time window, or limited by a number of envelopes, whatever happens first. This window can be defined with GroupedProjection.withGroup of the returned GroupedProjection. The default settings for the window is defined in configuration section pekko.projection.grouped.

Compared to JdbcProjection.groupedWithin the Handler is not storing the projected result in the database, but is integrating with something else.

It stores the offset in a relational database table using JDBC immediately after the handler has processed the envelopes, but that is still with at-least-once processing semantics. This means that if the projection is restarted from previously stored offset the previous group of envelopes may be processed more than once.