[mapserver-users] Re: Problems with MapServer and Oracle Spatial
Hi, Even I am facing similar problems with mapserver 5.6.3 and Oracle Spatial (Native support). I further narrow down this problem. When I execute command resultsGetShape (after queryByRect) my oracle spatial data gets corrupt. To my surprise I see duplicate value in my primary key. Furthermore primary index still points to old data. After further debugging I found that in msOracleSpatialLayerResultGetShape when you try to fetch records using following oci function call, records are updated. TRY( hand, OCIAttrGet( (dvoid *)sthand-stmthp, (ub4)OCI_HTYPE_STMT, (dvoid *)sthand-rows_fetched, (ub4 *)0, (ub4)OCI_ATTR_ROWS_FETCHED, hand-errhp )); There was no error, exception or any debugging info... I was able to replicate this error in 10g and 11g as well. I am clueless now. If anybody else is also facing same problem and have some other way around or any suggestion for debugging further please let us know. Thanks in advance, Sumit. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Problems-with-MapServer-and-Oracle-Spatial-tp5518303p5533884.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Problems with MapServer and Oracle Spatial
Hi, Could you create a ticket and attach a small test case? I'm going to take a look as soon as I can. Thanks, Alan On September 15, 2010 06:40:18 am Sumit Sharma wrote: Hi, Even I am facing similar problems with mapserver 5.6.3 and Oracle Spatial (Native support). I further narrow down this problem. When I execute command resultsGetShape (after queryByRect) my oracle spatial data gets corrupt. To my surprise I see duplicate value in my primary key. Furthermore primary index still points to old data. After further debugging I found that in msOracleSpatialLayerResultGetShape when you try to fetch records using following oci function call, records are updated. TRY( hand, OCIAttrGet( (dvoid *)sthand-stmthp, (ub4)OCI_HTYPE_STMT, (dvoid *)sthand-rows_fetched, (ub4 *)0, (ub4)OCI_ATTR_ROWS_FETCHED, hand-errhp )); There was no error, exception or any debugging info... I was able to replicate this error in 10g and 11g as well. I am clueless now. If anybody else is also facing same problem and have some other way around or any suggestion for debugging further please let us know. Thanks in advance, Sumit. -- Alan Boudreault Mapgears http://www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Problems with MapServer and Oracle Spatial
Thanks for you response. As suggested by you I have created a ticket. Ticket number is 3541. -Sumit -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Problems-with-MapServer-and-Oracle-Spatial-tp5518303p5534732.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users