SPATIAL:SDO_GEOMETRY:JDBC: problems loading large geometry objects into the database

Hi all,

        I'm trying to load geometry in Oracle8i Enterprise edition but i'm experiencing some problems.

1. I have code that succeed to insert region into a table but if the polygons have more than about 200 points, the statement execution block preparedStatement = connection.prepareStatement ("INSERT INTO MyGeoTable VALUES (?,?)); preparedStatement .setInt (1,gid); preparedStatement .setObject (2,sdo_geometry); preparedStatement.executeUpdate ();

Is it a bug of the JDBC thin driver that prevent it from passing big SDO_ORDINATES VARRAYS ? If so, is there any work around to load objects?

2) I did not find a way to specify null value to the SDO_GEOMETRY object pass to the prepared statement
for the point data, when trying to insert geometry into a table. For now, I create temporary object to replace null values.

3) I know i could use the sqlldr to load large amount of data, but that may really not be a solution for the
program i'm working on. I'm not sure the clients machines will have access to this oracle utility.

One work around my problems, would be , i'm thinking, to make my code upload through JDBC the geometry into a temporary table using the relational model and then migrate the table into Object Relational model, but I'm not sure it's feasible. Is there other alternative methods?

Thanks in advance for any help.
Christian Ouellet Received on Wed Nov 03 1999 - 17:24:09 CST