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

In article <3820C418.E0DB2A8B_at_videotron.ca>,   Christian Ouellet <icouelleti_at_videotron.ca> wrote:
> 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
>
>

Salut Christian,

J'ai vécu le même problème. Je l'ai résolu en utilisant du PL/SQL. Oracle est supposé avoir fait le virage Java mais il n'a pas la maturité du PL/SQL (ça viendra!). Peut-être que dans ton cas le PL/SQL n'est pas une solution. J'ai aussi lu qu'Oracle produira un package Java pour le spatial avec la version 8.1.6. Je pense que ça prouve qu'il reconnaisse le problème!

En espérant que ça puisse t'aider

Jean-Marc Prévost

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 08:57:44 CST