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=?");
while (p.next()) {
s.setBytes(1, p.getBytes("shape"));
s.setInt(2, p.getInt("id"));
s.executeUpdate();
}
java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java
exception: java.lang.RuntimeException: -2
ORA-06512: at "MDSYS.SDO_UTIL", line 186
ORA-06512: at "MDSYS.SDO_GEOMETRY", line 76
So from the 2 solutions suggested, i would have to export to shapefile and
reimport that into oracle?
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/postgis-st-asbinary-shape-tp5203567p5207045.html
Sent from the geotools-devel mailing list archive at Nabble.com.
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
