java oracle spatial_Using Java with Oracle Spatial — oracle-tech

I am using the JDBC (Java classes dowloaded from

technet.oracle.com - (sdoapi.zip)) together with Oracle Spatial

8.1.6. I am writing a collection of Linestrings into Oracle

Spatial using the supplied java classes(sdoapi.zip). I use the

function createGeometryCollection(myCollection)to write the

Linestring collection to Oracle Spatial and they are written to

the database without error. However, when I try to read the

object back I get the following error:

Exception in thread "main"

oracle.sdoapi.geom.InvalidGeometryException

at oracle.sdoapi.adapter.AdapterSDO.importGeometry

(AdapterSDO.java:101)

at

MapInfoToOracleSpatial.MapInfoToOracleSpatial.main

(MapInfoToOracleSpatial.java:211)

I do not have a listing of this code so can you please tell me

what the error is (line of code) at line 211. Also, when I use

the Oracle Spatial Index Advisor to view the spatial data, it

only displays a quarter of the data. When I use MapInfo to view

it's equivalent TAB (Table) file it views correctly all the

data.

I can't understand why this is happening because the writing to

oracle and creation of each individual linestring does not

throw an error. It is only when I try to read back larger

objects from the database (2500 points) that it gives an error.

Is there a limitation on the size one can create linestrings?

Thanks

Regards

Stephen Syrett

Mobile Telecommunications Network

(MTN) South Africa