The jOOQ User Manual SQL building Data types Built-in data types GEOMETRY (Geometry)

previous : next

GEOMETRY (Geometry)

Supported by ❌ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The GEOMETRY data type represents spatial GEOMETRY value, or org.jooq.Geometry in Java. It has no representation in JDBC.

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", GEOMETRY)

Translates to the following dialect specific expressions:

Access, Aurora MySQL, Aurora Postgres, BigQuery, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Teradata, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c geometry
)

ASE, Sybase

CREATE TABLE t (
  c geometry NULL
)

ClickHouse

CREATE TABLE t (
  c Nullable(geometry)
)
ENGINE Log()

Databricks

CREATE TABLE t (
  c geometry
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

Oracle

CREATE TABLE t (
  c sdo_geometry
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), GEOMETRY)

Translates to the following dialect specific expressions:

Access

cstr(c)

ASE, Aurora MySQL, Aurora Postgres, BigQuery, CockroachDB, DB2, Databricks, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS geometry)

ClickHouse

CAST(c AS Nullable(geometry))

Oracle

CAST(c AS sdo_geometry)

The jOOQ User Manual SQL building Data types Built-in data types GEOMETRY (Geometry)

previous : next