Using JDBC and SQLJ with Oracle Spatial

From: Adam Lipscombe <adam_at_cobar.fsbusiness.co.uk>
Date: Thu, 4 Oct 2001 10:43:52 +0100
Message-ID: <9phb1c$j17$1@newsg2.svr.pol.co.uk>

Folks,

I need to read an Oracle Geometry object into a Java object using SQLJ or JDBC. The table def is:

 FEATURE_KEY                        NOT NULL NUMBER(8)
 DATASET_KEY                        NUMBER(8)
 FEATURE_STATUS_CODE     NUMBER(5)
 LOADED_DATE                       DATE
 LOADED_LOGIN_INITIALS  VARCHAR2(10)
 GIS_URN                                  VARCHAR2(12)
 GENAMAP_URN                     VARCHAR2(25)
 MATCH_ID                               VARCHAR2(1500)
 PROVIDER_BRANCH_KEY    NUMBER(8)
 CLASS_CODE                           NUMBER(8)
 GEOMETRY                               MDSYS.SDO_GEOMETRY

A sample query is:
select feature_key, geometry from features where rownum = 1;

Does anyone know how to map the MDSYS.SDO_GEOMETRY Oracle type to a Java class or type?
Are there any examples?

Many thanks - Adam Received on Thu Oct 04 2001 - 04:43:52 CDT