-
Notifications
You must be signed in to change notification settings - Fork 1.6k
/
OracleTypeMapper.java
128 lines (116 loc) · 5.53 KB
/
OracleTypeMapper.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.oracle;
import org.apache.seatunnel.api.table.type.BasicType;
import org.apache.seatunnel.api.table.type.DecimalType;
import org.apache.seatunnel.api.table.type.LocalTimeType;
import org.apache.seatunnel.api.table.type.PrimitiveByteArrayType;
import org.apache.seatunnel.api.table.type.SeaTunnelDataType;
import org.apache.seatunnel.common.exception.CommonError;
import org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.DatabaseIdentifier;
import org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.JdbcDialectTypeMapper;
import lombok.extern.slf4j.Slf4j;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
@Slf4j
public class OracleTypeMapper implements JdbcDialectTypeMapper {
// ============================data types=====================
private static final String ORACLE_UNKNOWN = "UNKNOWN";
// -------------------------number----------------------------
private static final String ORACLE_BINARY_DOUBLE = "BINARY_DOUBLE";
private static final String ORACLE_BINARY_FLOAT = "BINARY_FLOAT";
private static final String ORACLE_NUMBER = "NUMBER";
private static final String ORACLE_FLOAT = "FLOAT";
private static final String ORACLE_REAL = "REAL";
private static final String ORACLE_INTEGER = "INTEGER";
// -------------------------string----------------------------
private static final String ORACLE_CHAR = "CHAR";
private static final String ORACLE_VARCHAR2 = "VARCHAR2";
private static final String ORACLE_NCHAR = "NCHAR";
private static final String ORACLE_NVARCHAR2 = "NVARCHAR2";
private static final String ORACLE_LONG = "LONG";
private static final String ORACLE_ROWID = "ROWID";
private static final String ORACLE_CLOB = "CLOB";
private static final String ORACLE_NCLOB = "NCLOB";
private static final String ORACLE_XML = "SYS.XMLTYPE";
// ------------------------------time-------------------------
private static final String ORACLE_DATE = "DATE";
private static final String ORACLE_TIMESTAMP = "TIMESTAMP";
private static final String ORACLE_TIMESTAMP_WITH_LOCAL_TIME_ZONE =
"TIMESTAMP WITH LOCAL TIME ZONE";
// ------------------------------blob-------------------------
private static final String ORACLE_BLOB = "BLOB";
private static final String ORACLE_BFILE = "BFILE";
private static final String ORACLE_RAW = "RAW";
private static final String ORACLE_LONG_RAW = "LONG RAW";
@Override
public SeaTunnelDataType<?> mapping(ResultSetMetaData metadata, int colIndex)
throws SQLException {
String oracleType = metadata.getColumnTypeName(colIndex).toUpperCase();
int precision = metadata.getPrecision(colIndex);
int scale = metadata.getScale(colIndex);
switch (oracleType) {
case ORACLE_INTEGER:
return BasicType.INT_TYPE;
case ORACLE_FLOAT:
// The float type will be converted to DecimalType(10, -127),
// which will lose precision in the spark engine
return new DecimalType(38, 18);
case ORACLE_NUMBER:
if (scale == 0) {
if (precision <= 9) {
return BasicType.INT_TYPE;
} else if (precision <= 18) {
return BasicType.LONG_TYPE;
} else if (precision <= 38) {
return new DecimalType(38, 0);
}
}
return new DecimalType(38, 18);
case ORACLE_BINARY_DOUBLE:
return BasicType.DOUBLE_TYPE;
case ORACLE_BINARY_FLOAT:
case ORACLE_REAL:
return BasicType.FLOAT_TYPE;
case ORACLE_CHAR:
case ORACLE_NCHAR:
case ORACLE_NVARCHAR2:
case ORACLE_VARCHAR2:
case ORACLE_LONG:
case ORACLE_ROWID:
case ORACLE_NCLOB:
case ORACLE_CLOB:
case ORACLE_XML:
return BasicType.STRING_TYPE;
case ORACLE_DATE:
case ORACLE_TIMESTAMP:
case ORACLE_TIMESTAMP_WITH_LOCAL_TIME_ZONE:
return LocalTimeType.LOCAL_DATE_TIME_TYPE;
case ORACLE_BLOB:
case ORACLE_RAW:
case ORACLE_LONG_RAW:
case ORACLE_BFILE:
return PrimitiveByteArrayType.INSTANCE;
// Doesn't support yet
case ORACLE_UNKNOWN:
default:
final String jdbcColumnName = metadata.getColumnName(colIndex);
throw CommonError.convertToSeaTunnelTypeError(
DatabaseIdentifier.ORACLE, oracleType, jdbcColumnName);
}
}
}