dmitry-zhuravlev / jooq-postgis-spatial Goto Github PK

Thanks for maintaining this repo! We are using it for more than a year now.
We are now migrating from legacy com.vividsolutions.jts to the new org.locationtech.jts.
Migration looks pretty straight forward: https://github.com/locationtech/jts/blob/master/MIGRATION.md
But it breaks backward compatibility.

I wanted to know if it's possible to also upgrade this project?
If you want I can create a PR.

When using PostGIS geometry types and storing a record it serializes the Point type incorrectly.
$10::geometry gets as parameter "(50.501899 10.963963)" instead of "Point(50.501899 10.963963)". Insert fails with an error ERROR: invalid input syntax for type point.

Column definition:

gps
    geometry
    not null

Record usage:

val record = dsl.newRecord(Tables.TABLE_WITH_GPS)
record.gps = org.postgis.Point(50.501899, 10.963963)
record.insert() // This throws an error

First off, thank you very much for your contribution. I've just found this on Google while looking into solving an issue related to jOOQ's code generation for PostGIS types: jOOQ/jOOQ#5872

Unfortunately, I need to ask you to rename your work's namespaces. We own the domain org.jooq and registered the jOOQ trademark. Your usage of the org.jooq groupId Java package prefix is against our trademark policies, mostly because we do not want people to think that this third-party work is ours or that we endorse using it.

The easiest solution would be to rename things to your personal name.

Thank you very much for your understanding.

It seems, that <customType/> is deprecated for a while now: jOOQ/jOOQ#7373

I guess the instructions for this plugin should be modified for the latest JOOQ version.

Why does constituent geometries in GeometryCollection has to have srid=0? I can't find any sources on the internet confirming this.

Current version is 1.0 and it doesn't include changes from #8 which I would be happy to use.

Is it possible to release a new artifact for the lib?