protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
await Task.Yield();
_connection = new OracleConnection(_settings.GetConnectionString());
_connection.Open();
Console.WriteLine("Connected to ORACLE");
var sql = @$ "select * from VAN_SUBSIDIARY";
var cmd = new OracleCommand(sql, _connection);
// OracleDependency.Port = 49161;
// OracleDependency.Address = "adyensync-oracle";
var dependency = new OracleDependency(cmd);
// var orderId = 41851206;
dependency.QueryBasedNotification = false;
// dependency.AddCommandDependency(cmd);
dependency.OnChange += dependency_OnChange;
cmd.Notification.IsNotifiedOnce = false;
// cmd.Notification.IsPersistent = true;
// cmd.Notification.Timeout = 0;
cmd.AddRowid = true;
_dependecy = dependency;
try
{
cmd.ExecuteNonQuery();
Console.WriteLine("Subscribed");
await Task.Delay(1000, stoppingToken);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public OracleSubscriber(ILogger <OracleSubscriber> logger, IOracleSettings settings)
{
_logger = logger;
_settings = settings;
_logger.LogInformation(_settings.GetConnectionString());
}
