[MHA] map BigInteger to Types.NUMERIC instead of Types.DECIMAL

mohamed.hanchi · mohamed.hanchi · commit 3cd682ee2a69 · 2026-03-06T20:48:32.000+01:00
diff --git a/clickhouse-jdbc/src/main/java/com/clickhouse/jdbc/JdbcTypeMapping.java b/clickhouse-jdbc/src/main/java/com/clickhouse/jdbc/JdbcTypeMapping.java
@@ -158,11 +158,13 @@ protected int getSqlType(Class<?> javaClass) { // and purpose(e.g. for read or w
                 sqlType = Types.BIGINT;
             } else if (javaClass == float.class || javaClass == Float.class) {
                 sqlType = Types.FLOAT;
-            } else if (javaClass == double.class || javaClass == Double.class) {
-                sqlType = Types.DOUBLE;
-            } else if (javaClass == BigInteger.class || javaClass == BigDecimal.class) {
-                sqlType = Types.DECIMAL;
-            } else if (javaClass == Date.class || javaClass == LocalDate.class) {
+        } else if (javaClass == double.class || javaClass == Double.class) {
+            sqlType = Types.DOUBLE;
+        } else if (javaClass == BigInteger.class) {
+            sqlType = Types.NUMERIC;
+        } else if (javaClass == BigDecimal.class) {
+            sqlType = Types.DECIMAL;
+        } else if (javaClass == Date.class || javaClass == LocalDate.class) {
                 sqlType = Types.DATE;
             } else if (javaClass == Time.class || javaClass == LocalTime.class) {
                 sqlType = Types.TIME;
@@ -528,6 +530,13 @@ public Class<?> toJavaClass(ClickHouseColumn column, Map<String, Class<?>> typeM
 
         ClickHouseDataType type = column.getDataType();
         switch (type) {
+            case UInt64:
+            case Int128:
+            case UInt128:
+            case Int256:
+            case UInt256:
+                clazz = BigInteger.class;
+                break;
             case DateTime:
             case DateTime32:
             case DateTime64:
