You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "RichardXu186 (via GitHub)" <gi...@apache.org> on 2025/01/16 08:18:24 UTC
[I] [Bug] [Module Name]oracle source connector连接oracle 11g时失败 [seatunnel]
RichardXu186 opened a new issue, #8537:
URL: https://github.com/apache/seatunnel/issues/8537
### Search before asking
- [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) 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
```conf
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
```shell
./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
```log
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
- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed [seatunnel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-3066302811
This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Module Name]oracle source connector连接oracle 11g时失败 [seatunnel]
Posted by "RichardXu186 (via GitHub)" <gi...@apache.org>.
RichardXu186 commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-2594804715
[seatunnel.log](https://github.com/user-attachments/files/18435755/seatunnel.log)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed [seatunnel]
Posted by "RichardXu186 (via GitHub)" <gi...@apache.org>.
RichardXu186 commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-2661764436
这个要怎么操作?我还不太清楚
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed [seatunnel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #8537: [Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed
URL: https://github.com/apache/seatunnel/issues/8537
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Module Name]oracle source connector连接oracle 11g时失败 [seatunnel]
Posted by "sunxiaojian (via GitHub)" <gi...@apache.org>.
sunxiaojian commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-2598005363
update title [Module Name]->[Oracle CDC]
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Module Name]oracle source connector连接oracle 11g时失败 [seatunnel]
Posted by "RichardXu186 (via GitHub)" <gi...@apache.org>.
RichardXu186 commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-2599495353
我重新验证了下,不是连不上oracle,而是我的源表中有个字段数据有"/"这样的特色符号,例如“/html/cm/pe/custinfo/distribute/queryDistributeInfoHis.html",因为这个原因造成了上述错误
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed [seatunnel]
Posted by "akulabs8 (via GitHub)" <gi...@apache.org>.
akulabs8 commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-2613121626
@davidzollo Hey, please assign it to me
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Oracle JDBC]Oracle source connect to oracle 11g failed [seatunnel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #8537:
URL: https://github.com/apache/seatunnel/issues/8537#issuecomment-3092661315
This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org