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

配置好的数据源,获取不到数据表信息。 #2297

Open
qulesky opened this issue Feb 6, 2024 · 5 comments
Open

配置好的数据源,获取不到数据表信息。 #2297

qulesky opened this issue Feb 6, 2024 · 5 comments
Assignees

Comments

@qulesky
Copy link

qulesky commented Feb 6, 2024

1、mysql8.0,通过数据源配置好连接,并测试通过后,创建数据视图,获取不到这个数据源下的表。
image
image
image
2、postgres也是有类似的问题,且不能查询。
image
image

@february
Copy link

february commented Feb 7, 2024

mysql数据库有同样的问题

@seemoredebug
Copy link

image
看到有个空指针异常

@OnesZhang
Copy link

OnesZhang commented Mar 12, 2024

我连接的sqlserver数据库,也有同样的问题,完全一样

@OnesZhang
Copy link

java.lang.NullPointerException: null
at datart.data.provider.jdbc.DataTypeUtils.jdbcType2DataType(DataTypeUtils.java:61)
at datart.data.provider.jdbc.adapters.JdbcDataProviderAdapter.readTableColumn(JdbcDataProviderAdapter.java:193)
at datart.data.provider.jdbc.adapters.JdbcDataProviderAdapter.readTableColumn(JdbcDataProviderAdapter.java:176)
at datart.data.provider.JdbcDataProvider.readTableColumns(JdbcDataProvider.java:85)
at datart.data.provider.ProviderManager.readTableColumns(ProviderManager.java:114)
at datart.server.service.impl.DataProviderServiceImpl.readTableColumns(DataProviderServiceImpl.java:140)
at datart.server.job.SchemaSyncJob.execute(SchemaSyncJob.java:94)
at datart.server.service.impl.SourceServiceImpl.lambda$updateJdbcSourceSyncJob$2(SourceServiceImpl.java:464)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

@nianhua99
Copy link
Contributor

这里有时候读到一些奇怪的视图时就会有报错,建议用一个数据源权限小一点的账号连接一下,看看是否正常

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

6 participants