Search in sources :

Example 6 with ByteBuffer

use of org.geolatte.geom.ByteBuffer in project querydsl by querydsl.

the class MySQLWkbType method setValue.

@Override
public void setValue(PreparedStatement st, int startIndex, Geometry value) throws SQLException {
    WkbEncoder encoder = Wkb.newEncoder(Wkb.Dialect.POSTGIS_EWKB_1);
    ByteBuffer buffer = encoder.encode(value, byteOrder);
    int srid = value.getSRID();
    // prepend srid into first 4 bytes
    byte[] wkb = buffer.toByteArray();
    byte[] bytes = new byte[wkb.length + 4];
    bytes[3] = (byte) ((srid >> 24) & 0xFF);
    bytes[2] = (byte) ((srid >> 16) & 0xFF);
    bytes[1] = (byte) ((srid >> 8) & 0xFF);
    bytes[0] = (byte) (srid & 0xFF);
    System.arraycopy(wkb, 0, bytes, 4, wkb.length);
    st.setBytes(startIndex, bytes);
}
Also used : WkbEncoder(org.geolatte.geom.codec.WkbEncoder) ByteBuffer(org.geolatte.geom.ByteBuffer)

Example 7 with ByteBuffer

use of org.geolatte.geom.ByteBuffer in project querydsl by querydsl.

the class GeometryWkbType method setValue.

@Override
public void setValue(PreparedStatement st, int startIndex, Geometry value) throws SQLException {
    WkbEncoder encoder = Wkb.newEncoder(Wkb.Dialect.POSTGIS_EWKB_1);
    ByteBuffer buffer = encoder.encode(value, byteOrder);
    st.setBytes(startIndex, buffer.toByteArray());
}
Also used : WkbEncoder(org.geolatte.geom.codec.WkbEncoder) ByteBuffer(org.geolatte.geom.ByteBuffer)

Example 8 with ByteBuffer

use of org.geolatte.geom.ByteBuffer in project hibernate-orm by hibernate.

the class MySQLGeometryTypeDescriptor method getBinder.

@Override
public <X> ValueBinder<X> getBinder(final JavaTypeDescriptor<X> javaTypeDescriptor) {
    return new BasicBinder<X>(javaTypeDescriptor, this) {

        @Override
        protected void doBind(PreparedStatement st, X value, int index, WrapperOptions options) throws SQLException {
            final WkbEncoder encoder = Wkb.newEncoder(Wkb.Dialect.MYSQL_WKB);
            final Geometry geometry = getJavaDescriptor().unwrap(value, Geometry.class, options);
            final ByteBuffer buffer = encoder.encode(geometry, ByteOrder.NDR);
            final byte[] bytes = (buffer == null ? null : buffer.toByteArray());
            st.setBytes(index, bytes);
        }

        @Override
        protected void doBind(CallableStatement st, X value, String name, WrapperOptions options) throws SQLException {
            final WkbEncoder encoder = Wkb.newEncoder(Wkb.Dialect.MYSQL_WKB);
            final Geometry geometry = getJavaDescriptor().unwrap(value, Geometry.class, options);
            final ByteBuffer buffer = encoder.encode(geometry, ByteOrder.NDR);
            final byte[] bytes = (buffer == null ? null : buffer.toByteArray());
            st.setBytes(name, bytes);
        }
    };
}
Also used : Geometry(org.geolatte.geom.Geometry) WkbEncoder(org.geolatte.geom.codec.WkbEncoder) CallableStatement(java.sql.CallableStatement) WrapperOptions(org.hibernate.type.descriptor.WrapperOptions) PreparedStatement(java.sql.PreparedStatement) ByteBuffer(org.geolatte.geom.ByteBuffer) BasicBinder(org.hibernate.type.descriptor.sql.BasicBinder)

Aggregations

ByteBuffer (org.geolatte.geom.ByteBuffer)8 WkbEncoder (org.geolatte.geom.codec.WkbEncoder)5 WkbDecoder (org.geolatte.geom.codec.WkbDecoder)3 CallableStatement (java.sql.CallableStatement)1 PreparedStatement (java.sql.PreparedStatement)1 Geometry (org.geolatte.geom.Geometry)1 WrapperOptions (org.hibernate.type.descriptor.WrapperOptions)1 BasicBinder (org.hibernate.type.descriptor.sql.BasicBinder)1 PGobject (org.postgresql.util.PGobject)1