[Gvsig_english] problems retrieving extensive data sets from oracle spatial database

[Francisco José Peñarrubia]

Hi Georg.

The first one seems related to a projection in Oracle database which is 
not in gvSIG's database of known projections:


ERROR AWT-EventQueue-1 es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - Oracle Spatial code not found in table: 31468
ERROR AWT-EventQueue-1 es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - Error with SQL statement. Unknown Oracle code: 31468

Which projection are you using and which is the EPSG equivalent code?

The second error maybe caused by other problem, but perhaps related to it.

Third error seems a bug, or some geometries not supported in gvSIG or in Oracle Driver.

It would be very difficult to fix this errors without testing your data. And maybe it's time to review the Oracle Driver, in order to accelerate it and support better 3D geometries and so on.... but this job would require some time and resources.

Best regards.

Fran.


El 21/03/2013 11:22, georgsedlmeir escribió:
> Dear list members and developers,
> we are currently using gvSIG 1.11.0 final on our department's Linux client
> computers, and we are facing problems retrieving data sets from our
> municipal Oracle Spatial database. Whenever I try to load an extensive set
> from the database, an error message pops up (see attached file
> errorMessage.txt).
> I tried to avoid the problem by setting the spatial boundaries of the
> request to a limited extent, but by doing so another error occurs
> (errorMessage2.txt).
> Strangely enough, when my colleague tries to load the same dataset from the
> database, yet another error occurs instead of the one mentioned first
> (errorMessage3.txt).
> I've also attached the corresponding log files (error1and2.log and
> error3.log).
> Since we are depending on a reliable connection to our database not only for
> small but also for extensive data sets, any help would be much appreciated.
> I've also tried using gvSIG 1.12 but it didn't make any difference. Thank
> you very much.
>
> Best,
> Georg
>
>
> gvSIG_error_1_and_2.log
> <http://osgeo-org.1560.n6.nabble.com/file/n5042016/gvSIG_error_1_and_2.log>
> gvSIG_error_3.log
> <http://osgeo-org.1560.n6.nabble.com/file/n5042016/gvSIG_error_3.log>
> error_message.txt
> <http://osgeo-org.1560.n6.nabble.com/file/n5042016/error_message.txt>
> error_message2.txt
> <http://osgeo-org.1560.n6.nabble.com/file/n5042016/error_message2.txt>
>
>
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/problems-retrieving-extensive-data-sets-from-oracle-spatial-database-tp5042016.html
> Sent from the gvSIG users mailing list archive at Nabble.com.
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
>
> To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
>
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional

-- 
Fran Peñarrubia
Scolab
www.scolab.es

Asociación gvSIG
www.gvsig.com