[Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed

[RichardXu186]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

采用ojdbc8-12.2.0.1.jar驱动包，该包放在$SEATUNNEL_HOME/lib下，oracle数据源版本是oracle 19c版本时，能正常执行，切换到oracle 11g的数据库后执行时报错

SeaTunnel Version

2.3.7

SeaTunnel Config

env {
    job.mode="BATCH"
    parallelism=1
}
source {
   jdbc {
        url = "jdbc:oracle:thin:@//"${dbserverip}":"${dbport}"/"${SID}
        driver = "oracle.jdbc.OracleDriver"
        user = ${dbuser}
        password = ${dbpassword}
        table_list =  [{ table_path = ${schema_name}"."${source_table} }]
     }
}
sink {
  console {}
}

Running Command

./bin/seatunnel.sh --config ./config/oracle2gbase.config -m local \
-i dbserverip=10.49.x.x \
-i dbport=1521 \
-i SID=orcl \
-i dbuser=huap \
-i dbpassword=xxx \
-i schema_name=HUAP \
-i source_table=AUAP_T_MENU

Error Exception

Exception in thread "main" org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed
	at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:211)
	at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
	at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34)
Caused by: org.apache.seatunnel.engine.common.exception.SeaTunnelEngineException: java.lang.NullPointerException
	at org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.oracle.OracleDialect.approximateRowCntStatement(OracleDialect.java:200)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.DynamicChunkSplitter.queryApproximateRowCnt(DynamicChunkSplitter.java:211)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.DynamicChunkSplitter.evenlyColumnSplitChunks(DynamicChunkSplitter.java:157)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.DynamicChunkSplitter.splitTableIntoChunks(DynamicChunkSplitter.java:128)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.DynamicChunkSplitter.createDynamicSplits(DynamicChunkSplitter.java:79)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.DynamicChunkSplitter.createSplits(DynamicChunkSplitter.java:66)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.ChunkSplitter.generateSplits(ChunkSplitter.java:101)
	at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceSplitEnumerator.run(JdbcSourceSplitEnumerator.java:81)
	at org.apache.seatunnel.engine.server.task.SourceSplitEnumeratorTask.stateProcess(SourceSplitEnumeratorTask.java:319)
	at org.apache.seatunnel.engine.server.task.SourceSplitEnumeratorTask.call(SourceSplitEnumeratorTask.java:138)
	at org.apache.seatunnel.engine.server.TaskExecutionService$BlockingWorker.run(TaskExecutionService.java:717)
	at org.apache.seatunnel.engine.server.TaskExecutionService$NamedTaskWrapper.run(TaskExecutionService.java:1039)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

	at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:203)

Zeta or Flink or Spark Version

zeta

Java or Scala Version

jdk1.8.0_312-b07

Screenshots

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[RichardXu186]

seatunnel.log

[sunxiaojian]

update title [Module Name]->[Oracle JDBC]

[RichardXu186]

我重新验证了下，不是连不上oracle，而是我的源表中有个字段数据有"/"这样的特色符号，例如“/html/cm/pe/custinfo/distribute/queryDistributeInfoHis.html"，因为这个原因造成了上述错误