Inserting geometry using JDBC PreparedStatement

27 May 2013

      Is there a way to use JDBC PreparedStatements to insert geospatial data?

Here's what my prepared statement looks like:

PreparedStatement statement = sqlRunner.prepareStatement(insertStatement);
statement.setString(1, id);
statement.setString(2, feature.getName());
statement.setString(3, feature.getDescription());
statement.setString(4, feature.getType().toString());
statement.setString(5, feature.getGeometry());
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?

Thanks,

Casey

Inserting geometry using JDBC PreparedStatement

Casey Gum