ok, are you using gvSIG 1.9 ? 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: [email protected] en nombre de giohappy Enviado el: jue 14/01/2010 12:58 Para: [email protected] Asunto: Re: [Gvsig_usuarios] [Gvsig_english] oracle plugin crashes with point layers on oracle10.2 > 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/> <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: Re: [Gvsig_usuarios] [Gvsig_english] oracle plugin crashes with point layers on oracle10.2 <http://n2.nabble.com/oracle-plugin-crashes-with-point-layers-on-oracle-10-2-tp4352187p4392097.html> Sent from the gvSIG usuarios mailing list archive <http://n2.nabble.com/gvSIG-usuarios-f2000052.html> at Nabble.com.
_______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
