<HTML dir=ltr><HEAD><TITLE>[Gvsig_english] oracle plugin crashes with point layers on oracle10.2</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16945" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText71146 dir=ltr>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Hello, Giovanni.</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>The gtype 1003 is not for points as far as I know. Do you mean 3001?</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>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:</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>SELECT t.<GEOMETRY_COLUMN>.sdo_gtype, t.<GEOMETRY_COLUMN>.sdo_point FROM <TABLE_NAME> t WHERE ROWNUM < 10</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>You have to replace <GEOMETRY_COLUMN> and <TABLE_NAME> with your values. What is the result?</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>How did you create those geometries in the Oracle Database? Did you create them with gvSIG?</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Regards,</DIV>
<DIV dir=ltr><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3></FONT></FONT> </DIV>
<DIV dir=ltr><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature40264 dir=ltr>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de G. Allegri<BR><B>Enviado el:</B> mié 13/01/2010 16:28<BR><B>Para:</B> Users and Developers mailing list; Lista de Usuarios de gvSIG<BR><B>Asunto:</B> [Gvsig_english] oracle plugin crashes with point layers on oracle10.2<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>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 es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialUtils.getFMapGeometrySdoPoint(OracleSpatialUtils.java:2633)<BR> at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialUtils.getFMapGeometryPoint(OracleSpatialUtils.java:2583)<BR> at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getFMapGeometry(OracleSpatialDriver.java:587)<BR> at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getGeometryUsing(OracleSpatialDriver.java:538)<BR> at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialFeatureIterator.next(OracleSpatialFeatureIterator.java:141)<BR> at com.iver.cit.gvsig.fmap.drivers.featureiterators.ReprojectWrapperFeatureIterator.next(ReprojectWrapperFeatureIterator.java:92)<BR> at 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 com.iver.cit.gvsig.fmap.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:209)<BR> at com.iver.cit.gvsig.fmap.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:175)<BR> at com.iver.cit.gvsig.fmap.MapContext.draw(MapContext.java:1092)<BR> at com.iver.cit.gvsig.fmap.MapControl$PaintingRequest.paint(MapControl.java:1043)<BR> at 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>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>