Hint
This article is generated by AI translation.
Array type handlers
Array handlers live in net.hasor.dbvisitor.types.handler.array.
| Handler | Java type | Purpose |
|---|---|---|
| ArrayTypeHandler | java.sql.Array | Read/write arrays via getArray/setArray |
| PgArrayTypeHandler | java.sql.Array | Read/write PostgreSQL arrays |
When creating a java.sql.Array you must provide the element type:
Array array = ps.getConnection().createArrayOf(typeName, ...);
JDBC types for common element Java types:
| Element Java type | JDBC type |
|---|---|
| boolean.class | JDBCType.BOOLEAN |
| Boolean.class | JDBCType.BOOLEAN |
| byte.class | JDBCType.TINYINT |
| Byte.class | JDBCType.TINYINT |
| short.class | JDBCType.SMALLINT |
| Short.class | JDBCType.SMALLINT |
| int.class | JDBCType.INTEGER |
| Integer.class | JDBCType.INTEGER |
| long.class | JDBCType.BIGINT |
| Long.class | JDBCType.BIGINT |
| float.class | JDBCType.FLOAT |
| Float.class | JDBCType.FLOAT |
| double.class | JDBCType.DOUBLE |
| Double.class | JDBCType.DOUBLE |
| Calendar.class | JDBCType.CHAR |
| char.class | JDBCType.CHAR |
| java.util.Date.class | JDBCType.TIMESTAMP |
| java.sql.Date.class | JDBCType.TIMESTAMP |
| java.sql.Timestamp.class | JDBCType.TIMESTAMP |
| java.sql.Time.class | JDBCType.TIMESTAMP |
| Instant.class | JDBCType.TIMESTAMP |
| LocalDateTime.class | JDBCType.TIMESTAMP |
| LocalDate.class | JDBCType.TIMESTAMP |
| LocalTime.class | JDBCType.TIMESTAMP |
| ZonedDateTime.class | JDBCType.TIMESTAMP |
| JapaneseDate.class | JDBCType.TIMESTAMP |
| YearMonth.class | JDBCType.TIMESTAMP |
| Year.class | JDBCType.TIMESTAMP |
| Month.class | JDBCType.TIMESTAMP |
| OffsetDateTime.class | JDBCType.TIMESTAMP |
| OffsetTime.class | JDBCType.TIMESTAMP |
| String.class | JDBCType.VARCHAR |
| BigInteger.class | JDBCType.BIGINT |
| BigDecimal.class | JDBCType.NUMERIC |
| Byte[].class | JDBCType.VARBINARY |
| byte[].class | JDBCType.VARBINARY |
| URL.class | JDBCType.DATALINK |
| URI.class | JDBCType.DATALINK |