I have installed Geoserver 2.7 & connected my Oracle (Locator) database with available 'gt-jdbc-oracle-13.2.jar' extension.

During layer publishing containing fields like 'Geometry', it failed to fetch 'Native & Lat- Long Bounding box' informations.

enter image description here

I have published the same data on Geoserver 2.7 - from Oracle (Locator) using 'Configure new SQL view...' but after data publishing the map rendering time is more than normal (my Lan speeed is 1.0 Gbps).

However, my previous instance of Geoserver 2.5 - Oracle (Locator) combination does the above mentioned task nicely & is perfect for my Web based Map. (Refer to the image below)

enter image description here

Kindly advice on how to publish data with geometry from Oracle (locator) database from Geoserver 2.7 environment...!

  • First trial is to write the Lat/Lon Bounding Box manually by using the same extents than you have in 2.5. Does WMS work now? Is it slow? Slowness may mean that spatial index can't be accessed for some reason, that could also explain why native bounds are not found. To be sure, you use the same database and table for 2.5 and 2.7, and with same user name?
    – user30184
    Sep 11, 2015 at 11:19
  • Yes, same database and table used for both cases and that table is spatially indexed manually... Sep 11, 2015 at 11:23
  • I encountered the same problem after GeoServer was updated from 2.5. to 2.7.5. Trying to view a layer in GML led to the following error message: <ServiceExceptionReport xmlns="opengis.net/ogc" xmlns:xsi="w3.org/2001/XMLSchema-instance" version="1.2.0" xsi:schemaLocation="opengis.net/ogc schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd"> <ServiceException> error:java.lang.RuntimeException: java.io.IOException java.lang.RuntimeException: java.io.IOException java.io.IOExceptionjava.sql.SQLException: ORA-00936: Missing expression ORA-00936: Missing expression
    – Jasmin
    Jan 25, 2016 at 15:49


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.