[Bug] [dinky-metadata] datasource oracle generate sql all column type is string

[xiaofan2022]

Search before asking

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

What happened

generate sql：
DROP TABLE IF EXISTS EXAMPLE_TABLE;
CREATE TABLE IF NOT EXISTS EXAMPLE_TABLE (
ID STRING,
VARCHAR_COL STRING,
CHAR_COL STRING,
NUMERIC_COL1 STRING,
NUMERIC_COL2 STRING,
DATE_COL STRING,
TIMESTAMP_COL STRING,
CLOB_COL STRING,
BLOB_COL STRING) WITH (
)
all cloumn type is string

What you expected to happen

Generate sql based on type mappinghttps://nightlies.apache.org/flink/flink-docs-release-1.19/docs/connectors/table/jdbc/#data-type-mapping

How to reproduce

oracle ddl:
CREATE TABLE example_table
(
id NUMBER(10, 0),
varchar_col VARCHAR2(100),
char_col CHAR(10),
numeric_col1 NUMBER(10, 2),
numeric_col2 NUMBER,
date_col DATE,
timestamp_col TIMESTAMP,
clob_col CLOB,
blob_col BLOB
);
use datasource->generate sql

Anything else

No response

Version

dev

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

[xiaofan2022]

I see that the OracleTypeConvert class in the code defines the relationship between db types and java types. Then we generate database field types from java types and documents, so why not directly use database types to generate table types according to document rules?

[aiwenmo]

The reason is to reduce workload.
This is a feasible solution that use database types to generate table types according to document rules.

[Zzm0809]

maybe like issue #3346

[github-actions]

Hello @xiaofan2022, thank you for your feedback, but this issue has been reported before. You can search for keywords in the Issue list to view it. Issues are marked as `Duplicate`.

你好 @xiaofan2022, 感谢你的反馈, 但是此问题已经被反馈过了，你可以在 Issue 列表中搜索关键字来查看, Issues 标注为 `Duplicate` 。