Hey Jody, I'm looking to do prepared statements in PostGIS, but have a
couple questions.
It looks like you just call:
String sql = makeInsertSql(current);
statement = conn.prepareStatement( sql );
Just to confirm, the docs seem to say that you don't need to have '?'
things in your sql stateme
Um dave the method was from OracleFeatureWrtier (well actually
JDBCFeatureWriter) and was the original horrible hack left over from the
DataSource api.
I have updated it to use prepared statements, SDO class still I have
added the dependency on JTS1.7, but still need to pick up jtsio dependenc
Hi
After a couple of grulling hours, Jody and I have managed to find a
solution to the MultiLineString insert of geometries into Oracle.
We are now using PreparedStatements to insert geometries using STRUCT
objects instead of constructing the raw sql statement and executing it.
Oliver
On 3/14/
That method will take care of it for you, notice MultiLineString is a subclass of Geometry :)
Cheers,
David
On 3/14/06, Oliver Loe <[EMAIL PROTECTED]> wrote:
HiI'm trying to encode MultiLineString geometries to be inserted into oracle. I found this method in SQLEncodeOracle:public static Stri