Problem to use custom datasource with oracle

[FranckyMan]

Hello,
I'm using quartz version 3.13.1 on c# application.

I'm trying to start quartz in cluster mode with a custom db provider but i have these Oracle errors on some queries whereas main tables like QRTZ_JOB_DETAILS, QRTZ_SCHEDULER_STATE, QRTZ_TRIGGERS are well filled at the begining.

When i start with empty table for quartz i have this "ORA-00942: Table or view does not exist" on this query

SELECT \r\n JOB_NAME,\r\n JOB_GROUP,\r\n DESCRIPTION,\r\n NEXT_FIRE_TIME,\r\n PREV_FIRE_TIME,\r\n TRIGGER_TYPE,\r\n START_TIME,\r\n END_TIME,\r\n CALENDAR_NAME,\r\n MISFIRE_INSTR,\r\n PRIORITY,\r\n JOB_DATA,\r\n CRON_EXPRESSION,\r\n TIME_ZONE_ID,\r\n REPEAT_COUNT,\r\n REPEAT_INTERVAL,\r\n TIMES_TRIGGERED \r\n FROM \r\n QRTZ_TRIGGERS t\r\n LEFT JOIN\r\n QRTZ_SIMPLE_TRIGGERS st ON (st.SCHED_NAME = t.SCHED_NAME AND st.TRIGGER_GROUP = t.TRIGGER_GROUP AND st.TRIGGER_NAME = t.TRIGGER_NAME)\r\n LEFT JOIN\r\n QRTZ_CRON_TRIGGERS ct ON (ct.SCHED_NAME = t.SCHED_NAME AND ct.TRIGGER_GROUP = t.TRIGGER_GROUP AND ct.TRIGGER_NAME = t.TRIGGER_NAME)\r\n WHERE\r\n t.SCHED_NAME = @schedulerName AND t.TRIGGER_NAME = @triggerName AND t.TRIGGER_GROUP = @triggerGroup

and when i start with not empty table i have "ORA-01722: invalid number" on this query for column "SCHED_NAME" whereas this column should be able to store VARCHAR2

UPDATE QRTZ_TRIGGERS SET JOB_NAME = @triggerJobName, JOB_GROUP = @triggerJobGroup, DESCRIPTION = @triggerDescription, NEXT_FIRE_TIME = @triggerNextFireTime, PREV_FIRE_TIME = @triggerPreviousFireTime, \r\n TRIGGER_STATE = @triggerState, TRIGGER_TYPE = @triggerType, START_TIME = @triggerStartTime, END_TIME = @triggerEndTime, CALENDAR_NAME = @triggerCalendarName, MISFIRE_INSTR = @triggerMisfireInstruction, PRIORITY = @triggerPriority\r\n WHERE SCHED_NAME = @schedulerName AND TRIGGER_NAME = @triggerName AND TRIGGER_GROUP = @triggerGroup

No job are triggered and the qrtz_fired_trigger alwayz stay empty

I use custom database, because in production mode the Oracle user will not be the tables owner.
Here are my source code for my cutom db provider

using Quartz.Impl.AdoJobStore.Common;
using Oracle.ManagedDataAccess.Client; // Replace with your DB provider if needed
using System.Data.Common;
using Microsoft.Extensions.Configuration;
using System;

public class QuartzDbConnectionProvider : IDbProvider
{
	public string ConnectionString { get; set; }

	public DbMetadata Metadata
	{
		get
		{
			try
			{
				// Return a DbMetadata object that describes the capabilities of your database
				Console.WriteLine($"QuartzDbConnectionProvider:get metadata...");
				return new DbMetadata()
				{
					ProductName = "Oracle, Managed Oracle provider",
					AssemblyName = "Oracle.ManagedDataAccess",
					ConnectionType = typeof(OracleConnection),
					CommandType = typeof(OracleCommand),
					ParameterType = typeof(OracleParameter),
					ParameterDbType = typeof(OracleDbType),
					ParameterDbTypePropertyName = "OracleDbType",
					ParameterNamePrefix = ":",
					ExceptionType = typeof(OracleException),
					UseParameterNamePrefixInParameterCollection = false,
					BindByName = true,
					DbBinaryTypeName = "Blob",
				};
			}
			catch (Exception ex )
			{
				Console.WriteLine($"QuartzDbConnectionProvider:get db Metadata exception : {ex}");
				throw;
			}
		}
	}

	public  QuartzDbConnectionProvider()
	{
		try
		{
			Console.WriteLine($"QuartzDbConnectionProvider:QuartzDbConnectionProvider...");
			var configuration = new ConfigurationBuilder()
			.SetBasePath(AppDomain.CurrentDomain.BaseDirectory)
			.AddJsonFile("MyAssembly.MyProject.appsettings.Development.json", optional: false, reloadOnChange: true)
			.Build();

			ConnectionString = configuration["Quartz:quartz.dataSource.wallet.connectionString"];
			Console.WriteLine($"QuartzDbConnectionProvider:Value of SomeSettingKey: {ConnectionString}");
		}
		catch (Exception ex)
		{
			Console.WriteLine($"QuartzDbConnectionProvider:QuartzDbConnectionProvider : {ex}");
			throw;
		}
	}
	
	//Not called
	public QuartzDbConnectionProvider(string dbProviderName, string connectionString)
	{
		ConnectionString = connectionString;
		Console.WriteLine($"Value of SomeSettingKey2: {ConnectionString}");
	}

	public void Initialize()
	{
		try
		{
			Console.WriteLine($"QuartzDbConnectionProvider:Initialize...");
			if (string.IsNullOrWhiteSpace(ConnectionString))
			{
				throw new ArgumentException("ConnectionString must be set before initialization.");
			}
		}
		catch (Exception ex)
		{
			Console.WriteLine($"QuartzDbConnectionProvider:Initialize : {ex}");
			throw;
		}

	}

	public DbConnection CreateConnection()
	{
		// Create the Oracle connection
		Console.WriteLine($"QuartzDbConnectionProvider:CreateConnection...");
		var connection = new OracleConnection(ConnectionString);

		try
		{
			// Open the connection
			connection.Open();

			// Set the role or execute any session-specific SQL commands
			using var command = connection.CreateCommand();

			{
				Console.WriteLine($"QuartzDbConnectionProvider:Set role");
				command.CommandText = "SET ROLE MY_ROLE IDENTIFIED BY MY_PWD"; // Replace with your role command
				command.ExecuteNonQuery();

				command.CommandText = "ALTER SESSION SET current_schema = MY_SHCEMA";
				command.ExecuteNonQuery();

			}
			connection.Close();
		}
		catch (Exception ex)
		{
			connection.Dispose();
			Console.WriteLine($"QuartzDbConnectionProvider:CreateConnection : {ex}");
			throw;
		}

		return connection;
	}

	public DbCommand CreateCommand()
	{
		Console.WriteLine($"QuartzDbConnectionProvider:CreateCommand...");
		try
		{ 
			return new OracleCommand();
		}
		catch (Exception ex)
		{
			Console.WriteLine($"QuartzDbConnectionProvider:CreateCommand : {ex}");
			throw;
		}
	}

	public void Shutdown()
	{
		// Logic to clean up resources if necessary
	}
}

and settings

"quartz.dataSource.wallet.provider": "WalletOracleProvider",
"quartz.dataSource.wallet.connectionString": "Data Source=MySource;User Id=/;Max Pool Size=10;Min Pool Size=1;Connection Lifetime=0;Incr Pool Size=1;Decr Pool Size=1;Connection Timeout=120;Validate Connection=True;",
"quartz.dataSource.wallet.connectionProvider.type": "QuartzDbConnectionProvider, MyAssembly",

"quartz.jobStore.type": "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz",
"quartz.jobStore.driverDelegateType": "Quartz.Impl.AdoJobStore.OracleDelegate, Quartz",
"quartz.jobStore.useProperties": false,
"quartz.jobStore.dataSource": "wallet",
"quartz.jobStore.tablePrefix": "QRTZ_",
...
"quartz.jobStore.misfireThreshold": 100,

I hope i put enough details.

Thank you in advance for your help