Can you spin up a DBR 18+ all-purpose compute cluster with this spark config set to true

spark.databricks.connector.oracle.properlyCompileJava8Values true

and then re-run your tests?

If this works then I think it might be a known issue and we can find a path forward for dbsql/serverless compute (where you won't be able to set this config yourself).