Data Types
The Simba Neo4j JDBC Driver supports many common data formats, converting between Neo4j data types and SQL data types.
The table below lists the supported data type mappings.
Note:
Any Neo4j data types that do not have a specific SQL mapping are mapped to SQL_VARCHAR.
| Neo4j Type | SQL Type | Java Type |
|---|---|---|
|
Boolean |
SQL_BOOLEAN |
Boolean |
|
ByteArray |
SQL_LONGVARBINARY |
Byte[] |
|
Date |
SQL_DATE |
Date |
|
DateTime |
SQL_TIMESTAMP |
Timestamp |
|
Duration |
SQL_VARCHAR |
Varchar |
|
Float |
SQL_DOUBLE |
Double |
|
Integer |
SQL_BIGINT |
Long |
|
LocalDateTime |
SQL_TIMESTAMP |
Timestamp |
|
LocalTime |
SQL_TIME |
Time |
|
Point |
SQL_VARCHAR |
Varchar |
|
String |
SQL_VARCHAR |
Varchar |
|
Time |
SQL_TIME |
Time |