Advertisement
Guest User

Untitled

a guest
Jan 12th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. import groovy.sql.Sql
  2. import com.vividsolutions.jts.io.WKTReader
  3. import com.vividsolutions.jts.io.WKBWriter
  4. import com.vividsolutions.jts.geom.Geometry
  5.  
  6. def url = "jdbc:oracle:thin:@localhost:1521:TESTDB"
  7. sql = Sql.newInstance(url,"username","password","oracle.jdbc.driver.OracleDriver")
  8. WKTReader reader = new WKTReader()
  9. WKBWriter writer = new WKBWriter()
  10.  
  11. String wkt = "LINESTRING (-92.3213354 20.368354, -92.383172 20.4760694, -92.4390244 20.603732)"
  12. int objectid = 466
  13.  
  14. Geometry geom = reader.read(wkt)
  15.  
  16. byte[] wkb = writer.write(geom)
  17.  
  18. def stmt = """UPDATE FEATURE_TEST SET SHAPE = MDSYS.SDO_GEOMETRY(?,8307) WHERE OBJECTID = ?"""
  19. sql.executeUpdate(stmt.toString(),[wkb,objectid])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement