in jdbc/src/main/scala/org/apache/pekko/projection/jdbc/internal/JdbcOffsetStore.scala [231:259]
def readManagementState(projectionId: ProjectionId): Future[Option[ManagementState]] = {
withConnection(jdbcSessionFactory) { conn =>
if (verboseLogging)
logger.debug(
"reading ManagementState for [{}], using connection id [{}]",
projectionId,
System.identityHashCode(conn))
// init Statement in try-with-resource
tryWithResource(conn.prepareStatement(settings.dialect.readManagementStateQuery)) { stmt =>
stmt.setString(1, projectionId.name)
stmt.setString(2, projectionId.key)
// init ResultSet in try-with-resource
tryWithResource(stmt.executeQuery()) { resultSet =>
val result = if (resultSet.next()) {
val paused = resultSet.getBoolean("PAUSED")
Some(ManagementState(paused))
} else {
None
}
if (verboseLogging) logger.debug2("found ManagementState [{}] for [{}]", result, projectionId)
result
}
}
}
}