Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

使用yugong 这个工程做oracle 迁移到TIDB 显示表not found #141

Open
nieshoujun opened this issue Oct 29, 2020 · 2 comments
Open

Comments

@nieshoujun
Copy link

使用mysql 从oracle 迁移时没有问题的

如果换TIDB 驱动还是mysql 但是会报错 ,同样的表结构在mysql 正常
Caused by: com.taobao.yugong.exception.YuGongException: table[null.ODS_BS_LESSON] is not found
at com.taobao.yugong.common.db.meta.TableMetaGenerator$1.doInConnection(TableMetaGenerator.java:75)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342)
at com.taobao.yugong.common.db.meta.TableMetaGenerator.getTableMeta(TableMetaGenerator.java:51)
at com.taobao.yugong.applier.FullRecordApplier.getSqlUnit(FullRecordApplier.java:197)
at com.taobao.yugong.applier.FullRecordApplier.doApply(FullRecordApplier.java:87)
at com.taobao.yugong.applier.MultiThreadFullRecordApplier$1.run(MultiThreadFullRecordApplier.java:93)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)

@ciigileele
Copy link

试试TIDB创建表的时候,表名全部大写;或者在对应表名的java类中,将表名改为小写。

@gemenhuimofa
Copy link

image
为啥库名是null

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants