Skip to content

oracle cdc 2.1无法运行 #698

Answered by GeiChan
X1aoC asked this question in Q&A
Dec 8, 2021 · 2 comments · 2 replies
Discussion options

You must be logged in to vote

我今天也遇到了该问题,依赖问题导致的。我猜测,您使用的Driver也是 ojdbc6。更改为ojdbc8即可。
两个都存在时,有依赖冲突问题,排除掉ojdbc6即可
ojdbc6的getColumns获取的参数size只有18,而ojdbc8的getColumns获取的参数size为23.
debezium 的一段代码中有这样一段内容

  ColumnEditor column = Column.editor().name(columnName);
  column.type(columnMetadata.getString(6));
  column.length(columnMetadata.getInt(7));
  if (columnMetadata.getObject(9) != null) {
      column.scale(columnMetadata.getInt(9));
  }

  column.optional(isNullable(columnMetadata.getInt(11)));
  column.position(columnMetadata.getInt(17));
  column.autoIncremented("YES".equalsIgnoreCase(columnMetadata.getString(23)));   // 主要问题所在,使用ojdbc6时,索引越界了
  ...

希望对您有所帮助。

Replies: 2 comments 2 replies

Comment options

You must be logged in to vote
1 reply
@X1aoC
Comment options

Answer selected by X1aoC
Comment options

You must be logged in to vote
1 reply
@X1aoC
Comment options

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants