Re: [Geotools-devel] MultiLineString geometry encoding for Oracle

2006-03-30 Thread Chris Holmes
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

Re: [Geotools-devel] MultiLineString geometry encoding for Oracle

2006-03-14 Thread Jody Garnett
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

Re: [Geotools-devel] MultiLineString geometry encoding for Oracle

2006-03-14 Thread Oliver Loe
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/

Re: [Geotools-devel] MultiLineString geometry encoding for Oracle

2006-03-14 Thread David Zwiers
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