Failure occurred during job recovery: Couldn't recover jobs: ORA-00932: inconsistent datatypes: expected CHAR got BOOLEAN

[hochun836]

Describe the bug

when I try Job Stores, I use

"quartz.jobStore.dataSource": "myOracle"
"quartz.dataSource.myOracle.provider": "OracleODPManaged",
"quartz.dataSource.myOracle.connectionString": "<connectionString-for-oracle>"

Then, exception happens when dotnet run

Quartz.Impl.AdoJobStore.JobStoreTX[0]
      Failure occurred during job recovery: Couldn't recover jobs: ORA-00932: inconsistent datatypes: expected CHAR got BOOLEAN
      Quartz.JobPersistenceException: Couldn't recover jobs: ORA-00932: inconsistent datatypes: expected CHAR got BOOLEAN
      ...

If I use

"quartz.jobStore.dataSource": "mySqlServer"
"quartz.dataSource.mySqlServer.provider": "SqlServer"
"quartz.dataSource.mySqlServer.connectionString": "<connectionString-for-sqlserver>"

Anything is fine

Version used

• dotnet 6
• Quartz 3.6.2
• Oracle 19c Standard Edition 2
• SQL Server 2019

To Reproduce

here is my appsettings.json

"Quartz": {
  "quartz.scheduler.instanceId": "DemoScheduler",
  "quartz.threadPool.maxConcurrency": 20,
  "quartz.jobStore.type": "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz",
  "quartz.jobStore.dataSource": "myOracle",
  "quartz.serializer.type": "json",
  "quartz.dataSource.mySqlServer.provider": "SqlServer",
  "quartz.dataSource.mySqlServer.connectionString": "<connectionString-for-sqlserver>",
  "quartz.dataSource.myOracle.provider": "OracleODPManaged",
  "quartz.dataSource.myOracle.connectionString": "<connectionString-for-oracle>"
}

here is my dependencies

<ItemGroup>
  <PackageReference Include="Quartz" Version="3.6.2" />
  <PackageReference Include="Quartz.AspNetCore" Version="3.6.2" />
  <PackageReference Include="Quartz.Serialization.Json" Version="3.6.2" />
  <PackageReference Include="Microsoft.Data.SqlClient" Version="2.1.0" />
  <PackageReference Include="Oracle.ManagedDataAccess.Core" Version="3.21.90" />
</ItemGroup>

here is my Program.cs

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddControllers();
builder.Services.Configure<QuartzOptions>(builder.Configuration.GetSection("Quartz"));
builder.Services.AddQuartz(config =>
{
    config.UseMicrosoftDependencyInjectionJobFactory();
});
builder.Services.AddQuartzServer(config =>
{
    config.WaitForJobsToComplete = true;
});

var app = builder.Build();
app.MapControllers();
app.Run();

[hochun836]

Finally, I add this to solve my problem

"quartz.jobStore.driverDelegateType": "Quartz.Impl.AdoJobStore.OracleDelegate, Quartz"

Here is the document

• ADO.NET Job Store (AdoJobStore)
• Configuration Reference (quartz.jobStore.driverDelegateType)