[Geoserver-users] 1.7.2 KML from Oracle datastore and feature not displaying

GeoServer GeoServer User
1

Hi Heather,

(keeping thread on the public mailing list)

Ok, so it seems it is an issue with the new stuff. I am still not sure I 100% understand the problem. Do you think you could do up a couple of screen shots for us? One with the default and one with mode=refresh?

Also feel free to open an issue report on http://jira.codehaus.org/browse/GEOS and attach the screen shots there.

-Justin

Heather A Carter wrote:

Yes that works when I use that method.

Heather A. Carter
Senior Software Engineer
727.768.8582
Heather_A_Carter@anonymised.com

PLEASE NOTE: This e-mail, including any attached files, is confidential, may be legally privileged, and is solely for the intended recipients. If you have received this e-mail in error, please destroy it and notify me immediately by reply e-mail or phone. Any unauthorized use, dissemination, disclosure, copying or printing is strictly prohibited.

*Justin Deoliveira <jdeolive@anonymised.com>*

03/12/2009 02:25 PM

To
  Heather A Carter <Heather_A_Carter@anonymised.com>
cc
  geoserver-users <geoserver-users@lists.sourceforge.net>
Subject
  Re: [Geoserver-users] 1.7.2 KML from Oracle datastore and feature not displaying

Hi Heather,

In 1.7.1 the default way KML is generated was changed. Can you try
generating KML from this link:

http://localhost:8080/geoserver/wms/kml?layers=&lt;FT&gt;&amp;mode=refresh

Which basically generates the pre 1.7.1 method. If that works we can
narrow it down to the new stuff.

-Justin

Heather A Carter wrote:
>
> 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.
>
> Heather
> Heather A. Carter
> Senior Software Engineer
> 727.768.8582
> Heather_A_Carter@anonymised.com
>
> PLEASE NOTE: This e-mail, including any attached files, is confidential,
> may be legally privileged, and is solely for the intended recipients. If
> you have received this e-mail in error, please destroy it and notify me
> immediately by reply e-mail or phone. Any unauthorized use,
> dissemination, disclosure, copying or printing is strictly prohibited.
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

2

Justin Deoliveira ha scritto:

Hi Heather,

(keeping thread on the public mailing list)

Ok, so it seems it is an issue with the new stuff. I am still not sure I 100% understand the problem. Do you think you could do up a couple of screen shots for us? One with the default and one with mode=refresh?

Also feel free to open an issue report on http://jira.codehaus.org/browse/GEOS and attach the screen shots there.

Just trying a wild guess here. May it be that the oracle tables do
not have a primary key, or that they are views?
Regionation does not work in that case.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

3

Actually the table has a primary key and has oracle spatial metadata.
It worked fine on 1.7.0 to generate KML, though I wanted to upgrade because I think there must be connection pooling issues (I kept having to restart geoserver occasionally. I have set "validateConnections" to true on the Oracle Datastore to see if that helps, I never got an answer as to what was the issue there.)

Re:
Just trying a wild guess here. May it be that the oracle tables do
not have a primary key, or that they are views?
Regionation does not work in that case.

Heather A. Carter
Senior Software Engineer
727.768.8582
Heather_A_Carter@anonymised.com

PLEASE NOTE: This e-mail, including any attached files, is confidential, may be legally privileged, and is solely for the intended recipients. If you have received this e-mail in error, please destroy it and notify me immediately by reply e-mail or phone. Any unauthorized use, dissemination, disclosure, copying or printing is strictly prohibited.

4

Heather A Carter ha scritto:

Actually the table has a primary key and has oracle spatial metadata.
It worked fine on 1.7.0 to generate KML, though I wanted to upgrade because I think there must be connection pooling issues (I kept having to restart geoserver occasionally. I have set "validateConnections" to true on the Oracle Datastore to see if that helps, I never got an answer as to what was the issue there.)

validateConnections can be used to deal with connection that get lost
due to the dbms server dropping them (server side timeouts) or network
issues, but not to deal with code not giving connection back to the
server. Usually in that case going to the admin panel and hitting
the "free memory" button a few times gets rid of the lost connections.

That said, it's the first report of lost connection since quite some time, wondering how that is happening. Do you have some sample data
and an idea of the workload for me to try and reproduce?

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

5

Actually it a table with a Oracle Spatial table containing only points and has less than 20 rows in the table.
I’d say less than 10 users deal with this table, not even on a daily basis–its just for a test purpose really.
We do have intermittent network connectivity.

Sample of the kind of data we load into the table:

Name, latitude, longitude, geometry, description
“Hospital A”, 32, 32, (create SDO_GEOMETRY from lat, long), “This is a test”

So the code doesn’t close connections to the dbms?

Andrea Aime aaime@anonymised.com

03/13/2009 11:43 AM

To
Heather A Carter Heather_A_Carter@anonymised.com

cc
“‘geoserver-users@lists.sourceforge.net’” geoserver-users@lists.sourceforge.net, Justin Deoliveira jdeolive@anonymised.com

Subject
Re: [Geoserver-users] 1.7.2 KML from Oracle datastore and feature not displaying

Heather A Carter ha scritto:
>
> Actually the table has a primary key and has oracle spatial metadata.
> It worked fine on 1.7.0 to generate KML, though I wanted to upgrade
> because I think there must be connection pooling issues (I kept having
> to restart geoserver occasionally. I have set "validateConnections" to
> true on the Oracle Datastore to see if that helps, I never got an answer
> as to what was the issue there.)

validateConnections can be used to deal with connection that get lost
due to the dbms server dropping them (server side timeouts) or network
issues, but not to deal with code not giving connection back to the
server. Usually in that case going to the admin panel and hitting
the "free memory" button a few times gets rid of the lost connections.

That said, it's the first report of lost connection since quite some
time, wondering how that is happening. Do you have some sample data
and an idea of the workload for me to try and reproduce?

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.