Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: DB2 JDBC equivalent of oracel.sql.STRUCT and oracle.spatial.geometry.JGeometry?


    I'm asking this just to check, because I believe the answer is "no", but in case not, is there a JDBC extension for DB2 that has equivalent classes for oracle.spatial.geometry.JGeometry and oracle.sql.STRUCT?

    In Oracle, these classes enable you to retrieve data from a spatial column:
    STRUCT struct = (oracle.sql.STRUCT) myResultSet.getObject(i);
    JGeometry geom = JGeometry.load(struct);

    In DB2, from my research so far, you have to create your own equivalent JGeometry class, and convert from java.sql.BLOB/CLOB. Is there another way to get spatial data from a DB2 database in Java program?


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    You are right in that you have to roll your own API for this. Here you can find some examples:

    Visualize DB2 spatial data in Web applications
    Visualize spatial data in DB2 (Geotools modules 2.6-SNAPSHOT API)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts