Thank you very much. We'll look into this as soon as possible 2015-06-01 9:27 GMT+02:00 Andreas Ahlenstorf <[email protected]>:
> On 29 May 2015 at 18:16, Lukas Eder <[email protected]> wrote: > > > Could you please provide the DDL of the table that contains this > position column? It will be helpful in trying to reproduce this issue. > Also, the source code of PositionConverter and Position (if you wrote that > yourself) would be needed. > > public class PositionConverter implements Converter<Object, Position> { > > @Override > public Position from(Object object) { > if (object == null) { > return null; > } > > Geometry geometry = ((PGgeometry) object).getGeometry(); > > if (!(geometry instanceof Point)) { > throw new IllegalArgumentException("Geometry is not a > org.postgis.Point."); > } > > Point point = (Point)geometry; > > return new Position(BigDecimal.valueOf(point.getX()), > BigDecimal.valueOf(point.getY())); > } > > @Override > public Object to(Position position) { > if (position == null) { > return null; > } > > Point p = new Point(position.getLatitude().doubleValue(), > position.getLongitude().doubleValue()); > p.setSrid(Position.SPATIAL_REF_SYS); > return new PGgeometry(p); > } > > @Override > public Class<Object> fromType() { > return Object.class; > } > > @Override > public Class<Position> toType() { > return Position.class; > } > } > > public class Position { > > public static final int SPATIAL_REF_SYS = 4326; > > private BigDecimal latitude; > > private BigDecimal longitude; > > // getters, setters omitted > } > > create table data_point ( > id serial primary key, > survey_id integer not null, > probe_id integer not null, > position geography(point,4326) null, > date_recorded timestamp with time zone not null, > date_arrived timestamp with time zone not null, > data json null > ); > > Regards, > Andreas > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
