PostGis geometry - Teiid

[parrotola]

Hi,

I have a virtualDb with some geometry fields (not WKB or WKT). In order to extract data,I have to enable some

spatial functions such as ST_asTEXT and ST_INTERSECT. I get this exception:

java.lang.ClassNotFoundException: org.postgresql.util.PGobject cannot be found by org.teiid.runtime.client_9.2.0.Final-v20151028-1427-B4011

How I can manage spatial data on Teiid?

Best regards.

Francesco

[shawkins]

> How I can manage spatial data on Teiid?

I don't quite have enough information to go by yet.  Can you provide the vdb that you are using?  Or at least indicate what the Teiid source column type is - object or geometry - and what user query you are issuing?  If the source column type is geometry, then you'd expect the translator to handle the conversion from the source representation into the Teiid representation.

[parrotola]

I installed Teiid deisgner 10.0 and I solved the problem.

Thank you.

Francesco