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

[giohappy]

> Ok, We'll do that.

thanks
> 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:

yes, I've made it in past projects, but this time we have to mantain
our customer's original datatypes.

giovanni

PS: I had problems with the gvsig MLs, I couldn't neither send nor
receive (I've answered you thorugh nabble2). Now I receive the digest
again. Sorry for this confusion....


>
>
>
>
> 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: [hidden email] 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
> > [hidden email]
> > http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
> >
> >
> >
> > _______________________________________________
> > gvSIG_usuarios mailing list
> > [hidden email]
> >
> > 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
> [hidden email]
>
> 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
>
>
>
>
> _______________________________________________
> gvSIG_usuarios mailing list
> [hidden email]
>
> 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
>
> winmail.dat (13K) Download Attachment
>
> ________________________________
> View message @ http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4392028.html
> To unsubscribe from Re: [Gvsig_english] oracle plugin crashes with point layers on oracle10.2, click here.

-- 
View this message in context: http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4392097.html
Sent from the gvSIG usuarios mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_usuarios/attachments/20100114/feb72711/attachment.htm