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

[giohappy]

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/> 
> ---
> 
> ________________________________
> 
> 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.