Re: Using JDBC and SQLJ with Oracle Spatial

Go to http://technet.oracle.com and search for SDOAPI. Select the top document even though it says '500 Server Error'. This may give you the insight you need.

Steve Guilford
sguilford_at_minglewooddata.com

Adam Lipscombe wrote:

> 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 - 18:41:32 CDT