Hi,
I've got a table that has a single, generic geometry column. When it comes
to insert, update and retrieve, I'd like the value type to be a GeoJSON
type, a simple POJO.
This is how I'd like my SQL insert/update statement to look, but I can't
figure out how to get my converter/binder to do this:
`insert into places (id, geom) values("foo", st_geomFromGeoJson(?))`
Where the value for the geom is a GeoJSON string.
For queries/reads, this is what the SQL looks like:
`select id, st_asGeoJson(geom) from places`
I've looked for examples of how to do this but not finding anything yet.
I've setup my generator project with a ForcedType and have a
converter/binder but I've had no luck in getting this to work so far. Any
tips or examples would be extremely appreciated!
Thanks!
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/03ef0177-033d-4d28-86cc-f0c96c942d7bn%40googlegroups.com.
