Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-22 Thread Andrea Aime
v...@csiro ha scritto: > I was thinking somewhere along the line of: > > String sql = "select id, st_asbinary(shape) as shape from geology.table "; > ResultSet p = postgis.createStatement().executeQuery(sql); > PreparedStatement s = oracle.prepareStatement("update table set

Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread Derrick.Wong
n) Cc: geotools-devel@lists.sourceforge.net Subject: Re: [Geotools-devel] postgis st_asbinary(shape) v...@csiro ha scritto: > Hi, can someone kindly advice me on this. > > I have a geometry column on postgis and would like to move that data into > oracle spatial. > > Can someone

Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread v...@csiro
I was thinking somewhere along the line of: String sql = "select id, st_asbinary(shape) as shape from geology.table "; ResultSet p = postgis.createStatement().executeQuery(sql); PreparedStatement s = oracle.prepareStatement("update table set shape=SDO_GEOMETRY(?) where id=

Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread Andrea Aime
v...@csiro ha scritto: > Hi, can someone kindly advice me on this. > > I have a geometry column on postgis and would like to move that data into > oracle spatial. > > Can someone advice the best/easiest way of doing this? > > I have tried moving data out of postgis as wkt and insert into oracl

[Geotools-devel] postgis st_asbinary(shape)

2010-06-21 Thread v...@csiro
Hi, can someone kindly advice me on this. I have a geometry column on postgis and would like to move that data into oracle spatial. Can someone advice the best/easiest way of doing this? I have tried moving data out of postgis as wkt and insert into oracle sdo_geometry(wkt) but some of the wk