[seatunnel] branch dev updated: [bug][jdbc][oracle]Fix the Oracle number type mapping problem (#5209)

[liugddx]

This is an automated email from the ASF dual-hosted git repository.

liugddx pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/seatunnel.git


The following commit(s) were added to refs/heads/dev by this push:
     new 9d3c3de90d [bug][jdbc][oracle]Fix the Oracle number type mapping 
problem (#5209)
9d3c3de90d is described below

commit 9d3c3de90da3f50451d35c3723eebd0cb7b511eb
Author: ZhilinLi <zhilinli0...@gmail.com>
AuthorDate: Wed Aug 9 15:11:03 2023 +0800

    [bug][jdbc][oracle]Fix the Oracle number type mapping problem (#5209)
---
 .../seatunnel/jdbc/internal/dialect/oracle/OracleTypeMapper.java     | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git 
a/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/oracle/OracleTypeMapper.java
 
b/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/oracle/OracleTypeMapper.java
index 1ce9c3a72b..1822484b30 100644
--- 
a/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/oracle/OracleTypeMapper.java
+++ 
b/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/oracle/OracleTypeMapper.java
@@ -87,9 +87,10 @@ public class OracleTypeMapper implements 
JdbcDialectTypeMapper {
                 if (scale == 0) {
                     if (precision <= 9) {
                         return BasicType.INT_TYPE;
-                    }
-                    if (precision <= 18) {
+                    } else if (precision <= 18) {
                         return BasicType.LONG_TYPE;
+                    } else if (precision <= 38) {
+                        return new DecimalType(38, 0);
                     }
                 }
                 return new DecimalType(38, 18);