[Gvsig_english] [Gvsig_usuarios] oracle plugin crashes with point layers on oracle10.2

[Juan Lucas Dominguez Rubio]

> Could we manage this inside the oracle plugin?
> Maybe setting Z to 0 if it's NULL. 
 
Ok, We'll do that.
 
If a table called TABLE_NAME has a column called GEOMETRY_COLUMN with 3D points whose Z is null, you can convert them to 2D points with:
 
SELECT mdsys.sdo_geometry(
2001,
t.GEOMETRY_COLUMN.sdo_srid,
mdsys.sdo_point_type(t.GEOMETRY_COLUMN.sdo_point.X, t.GEOMETRY_COLUMN.sdo_point.Y, null),
null,
null)
FROM
TABLE_NAME t
 
(maybe we should send our emails in English only to the international list)
 
 
 
Regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_usuarios-bounces at listserv.gva.es en nombre de giohappy
Enviado el: jue 14/01/2010 11:28
Para: gvsig_usuarios at listserv.gva.es
Asunto: Re: [Gvsig_usuarios] [Gvsig_english] oracle plugin crashes with point layers on oracle10.2




Hi Juan. thanks for the reply.
Sorry, I meant 3001.
The problem was that, the SDO_POINT.Z set NULL. Anyway this is valid for
Oracle (I checked it with its validating functions), and this is what
returns when you make a get_centroid on 3003 polygons: we get a 3d point but
with Z null.
Could we manage this inside the oracle plugin? Maybe setting Z to 0 if it's
NULL. For now we will do it inside the DB...

giovanni






jldominguez wrote:
>
> Hello, Giovanni.
> 
> The gtype 1003 is not for points as far as I know. Do you mean 3001?
> 
> The error happens because gvSIG finds a NULL value in the Z, so maybe
> there is a contradiction in your data (the metadata says it is a 3D point
> but the Z is null). Do you have any application to access the database
> (for example SQLDeveloper)? If so, try to execute this:
> 
> SELECT t.<GEOMETRY_COLUMN>.sdo_gtype, t.<GEOMETRY_COLUMN>.sdo_point FROM
> <TABLE_NAME> t WHERE ROWNUM < 10
> 
> You have to replace <GEOMETRY_COLUMN> and <TABLE_NAME> with your values.
> What is the result?
> 
> How did you create those geometries in the Oracle Database? Did you create
> them with gvSIG?
> 
> Regards,
> 
> Juan Lucas Domínguez Rubio
> ---
> Prodevelop SL, Valencia (España)
> Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
> http://www.prodevelop.es <http://www.prodevelop.es/>  <http://www.prodevelop.es/>
> ---
>
> ________________________________
>
> De: gvsig_internacional-bounces at listserv.gva.es en nombre de G. Allegri
> Enviado el: mié 13/01/2010 16:28
> Para: Users and Developers mailing list; Lista de Usuarios de gvSIG
> Asunto: [Gvsig_english] oracle plugin crashes with point layers on
> oracle10.2
>
>
>
> I have a point layer (gtype 1003) in oracle, version 10.2
> I'm using the ojdbc14.jar from oracle client.
>
> Linear and polygon layers load correctly, while points give
> NullPointerException for every point.
> Here is the  expection (just on of the other similar thousands!) from log:
>
> java.lang.NullPointerException
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialUtils.getFMapGeometrySdoPoint(OracleSpatialUtils.java:2633)
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialUtils.getFMapGeometryPoint(OracleSpatialUtils.java:2583)
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getFMapGeometry(OracleSpatialDriver.java:587)
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getGeometryUsing(OracleSpatialDriver.java:538)
>         at
> es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialFeatureIterator.next(OracleSpatialFeatureIterator.java:141)
>         at
> com.iver.cit.gvsig.fmap.drivers.featureiterators.ReprojectWrapperFeatureIterator.next(ReprojectWrapperFeatureIterator.java:92)
>         at
> com.iver.cit.gvsig.fmap.layers.FLyrVect._draw(FLyrVect.java:437)
>         at com.iver.cit.gvsig.fmap.layers.FLyrVect.draw(FLyrVect.java:631)
>         at
> com.iver.cit.gvsig.fmap.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:209)
>         at
> com.iver.cit.gvsig.fmap.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:175)
>         at com.iver.cit.gvsig.fmap.MapContext.draw(MapContext.java:1092)
>         at
> com.iver.cit.gvsig.fmap.MapControl$PaintingRequest.paint(MapControl.java:1043)
>         at
> com.iver.cit.gvsig.fmap.MapControl$Drawer2$Worker.run(MapControl.java:1234)
>         at java.lang.Thread.run(Unknown Source)
>
> giovanni
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
>
> _______________________________________________
> gvSIG_usuarios mailing list
> gvSIG_usuarios at listserv.gva.es
>
> Para ver histórico de mensajes, editar sus preferencias de usuario o darse
> de baja en esta lista, acuda a la siguiente dirección:
>
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios
>
>

--
View this message in context: http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4391745.html
Sent from the gvSIG usuarios mailing list archive at Nabble.com.
_______________________________________________
gvSIG_usuarios mailing list
gvSIG_usuarios at listserv.gva.es

Para ver histórico de mensajes, editar sus preferencias de usuario o darse de baja en esta lista, acuda a la siguiente dirección:

http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100114/a28ab880/attachment.htm