GeoServer

KML output for Oracle DataStore, worked in 1.7.0 not working in 1.7.2 without mode=refresh

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Cannot Reproduce
  • Affects Version/s: 1.7.2
  • Fix Version/s: 1.7.5
  • Component/s: None
  • Labels:
    None
  • Environment:
    Tomcat running geoserver war file. 1.7.2 geoserver with oracle extension (not the next generation extension though).
  • Number of attachments :
    4

Description

I had 1.7.0 and we occassionally have to restart geoserver, after
restarting it it is fine. Stale database connections to Oracle? That
question I haven't gotten an answer for yet.

So in the meantime, I downloaded 1.7.2 and the oracle plugins for this
version (not the next generation I don't know what that is)

The openlayers map preview works but the KML generation generateds
something but the placemarks are not visible for the FEATURE_TYPE that
is hooked to an oracle spatial table with points.
This worked on 1.7.0.

The demos that come with the app work and generate KML fine.

Trying http://localhost:8080/geoserver/wms/kml?layers=<FT>&mode=refresh with my feature type worked...
When using the links without this mode=refresh option the KML output on the navigation area of google earth has "00" and "01" and no placemarks actually show up on the map, a screenshot of the navigation area is shown. When in mode=refresh the placemark titile and lat,long information is in the navigation area as expected and placemarks are on the map.

  1. Text File
    oraclescript.txt
    18/Mar/09 9:01 AM
    2 kB
    Heather Carter
  3. Text File
    tomcatstdout.txt
    16/Mar/09 5:24 AM
    16 kB
    Heather Carter
  1. healthPOI.jpg
    108 kB
    19/Mar/09 5:38 AM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Andrea Aime added a comment - - edited

Heather, I need you to provide me a Oracle SQL script to reproduce this issue, in particular, a sql script that creates the table, inserts the metadata, creates the spatial index and inserts enough rows to demonstrate the problem

Show
Andrea Aime added a comment - - edited Heather, I need you to provide me a Oracle SQL script to reproduce this issue, in particular, a sql script that creates the table, inserts the metadata, creates the spatial index and inserts enough rows to demonstrate the problem
Hide
Permalink
Heather Carter added a comment -

I cut these out of my scripts.

Show
Heather Carter added a comment - I cut these out of my scripts.
Hide
Permalink
Andrea Aime added a comment -

I've just tried it out in my local XE install, using GS 1.7.3 and the OracleNG data store (as I told you before, the Oracle classic is no more maintained, so I did not try it out).
And... it worked (photographic proof attached).
Or else, at first it did not, but it was my fault. At first I chose the "burg" style, which uses a SVG externalgraphic, which is not supported in GE, and so nothing appeared. But when I switched the style to point instead I could see your data just fine.

Show
Andrea Aime added a comment - I've just tried it out in my local XE install, using GS 1.7.3 and the OracleNG data store (as I told you before, the Oracle classic is no more maintained, so I did not try it out). And... it worked (photographic proof attached). Or else, at first it did not, but it was my fault. At first I chose the "burg" style, which uses a SVG externalgraphic, which is not supported in GE, and so nothing appeared. But when I switched the style to point instead I could see your data just fine.
Hide
Permalink
Andrea Aime added a comment -

Oh, btw, I did not have to use mode=refresh, I simply clicked on the kml link in the map preview.

Show
Andrea Aime added a comment - Oh, btw, I did not have to use mode=refresh, I simply clicked on the kml link in the map preview.
Hide
Permalink
Andrea Aime added a comment -

Did you find any solution for this, or figured out why it was not working for you?

Show
Andrea Aime added a comment - Did you find any solution for this, or figured out why it was not working for you?

People

  • Assignee:
    Andrea Aime
    Reporter:
    Heather Carter
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: