> Ok, We'll do that.
<br><br>thanks
<br>> 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:
<br><br>yes, I've made it in past projects, but this time we have to mantain
<br>our customer's original datatypes.
<br><br>giovanni
<br><br>PS: I had problems with the gvsig MLs, I couldn't neither send nor
<br>receive (I've answered you thorugh nabble2). Now I receive the digest
<br>again. Sorry for this confusion....
<br><br><div class='shrinkable-quote'><br>>
<br>>
<br>>
<br>>
<br>> jldominguez wrote:
<br>> >
<br>> > Hello, Giovanni.
<br>> >
<br>> > The gtype 1003 is not for points as far as I know. Do you mean 3001?
<br>> >
<br>> > The error happens because gvSIG finds a NULL value in the Z, so maybe
<br>> > there is a contradiction in your data (the metadata says it is a 3D point
<br>> > but the Z is null). Do you have any application to access the database
<br>> > (for example SQLDeveloper)? If so, try to execute this:
<br>> >
<br>> > SELECT t.<GEOMETRY_COLUMN>.sdo_gtype, t.<GEOMETRY_COLUMN>.sdo_point FROM
<br>> > <TABLE_NAME> t WHERE ROWNUM < 10
<br>> >
<br>> > You have to replace <GEOMETRY_COLUMN> and <TABLE_NAME> with your values.
<br>> > What is the result?
<br>> >
<br>> > How did you create those geometries in the Oracle Database? Did you create
<br>> > them with gvSIG?
<br>> >
<br>> > Regards,
<br>> >
<br>> > Juan Lucas Domínguez Rubio
<br>> > ---
<br>> > Prodevelop SL, Valencia (España)
<br>> > Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
<br>> > <a href="http://www.prodevelop.es " target="_top" rel="nofollow">http://www.prodevelop.es </a><<a href="http://www.prodevelop.es/" target="_top" rel="nofollow">http://www.prodevelop.es/</a>> <<a href="http://www.prodevelop.es/" target="_top" rel="nofollow">http://www.prodevelop.es/</a>>
<br>> > ---
<br>> >
<br>> > ________________________________
<br>> >
<br>> > De: [hidden email] en nombre de G. Allegri
<br>> > Enviado el: mié 13/01/2010 16:28
<br>> > Para: Users and Developers mailing list; Lista de Usuarios de gvSIG
<br>> > Asunto: [Gvsig_english] oracle plugin crashes with point layers on
<br>> > oracle10.2
<br>> >
<br>> >
<br>> >
<br>> > I have a point layer (gtype 1003) in oracle, version 10.2
<br>> > I'm using the ojdbc14.jar from oracle client.
<br>> >
<br>> > Linear and polygon layers load correctly, while points give
<br>> > NullPointerException for every point.
<br>> > Here is the expection (just on of the other similar thousands!) from log:
<br>> >
<br>> > java.lang.NullPointerException
<br>> > at
<br>> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialUtils.getFMapGeometrySdoPoint(OracleSpatialUtils.java:2633)
<br>> > at
<br>> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialUtils.getFMapGeometryPoint(OracleSpatialUtils.java:2583)
<br>> > at
<br>> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getFMapGeometry(OracleSpatialDriver.java:587)
<br>> > at
<br>> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getGeometryUsing(OracleSpatialDriver.java:538)
<br>> > at
<br>> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialFeatureIterator.next(OracleSpatialFeatureIterator.java:141)
<br>> > at
<br>> > com.iver.cit.gvsig.fmap.drivers.featureiterators.ReprojectWrapperFeatureIterator.next(ReprojectWrapperFeatureIterator.java:92)
<br>> > at
<br>> > com.iver.cit.gvsig.fmap.layers.FLyrVect._draw(FLyrVect.java:437)
<br>> > at com.iver.cit.gvsig.fmap.layers.FLyrVect.draw(FLyrVect.java:631)
<br>> > at
<br>> > com.iver.cit.gvsig.fmap.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:209)
<br>> > at
<br>> > com.iver.cit.gvsig.fmap.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:175)
<br>> > at com.iver.cit.gvsig.fmap.MapContext.draw(MapContext.java:1092)
<br>> > at
<br>> > com.iver.cit.gvsig.fmap.MapControl$PaintingRequest.paint(MapControl.java:1043)
<br>> > at
<br>> > com.iver.cit.gvsig.fmap.MapControl$Drawer2$Worker.run(MapControl.java:1234)
<br>> > at java.lang.Thread.run(Unknown Source)
<br>> >
<br>> > giovanni
<br>> > _______________________________________________
<br>> > Gvsig_internacional mailing list
<br>> > [hidden email]
<br>> > <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_top" rel="nofollow">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>> >
<br>> >
<br>> >
<br>> > _______________________________________________
<br>> > gvSIG_usuarios mailing list
<br>> > [hidden email]
<br>> >
<br>> > Para ver histórico de mensajes, editar sus preferencias de usuario o darse
<br>> > de baja en esta lista, acuda a la siguiente dirección:
<br>> >
<br>> > <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios" target="_top" rel="nofollow">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios</a><br>> >
<br>> >
<br>> --
<br>> View this message in context: <a href="http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4391745.html" target="_top" rel="nofollow">http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4391745.html</a><br>> Sent from the gvSIG usuarios mailing list archive at Nabble.com.
<br>> _______________________________________________
<br>> gvSIG_usuarios mailing list
<br>> [hidden email]
<br>>
<br>> Para ver histórico de mensajes, editar sus preferencias de usuario o darse de baja en esta lista, acuda a la siguiente dirección:
<br>>
<br>> <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios" target="_top" rel="nofollow">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios</a><br>>
<br>>
<br>>
<br>>
<br>> _______________________________________________
<br>> gvSIG_usuarios mailing list
<br>> [hidden email]
<br>>
<br>> Para ver histórico de mensajes, editar sus preferencias de usuario o darse de baja en esta lista, acuda a la siguiente dirección:
<br>>
<br>> <a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios" target="_top" rel="nofollow">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_usuarios</a><br>>
<br>> winmail.dat (13K) Download Attachment
<br>>
<br>> ________________________________
<br>> View message @ <a href="http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4392028.html" target="_top" rel="nofollow">http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4392028.html</a><br>> To unsubscribe from Re: [Gvsig_english] oracle plugin crashes with point layers on oracle10.2, click here.
<br></div>
<br><hr align="left" width="300">
View this message in context: <a href="http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4392097.html">Re: [Gvsig_usuarios] [Gvsig_english] oracle plugin crashes with point layers on oracle10.2</a><br>
Sent from the <a href="http://n2.nabble.com/gvSIG-usuarios-f2000052.html">gvSIG usuarios mailing list archive</a> at Nabble.com.<br>