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

[Juan Lucas Dominguez Rubio]

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6830 bytes
Desc: not available
Url : http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100114/385cec80/attachment.bin