it helps partially, I mean I have different errors right now: - no suitable method found for createParameter(java.lang.String,org.jooq.DataType<java.lang.Boolean>,boolean,boolean,com.tomtom.orbis.orbisctsnapshotslingshot.slingshot.JooqGeometryToJtsGeometryBinding) - no suitable method found for createParameter(java.lang.String,org.jooq.DataType<java.lang.Object>,boolean,boolean,com.tomtom.orbis.orbisctsnapshotslingshot.slingshot.JooqGeometryToJtsGeometryBinding) - no suitable method found for createParameter(java.lang.String,org.jooq.DataType<java.lang.Object>,boolean,boolean,com.tomtom.orbis.orbisctsnapshotslingshot.slingshot.JooqGeometryToJtsGeometryBinding) - no suitable method found for createParameter(java.lang.String,org.jooq.DataType<java.lang.Double>,boolean,boolean,com.tomtom.orbis.orbisctsnapshotslingshot.slingshot.JooqGeometryToJtsGeometryBinding) - no suitable constructor found for AbstractRoutine(java.lang.String,org.jooq.codegen.maven.gss.Public,org.jooq.DataType<java.lang.Boolean>,com.tomtom.orbis.orbisctsnapshotslingshot.slingshot.JooqGeometryToJtsGeometryBinding)
poniedziałek, 5 września 2022 o 14:04:09 UTC+2 [email protected] napisał(a): > The jOOQ type is org.jooq.Geometry, not org.jooq.impl.Geometry. > > I hope this helps, > Lukas > > On Mon, Sep 5, 2022 at 11:38 AM Tomasz Burdka <[email protected]> wrote: > >> Hi, >> I'm using jOOQ to create new database based on existing one. Existing >> Postgis DB has a table with Geometry (Point,4326) type. When I'm using jOOQ >> to generate code, it switch this geometry type to SQLDataType.GEOMETRY. I >> am able to create new DB but dataType is incorrect, when I'm trying to >> insert anything I've receiving message: >> *The out of the box binding for geometry is available in the commercial >> jOOQ distribution only. Alternatively, you can implement your own custom >> binding.* >> How can I create custom binding to solve this issue? I've tried something >> like that: >> >> >> import org.jooq.*; >> import org.jooq.impl.DSL; >> import org.locationtech.jts.io.ParseException; >> import org.locationtech.jts.io.WKTReader; >> >> import javax.validation.constraints.NotNull; >> import java.sql.SQLException; >> import java.sql.SQLFeatureNotSupportedException; >> >> public class JooqGeometryToJtsGeometryBinding implements >> Binding<Geometry, org.locationtech.jts.geom.Geometry> { >> private final WKTReader reader = new WKTReader(); >> >> @Override >> public @NotNull Converter<Geometry, org.locationtech.jts.geom.Geometry> >> converter() { >> return new Converter<>() { >> @Override >> public org.locationtech.jts.geom.Geometry from(Geometry geometry) { >> try { >> return geometry == null ? null : reader.read(geometry.data()); >> } catch (ParseException e) { >> throw new RuntimeException(e); >> } >> } >> >> @Override >> public Geometry to(org.locationtech.jts.geom.Geometry geometry) { >> return Geometry.geometry(geometry.toString()); >> } >> >> @Override >> public @NotNull Class<Geometry> fromType() { >> return Geometry.class; >> } >> >> @Override >> public @NotNull Class<org.locationtech.jts.geom.Geometry> toType() { >> return org.locationtech.jts.geom.Geometry.class; >> } >> }; >> } >> >> @Override >> public void sql(BindingSQLContext<org.locationtech.jts.geom.Geometry> >> bindingSQLContext) throws SQLException { >> bindingSQLContext.render().visit(DSL.sql("?::geometry")); >> } >> >> @Override >> public void >> register(BindingRegisterContext<org.locationtech.jts.geom.Geometry> >> bindingRegisterContext) throws SQLException { >> throw new SQLFeatureNotSupportedException(); >> } >> >> @Override >> public void >> set(BindingSetStatementContext<org.locationtech.jts.geom.Geometry> >> bindingSetStatementContext) throws SQLException { >> bindingSetStatementContext.statement() >> .setObject(bindingSetStatementContext.index(), >> bindingSetStatementContext.convert(converter()) >> .value()); >> } >> >> @Override >> public void >> set(BindingSetSQLOutputContext<org.locationtech.jts.geom.Geometry> >> bindingSetSQLOutputContext) throws SQLException { >> throw new SQLFeatureNotSupportedException(); >> } >> >> @Override >> public void >> get(BindingGetResultSetContext<org.locationtech.jts.geom.Geometry> >> bindingGetResultSetContext) throws SQLException { >> bindingGetResultSetContext.convert(converter()).value((Geometry) >> bindingGetResultSetContext.resultSet() >> .getObject(bindingGetResultSetContext.index())); >> } >> >> @Override >> public void >> get(BindingGetStatementContext<org.locationtech.jts.geom.Geometry> >> bindingGetStatementContext) throws SQLException { >> bindingGetStatementContext.convert(converter()) >> .value((Geometry) bindingGetStatementContext.statement() >> .getObject(bindingGetStatementContext.index())); >> } >> >> @Override >> public void >> get(BindingGetSQLInputContext<org.locationtech.jts.geom.Geometry> >> bindingGetSQLInputContext) throws SQLException { >> throw new SQLFeatureNotSupportedException(); >> } >> } >> >> >> with this xml changes in pom.xml : >> <forcedTypes> >> <forcedType> >> <!-- Specify the Java type of your custom type. This corresponds to the >> Binding's <U> type. --> >> <userType>org.jooq.impl.Geometry</userType> >> >> <!-- Associate that custom type with your binding. --> >> <binding>my.custom.package.JooqGeometryToJtsGeometryBinding</binding> >> </forcedType> >> </forcedTypes> >> >> >> But compiling doesn't work due to issues with: >> *import org.jooq.impl.Geometry; cannot resolve symbol 'Geometry' * >> in generated class≥ >> >> -- >> 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/c14c5f93-a7e8-4dec-b8a0-e852dd742758n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/c14c5f93-a7e8-4dec-b8a0-e852dd742758n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/47159046-2633-400b-a5a7-a5ff13af351en%40googlegroups.com.
