Re: Inserting geometry using JDBC PreparedStatement

On 27-05-2013 14:23:54 -0500, Casey Gum wrote:

statement.executeUpdate();

In this case, feature.getGeometry() returns a string in WKT format.

Here's the error I get:

EXEC: wrong type for argument 5 of prepared statement: char, expected geometry

Thoughts?

I'd try to build an SQLData class, like the INET and URL classes in nl.cwi.monetdb.jdbc.types.

SQLTypeName probably is geometry, so you can use that for setObject(). Using your implemented UDT, you can build your own TypeMap that has the ("geometry", yourGeometryClass) mapping. This way, getObject() will return a yourGeometryClass instance.

Fabian