[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ] Fabian Knoll commented on TEIIDSB-227: -------------------------------------- This is an example for the workaround. The geom attribute must be of type Clob, not String:   {code:java} package com.example.teidvdbless.teidvdblessapp; import org.locationtech.jts.geom.Geometry; import org.locationtech.jts.geom.MultiLineString; import org.locationtech.jts.io.ParseException; import org.locationtech.jts.io.WKTReader; import org.teiid.spring.annotations.SelectQuery; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Lob; import java.io.IOException; import java.sql.Clob; import java.sql.SQLException; @Entity @SelectQuery("SELECT gid, ST_AsText(geom), name FROM nyc.nyc_streets") public class Street { @Id int gid; @Column @Lob Clob geom; @Column String name; public MultiLineString getMultiLineString() throws ParseException, SQLException, IOException { String wktString = getWktFromClob(this.geom); WKTReader wktReader = new WKTReader(); Geometry geometry = wktReader.read(wktString); return (MultiLineString) geometry; } private String getWktFromClob(Clob clob) throws SQLException, IOException { int lengthInt = calculateLengthOfClob(clob); char[] chars = new char[lengthInt]; this.geom.getCharacterStream().read(chars); String wktString = String.copyValueOf(chars); return wktString; } private int calculateLengthOfClob(Clob clob) throws SQLException { long length = clob.length(); int lengthInt = Math.toIntExact(length); return lengthInt; } } {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)