[Geoserver-users] PSC votes are in!

GeoServer GeoServer User
1

Hi everyone,

The results from the Project Steering Committee vote are in and the winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the chair person) to make an odd number so votes on issues can be decided easily, and so there can be a stronger representation from the community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion. Chris Holmes, the chair, has volunteered to do this. Everyone can then comment on the motion, and once it's passed by the initial PSC members we should be a functioning committee.

--
Brent Owens
(The Open Planning Project)

2

Congrats everyone ... now I need to catch up with what is happening with the 1.4.0 train. Almost looks like
the WCS train is going to overtake it.

It is really good to see a wide range of talent and concerns around the table. I am still going to be stuck to an earlier timeslot (either via skype as on the wiki), or a very early IRC time... I do hope this will not be a trouble, and will be back in North America mid september.

Should ask if anyone is doing a "demofest" for GeoServer during FOSS4G? Due to happenstance we may be able to add such things a bit after the fact if there is sufficient interest.

Jody

Hi everyone,

The results from the Project Steering Committee vote are in and the winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the chair person) to make an odd number so votes on issues can be decided easily, and so there can be a stronger representation from the community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion. Chris Holmes, the chair, has volunteered to do this. Everyone can then comment on the motion, and once it's passed by the initial PSC members we should be a functioning committee.

3

Jody Garnett wrote:

Congrats everyone ... now I need to catch up with what is happening with the 1.4.0 train. Almost looks like
the WCS train is going to overtake it.

Do you mean you need to catch us up with what is happening with the 1.4.0 train? I thought you were leading this effort? Wasn't there supposed to be a 1.4.0M1 release sometime?

C

It is really good to see a wide range of talent and concerns around the table. I am still going to be stuck to an earlier timeslot (either via skype as on the wiki), or a very early IRC time... I do hope this will not be a trouble, and will be back in North America mid september.

Should ask if anyone is doing a "demofest" for GeoServer during FOSS4G? Due to happenstance we may be able to add such things a bit after the fact if there is sufficient interest.

Jody

Hi everyone,

The results from the Project Steering Committee vote are in and the winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the chair person) to make an odd number so votes on issues can be decided easily, and so there can be a stronger representation from the community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion. Chris Holmes, the chair, has volunteered to do this. Everyone can then comment on the motion, and once it's passed by the initial PSC members we should be a functioning committee.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

!DSPAM:1003,44c4c78489591804284693!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

4

Chris Holmes wrote:

Jody Garnett wrote:

Congrats everyone ... now I need to catch up with what is happening with the 1.4.0 train. Almost looks like
the WCS train is going to overtake it.

Do you mean you need to catch us up with what is happening with the 1.4.0 train? I thought you were leading this effort? Wasn't there supposed to be a 1.4.0M1 release sometime?

Justin is the man, we just do what he tells us around here.

We had a list of jira items (mostly docs) assigned to us - I have one left to close (writing guidelines written but I want a review).
Cheers,
Jody

5

Hi,

time to catch up - have been lurking and lobbying a bit...

Will be happy to do a Geoserver demo based on the complex-features stuff at FOSS4Geo (assuming a related activity I'm involved in at the time comes off). This may be best done in the light of a discussion about emerging requirements.

The "early" geoserver meeting pretty much tailed off - it wasnt ideal time for me, but marginally workable, though I've been on the road much of the last few months. I've seen fine-tuning about the timing of the remaining meeting. Will the PSC be having separate discussions - that way we can tease out issues with bigger implications in the tech meeting, then maybe put some argued options on the table for consideration?

There is some interest emerging in the WCS as FM view of the world through weather and air traffic domains. I'm trying to get a statement of requirements, but this may provide some useful framework for thinking about the plan.

Cheers
Rob A
Jody Garnett wrote:

Congrats everyone ... now I need to catch up with what is happening with the 1.4.0 train. Almost looks like
the WCS train is going to overtake it.

It is really good to see a wide range of talent and concerns around the table. I am still going to be stuck to an earlier timeslot (either via skype as on the wiki), or a very early IRC time... I do hope this will not be a trouble, and will be back in North America mid september.

Should ask if anyone is doing a "demofest" for GeoServer during FOSS4G? Due to happenstance we may be able to add such things a bit after the fact if there is sufficient interest.

Jody
  

Hi everyone,

The results from the Project Steering Committee vote are in and the winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the chair person) to make an odd number so votes on issues can be decided easily, and so there can be a stronger representation from the community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion. Chris Holmes, the chair, has volunteered to do this. Everyone can then comment on the motion, and once it's passed by the initial PSC members we should be a functioning committee.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
  

6

Hi guys,

thanks to all who voted and congrats to all winners!

I was on holiday this last two days, so almost no chance of showing up. Now
I'm back at home and will make the meeting in 1 hour.

regards,

Gabriel

On Friday 21 July 2006 23:52, Brent Owens wrote:

Hi everyone,

The results from the Project Steering Committee vote are in and the
winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the
chair person) to make an odd number so votes on issues can be decided
easily, and so there can be a stronger representation from the
community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the
candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion.
Chris Holmes, the chair, has volunteered to do this. Everyone can then
comment on the motion, and once it's passed by the initial PSC members
we should be a functioning committee.

--
Gabriel Roldán (groldan@anonymised.com)
Axios Engineering (http://www.axios.es)
Tel. +34 944 41 63 84
Fax. +34 944 41 64 90

7

I didn't have a chance to make the motion formally getting the PSC in motion.

I'm wondering about the meeting times though. I must admit that I don't really like the multiple meeting times. I imagine we should pick the time that the most number of people can make.

Right now we're dominated by euro/africa representation. Then 2 on the west coast, and me on the east coast and RobA in Australia. I'm ok if I'm the one to miss it. But it'd be really nice if we could figure out a way to send automated reminders to the devel list. Another thing that might be nice is to have an agenda in the wiki, we do this for osgeo board, see: http://wiki.osgeo.org/index.php/Fourteenth_Board_Meeting for example. Before the meeting people add agenda items to the wiki, after the meeting someone writes up the minutes. We could just paste in IRC instead of the minutes. That could also be a good forum for those who can't attend the meeting to comment on, just add directly to the wiki.

C

Gabriel Roldán wrote:

Hi guys,

thanks to all who voted and congrats to all winners!

I was on holiday this last two days, so almost no chance of showing up. Now I'm back at home and will make the meeting in 1 hour.

regards,

Gabriel

On Friday 21 July 2006 23:52, Brent Owens wrote:

Hi everyone,

The results from the Project Steering Committee vote are in and the
winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the
chair person) to make an odd number so votes on issues can be decided
easily, and so there can be a stronger representation from the
community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the
candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion.
Chris Holmes, the chair, has volunteered to do this. Everyone can then
comment on the motion, and once it's passed by the initial PSC members
we should be a functioning committee.

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

8

Are meetings still happening on IRC or on Skype?

Thanks,
Alex

On 7/25/06, Chris Holmes <cholmes@...1...> wrote:

I didn't have a chance to make the motion formally getting the PSC in
motion.

I'm wondering about the meeting times though. I must admit that I don't
really like the multiple meeting times. I imagine we should pick the
time that the most number of people can make.

Right now we're dominated by euro/africa representation. Then 2 on the
west coast, and me on the east coast and RobA in Australia. I'm ok if
I'm the one to miss it. But it'd be really nice if we could figure out
a way to send automated reminders to the devel list. Another thing that
might be nice is to have an agenda in the wiki, we do this for osgeo
board, see: http://wiki.osgeo.org/index.php/Fourteenth_Board_Meeting for
example. Before the meeting people add agenda items to the wiki, after
the meeting someone writes up the minutes. We could just paste in IRC
instead of the minutes. That could also be a good forum for those who
can't attend the meeting to comment on, just add directly to the wiki.

C

Gabriel Roldán wrote:
> Hi guys,
>
> thanks to all who voted and congrats to all winners!
>
> I was on holiday this last two days, so almost no chance of showing up. Now
> I'm back at home and will make the meeting in 1 hour.
>
> regards,
>
> Gabriel
>
> On Friday 21 July 2006 23:52, Brent Owens wrote:
>> Hi everyone,
>>
>> The results from the Project Steering Committee vote are in and the
>> winners are:
>> Alessio Fabiani
>> Andrea Aime
>> Gabriel Roldan
>> Jody Garnett
>> Justin Deoliveira
>> Rob Atkinson
>>
>> We decided it makes more sense to have 6 PSC members (plus a 7th, the
>> chair person) to make an odd number so votes on issues can be decided
>> easily, and so there can be a stronger representation from the
>> community. So that means one more person on the PSC.
>>
>> Congratulations to the winners! The votes were really close for the
>> candidates.
>> And thank you to everyone who voted.
>>
>> The next step is to bootstrap the PSC with the first official motion.
>> Chris Holmes, the chair, has volunteered to do this. Everyone can then
>> comment on the motion, and once it's passed by the initial PSC members
>> we should be a functioning committee.
>

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

9

They should be in IRC so everyone can easily attend.
But occasionally people take them to skype.

Brent Owens
(The Open Planning Project)

Alexander Petkov wrote:

Are meetings still happening on IRC or on Skype?

Thanks,
Alex

On 7/25/06, Chris Holmes <cholmes@anonymised.com> wrote:

I didn't have a chance to make the motion formally getting the PSC in
motion.

I'm wondering about the meeting times though. I must admit that I don't
really like the multiple meeting times. I imagine we should pick the
time that the most number of people can make.

Right now we're dominated by euro/africa representation. Then 2 on the
west coast, and me on the east coast and RobA in Australia. I'm ok if
I'm the one to miss it. But it'd be really nice if we could figure out
a way to send automated reminders to the devel list. Another thing that
might be nice is to have an agenda in the wiki, we do this for osgeo
board, see: http://wiki.osgeo.org/index.php/Fourteenth_Board_Meeting for
example. Before the meeting people add agenda items to the wiki, after
the meeting someone writes up the minutes. We could just paste in IRC
instead of the minutes. That could also be a good forum for those who
can't attend the meeting to comment on, just add directly to the wiki.

C

Gabriel Roldán wrote:
> Hi guys,
>
> thanks to all who voted and congrats to all winners!
>
> I was on holiday this last two days, so almost no chance of showing up. Now
> I'm back at home and will make the meeting in 1 hour.
>
> regards,
>
> Gabriel
>
> On Friday 21 July 2006 23:52, Brent Owens wrote:
>> Hi everyone,
>>
>> The results from the Project Steering Committee vote are in and the
>> winners are:
>> Alessio Fabiani
>> Andrea Aime
>> Gabriel Roldan
>> Jody Garnett
>> Justin Deoliveira
>> Rob Atkinson
>>
>> We decided it makes more sense to have 6 PSC members (plus a 7th, the
>> chair person) to make an odd number so votes on issues can be decided
>> easily, and so there can be a stronger representation from the
>> community. So that means one more person on the PSC.
>>
>> Congratulations to the winners! The votes were really close for the
>> candidates.
>> And thank you to everyone who voted.
>>
>> The next step is to bootstrap the PSC with the first official motion.
>> Chris Holmes, the chair, has volunteered to do this. Everyone can then
>> comment on the motion, and once it's passed by the initial PSC members
>> we should be a functioning committee.
>

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

-------------------------------------------------------------------------

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

!DSPAM:1005,44c662a9238051804284693!

10

Alexander Petkov wrote:

Are meetings still happening on IRC or on Skype?
  

Depends on the time, some people can only use skype during their work day, so I start up a skype chat and toll IRC for anyone else who wants to attend.
One advantage is that skype remembers the chat history so those that come late can still read the first part of the meeting.

Cheers,
Jody

Thanks,
Alex

On 7/25/06, Chris Holmes <cholmes@anonymised.com> wrote:
  

I didn't have a chance to make the motion formally getting the PSC in
motion.

I'm wondering about the meeting times though. I must admit that I don't
really like the multiple meeting times. I imagine we should pick the
time that the most number of people can make.

Right now we're dominated by euro/africa representation. Then 2 on the
west coast, and me on the east coast and RobA in Australia. I'm ok if
I'm the one to miss it. But it'd be really nice if we could figure out
a way to send automated reminders to the devel list. Another thing that
might be nice is to have an agenda in the wiki, we do this for osgeo
board, see: http://wiki.osgeo.org/index.php/Fourteenth_Board_Meeting for
example. Before the meeting people add agenda items to the wiki, after
the meeting someone writes up the minutes. We could just paste in IRC
instead of the minutes. That could also be a good forum for those who
can't attend the meeting to comment on, just add directly to the wiki.

C

Gabriel Roldán wrote:
    

Hi guys,

thanks to all who voted and congrats to all winners!

I was on holiday this last two days, so almost no chance of showing up. Now
I'm back at home and will make the meeting in 1 hour.

regards,

Gabriel

On Friday 21 July 2006 23:52, Brent Owens wrote:
      

Hi everyone,

The results from the Project Steering Committee vote are in and the
winners are:
Alessio Fabiani
Andrea Aime
Gabriel Roldan
Jody Garnett
Justin Deoliveira
Rob Atkinson

We decided it makes more sense to have 6 PSC members (plus a 7th, the
chair person) to make an odd number so votes on issues can be decided
easily, and so there can be a stronger representation from the
community. So that means one more person on the PSC.

Congratulations to the winners! The votes were really close for the
candidates.
And thank you to everyone who voted.

The next step is to bootstrap the PSC with the first official motion.
Chris Holmes, the chair, has volunteered to do this. Everyone can then
comment on the motion, and once it's passed by the initial PSC members
we should be a functioning committee.
        

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
geoserver-devel List Signup and Options
  

11

Hi there,

i think this bug has been rasied previously relating to svg:
http://jira.codehaus.org/browse/GEOS-439

but i'm mentioning here cause its also killing kml output from oracle
spatial datastore..

my getmap wms url that looks like this:

http://webdev1.ipe.nt.gov.au/geoserver/wms?Service=wms&Version=1.1.0&Req
uest=GetMap&Width=800&Height=800&Srs=EPSG:4326&Bgcolor=0xCEFFFF&Format=a
pplication/vnd.google-earth.kml+XML&Styles=&Transparent=True&Layers=ntli
s:CADASTRE&bbox=130,-20,131,-19

results in the following oracle sql: (i've abreviated attribute/column
names to '*')

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,13
0.0,-19.0,130.0,-20.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW')
= 'TRUE'

(which doesn't work)

but it seems the name of the geometry column is in the wrong place.. it
should be:

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_I
NFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131
.0,-19.0,130.0,-19.0,130.0,-20.0)),'mask=anyinteract querytype=WINDOW')
= 'TRUE'

(which works)

the wfs server is fine for all type os sptail queries, only the wms
seems to have issues.

i'm running geoserver 1.3.2 on windows 2000 on Apache Tomcat/4.1.29 on
JVM 1.4.2_03-b02, connecting to oracle 10g.

i'm guessing that when bug GEOS 439 gets fixed so will this, but i
thought i'd raise it cause its stopping me from using the kml/kmz
feature.

stack trace follows including the error that oracle spits..thanks,

-ivan

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://webdev1.ipe.nt.gov.au:80/geoserver/schemas//wms/1.1.1/WMS_except
ion_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1">
<ServiceException code="">org.geotools.data.DataSourceException: Error
Performing SQL query: SELECT &quot;MI_PRINX&quot;, &quot;LAISKEY&quot;,
&quot;LOCATION&quot;, &quot;LTOCODE&quot;, &quot;PARCEL&quot;,
&quot;PART_PARCEL&quot;, &quot;PARCEL_TYPE&quot;, &quot;AREA_M2&quot;,
&quot;ST_NUMBER&quot;, &quot;ST_PART&quot;, &quot;ST_NAME&quot;,
&quot;ST_TYPE&quot;, &quot;ST_SUBURB&quot;, &quot;SURVEY&quot;,
&quot;TEN_REF_TYPE&quot;, &quot;TEN_REF_NUM&quot;,
&quot;TEN_STATUS&quot;, &quot;TEN_VOL_TYPE&quot;,
&quot;TEN_VOLUME&quot;, &quot;TEN_FOLIO&quot;, &quot;TP_ZONE&quot;,
&quot;GEOMETRY&quot;, &quot;STATUS_CODE&quot;, &quot;PFI&quot;,
&quot;UFI&quot;, &quot;FEAT_NAME&quot;, &quot;OWN_CATEGORY&quot;,
&quot;PROPERTY_NAME&quot; FROM &quot;CADASTRE&quot; WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,13
0.0,-19.0,130.0,-20.0)),&quot;GEOMETRY&quot;,&apos;mask=anyinteract
querytype=WINDOW&apos;) = &apos;TRUE&apos;
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:9
08)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.ja
va:656)
  at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollectio
n.java:78)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.writeLayers(EncodeKML
.java:320)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.encodeKML(EncodeKML.j
ava:130)
  at
org.vfny.geoserver.wms.responses.map.kml.KMLMapProducer.writeTo(KMLMapPr
oducer.java:93)
  at
org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.j
ava:258)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.ja
va:527)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:2
79)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.j
ava:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:1
15)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharac
terEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:213)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:256)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
6)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:171)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
  at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263)
  at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
  at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
  at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
562)
  at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:619)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-13226: interface not supported
without a spatial index
ORA-06512: at &quot;MDSYS.MD&quot;, line 1723
ORA-06512: at &quot;MDSYS.MDERR&quot;, line 8
ORA-06512: at &quot;MDSYS.SDO_3GL&quot;, line 62

  at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
  at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
  at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
  at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatemen
t.java:961)
  at
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java
:463)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1037)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:118
3)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:8
97)
  ... 48 more

</ServiceException> </ServiceExceptionReport>

12

Ok, I just made a go at fixing the bug. ArcSDE actually had a similar problem, but complained a bit more strongly. I attached the new file to: http://jira.codehaus.org/browse/GEOS-439

Please download and let me know if it works, and I'll commit. There's been some annoying weirdness going on in GeoTools with backwards compatibility, but I believe this jar should work fine.

Nils, could you also give this a try for your problem? I think it might fix it for real

best regards,

Chris

Ivan Price wrote:

Hi there,

i think this bug has been rasied previously relating to svg:
http://jira.codehaus.org/browse/GEOS-439

but i'm mentioning here cause its also killing kml output from oracle
spatial datastore..

my getmap wms url that looks like this:

http://webdev1.ipe.nt.gov.au/geoserver/wms?Service=wms&Version=1.1.0&Req
uest=GetMap&Width=800&Height=800&Srs=EPSG:4326&Bgcolor=0xCEFFFF&Format=a
pplication/vnd.google-earth.kml+XML&Styles=&Transparent=True&Layers=ntli
s:CADASTRE&bbox=130,-20,131,-19

results in the following oracle sql: (i've abreviated attribute/column
names to '*')

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,13
0.0,-19.0,130.0,-20.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW')
= 'TRUE'

(which doesn't work)

but it seems the name of the geometry column is in the wrong place.. it
should be:

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_I
NFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131
.0,-19.0,130.0,-19.0,130.0,-20.0)),'mask=anyinteract querytype=WINDOW')
= 'TRUE'

(which works)

the wfs server is fine for all type os sptail queries, only the wms
seems to have issues.

i'm running geoserver 1.3.2 on windows 2000 on Apache Tomcat/4.1.29 on
JVM 1.4.2_03-b02, connecting to oracle 10g.

i'm guessing that when bug GEOS 439 gets fixed so will this, but i
thought i'd raise it cause its stopping me from using the kml/kmz
feature.

stack trace follows including the error that oracle spits..thanks,

-ivan

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://webdev1.ipe.nt.gov.au:80/geoserver/schemas//wms/1.1.1/WMS_except
ion_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1">
<ServiceException code="">org.geotools.data.DataSourceException: Error
Performing SQL query: SELECT &quot;MI_PRINX&quot;, &quot;LAISKEY&quot;,
&quot;LOCATION&quot;, &quot;LTOCODE&quot;, &quot;PARCEL&quot;,
&quot;PART_PARCEL&quot;, &quot;PARCEL_TYPE&quot;, &quot;AREA_M2&quot;,
&quot;ST_NUMBER&quot;, &quot;ST_PART&quot;, &quot;ST_NAME&quot;,
&quot;ST_TYPE&quot;, &quot;ST_SUBURB&quot;, &quot;SURVEY&quot;,
&quot;TEN_REF_TYPE&quot;, &quot;TEN_REF_NUM&quot;,
&quot;TEN_STATUS&quot;, &quot;TEN_VOL_TYPE&quot;,
&quot;TEN_VOLUME&quot;, &quot;TEN_FOLIO&quot;, &quot;TP_ZONE&quot;,
&quot;GEOMETRY&quot;, &quot;STATUS_CODE&quot;, &quot;PFI&quot;,
&quot;UFI&quot;, &quot;FEAT_NAME&quot;, &quot;OWN_CATEGORY&quot;,
&quot;PROPERTY_NAME&quot; FROM &quot;CADASTRE&quot; WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,13
0.0,-19.0,130.0,-20.0)),&quot;GEOMETRY&quot;,&apos;mask=anyinteract
querytype=WINDOW&apos;) = &apos;TRUE&apos; at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:9
08)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.ja
va:656)
  at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollectio
n.java:78)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.writeLayers(EncodeKML
.java:320)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.encodeKML(EncodeKML.j
ava:130)
  at
org.vfny.geoserver.wms.responses.map.kml.KMLMapProducer.writeTo(KMLMapPr
oducer.java:93)
  at
org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse.j
ava:258)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.ja
va:527)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:2
79)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.j
ava:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:1
15)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharac
terEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:213)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:256)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
6)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:171)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
  at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263)
  at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
  at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
  at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
562)
  at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:619)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-13226: interface not supported
without a spatial index
ORA-06512: at &quot;MDSYS.MD&quot;, line 1723
ORA-06512: at &quot;MDSYS.MDERR&quot;, line 8
ORA-06512: at &quot;MDSYS.SDO_3GL&quot;, line 62

  at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
  at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
  at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
  at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatemen
t.java:961)
  at
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java
:463)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1037)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:118
3)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:8
97)
  ... 48 more

</ServiceException> </ServiceExceptionReport>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

!DSPAM:1003,44c4653765631995013331!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

13

Chris,

this has fixed the WMS KML output problem where the sql was mal-formed.
it has also fixed our hundreds of open oracle connections as hoped.

so now i can report my next bug... that KML output only goes to 4
decimal places, and the cadastre looks like its been drawn by a crazy
person.

surely the kml output should output the same number of decimals as set
in the admin tool for GML?

and is it expected that we will be able to configure the KML output
somewhere ?.. i.e. define the html template for the content returned ?
what role will the sld play in this ?

-ivan

-----Original Message-----
From: Chris Holmes [mailto:cholmes@anonymised.com]
Sent: Tuesday, 25 July 2006 1:44 AM
To: Ivan Price
Cc: Geoserver-devel; nkrueger@anonymised.com
Subject: Re: [Geoserver-devel] problem with wms and oracle spatial..

Ok, I just made a go at fixing the bug. ArcSDE actually had a similar
problem, but complained a bit more strongly. I attached the new file
to: http://jira.codehaus.org/browse/GEOS-439

Please download and let me know if it works, and I'll commit. There's
been some annoying weirdness going on in GeoTools with backwards
compatibility, but I believe this jar should work fine.

Nils, could you also give this a try for your problem? I think it might
fix it for real

best regards,

Chris

Ivan Price wrote:

Hi there,

i think this bug has been rasied previously relating to svg:
http://jira.codehaus.org/browse/GEOS-439

but i'm mentioning here cause its also killing kml output from oracle
spatial datastore..

my getmap wms url that looks like this:

http://webdev1.ipe.nt.gov.au/geoserver/wms?Service=wms&Version=1.1.0&R
eq
uest=GetMap&Width=800&Height=800&Srs=EPSG:4326&Bgcolor=0xCEFFFF&Format
=a
pplication/vnd.google-earth.kml+XML&Styles=&Transparent=True&Layers=nt
li
s:CADASTRE&bbox=130,-20,131,-19

results in the following oracle sql: (i've abreviated attribute/column

names to '*')

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,
13 0.0,-19.0,130.0,-20.0)),"GEOMETRY",'mask=anyinteract
querytype=WINDOW') = 'TRUE'

(which doesn't work)

but it seems the name of the geometry column is in the wrong place..
it should be:

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM
_I
NFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,1
31 .0,-19.0,130.0,-19.0,130.0,-20.0)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'

(which works)

the wfs server is fine for all type os sptail queries, only the wms
seems to have issues.

i'm running geoserver 1.3.2 on windows 2000 on Apache Tomcat/4.1.29 on

JVM 1.4.2_03-b02, connecting to oracle 10g.

i'm guessing that when bug GEOS 439 gets fixed so will this, but i
thought i'd raise it cause its stopping me from using the kml/kmz
feature.

stack trace follows including the error that oracle spits..thanks,

-ivan

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://webdev1.ipe.nt.gov.au:80/geoserver/schemas//wms/1.1.1/WMS_exce
pt ion_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1">
<ServiceException code="">org.geotools.data.DataSourceException: Error

Performing SQL query: SELECT &quot;MI_PRINX&quot;,
&quot;LAISKEY&quot;, &quot;LOCATION&quot;, &quot;LTOCODE&quot;,
&quot;PARCEL&quot;, &quot;PART_PARCEL&quot;, &quot;PARCEL_TYPE&quot;,
&quot;AREA_M2&quot;, &quot;ST_NUMBER&quot;, &quot;ST_PART&quot;,
&quot;ST_NAME&quot;, &quot;ST_TYPE&quot;, &quot;ST_SUBURB&quot;,
&quot;SURVEY&quot;, &quot;TEN_REF_TYPE&quot;, &quot;TEN_REF_NUM&quot;,

&quot;TEN_STATUS&quot;, &quot;TEN_VOL_TYPE&quot;,
&quot;TEN_VOLUME&quot;, &quot;TEN_FOLIO&quot;, &quot;TP_ZONE&quot;,
&quot;GEOMETRY&quot;, &quot;STATUS_CODE&quot;, &quot;PFI&quot;,
&quot;UFI&quot;, &quot;FEAT_NAME&quot;, &quot;OWN_CATEGORY&quot;,
&quot;PROPERTY_NAME&quot; FROM &quot;CADASTRE&quot; WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,
13 0.0,-19.0,130.0,-20.0)),&quot;GEOMETRY&quot;,&apos;mask=anyinteract
querytype=WINDOW&apos;) = &apos;TRUE&apos;
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java
:9
08)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.
ja
va:656)
  at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollect
io
n.java:78)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.writeLayers(EncodeK
ML
.java:320)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.encodeKML(EncodeKML
.j
ava:130)
  at
org.vfny.geoserver.wms.responses.map.kml.KMLMapProducer.writeTo(KMLMap
Pr
oducer.java:93)
  at
org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse
.j
ava:258)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.
ja
va:527)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java
:2
79)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher
.j
ava:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java
:1
15)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
ca
tionFilterChain.java:247)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lt
erChain.java:193)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetChar
ac
terEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
ca
tionFilterChain.java:213)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lt
erChain.java:193)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
lv
e.java:256)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
lv
e.java:191)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2
41
6)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
va
:180)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcher
Va
lve.java:171)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
va
:172)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.

java:174)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at

org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

  at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263)
  at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
  at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
  at

org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:

562)
  at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
ol
.java:619)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-13226: interface not supported
without a spatial index
ORA-06512: at &quot;MDSYS.MD&quot;, line 1723
ORA-06512: at &quot;MDSYS.MDERR&quot;, line 8
ORA-06512: at &quot;MDSYS.SDO_3GL&quot;, line 62

  at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
12
5)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
  at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
  at

oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)

  at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatem
en
t.java:961)
  at
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.ja
va
:463)
  at

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.

java:1037)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1
18
3)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java
:8
97)
  ... 48 more

</ServiceException> </ServiceExceptionReport>

----------------------------------------------------------------------
--- Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share
your opinions on IT & business topics through brief surveys -- and
earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV
DEV _______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

!DSPAM:1003,44c4653765631995013331!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

14

Ivan Price wrote:

Chris,

this has fixed the WMS KML output problem where the sql was mal-formed.
it has also fixed our hundreds of open oracle connections as hoped.

so now i can report my next bug... that KML output only goes to 4
decimal places, and the cadastre looks like its been drawn by a crazy
person.

surely the kml output should output the same number of decimals as set
in the admin tool for GML?

That should be super easy to fix. As long as we can use the same decimal places as we do for GML. Would that be ok? File a bug and I'll get you a fix in a day or two.

and is it expected that we will be able to configure the KML output
somewhere ?.. i.e. define the html template for the content returned ?
what role will the sld play in this ?

I've been thinking about this. I think ideally we'd have an attribute for SLD labels called 'hidden' or some such for things like this. Less than ideally, but should work for now, I think we should just do a vendor param for the label. Ideally I suppose we could maybe reuse it for 'GetFeatureInfo'. This unfortunately is a non-trivial imiprovement. I'd be happy to direct a developer to solve it, or put together an estimate on how long it would take.

best regards,

Chris

-ivan

-----Original Message-----
From: Chris Holmes [mailto:cholmes@anonymised.com] Sent: Tuesday, 25 July 2006 1:44 AM
To: Ivan Price
Cc: Geoserver-devel; nkrueger@anonymised.com
Subject: Re: [Geoserver-devel] problem with wms and oracle spatial..

Ok, I just made a go at fixing the bug. ArcSDE actually had a similar
problem, but complained a bit more strongly. I attached the new file
to: http://jira.codehaus.org/browse/GEOS-439

Please download and let me know if it works, and I'll commit. There's
been some annoying weirdness going on in GeoTools with backwards
compatibility, but I believe this jar should work fine.

Nils, could you also give this a try for your problem? I think it might
fix it for real

best regards,

Chris

Ivan Price wrote:

Hi there,

i think this bug has been rasied previously relating to svg:
http://jira.codehaus.org/browse/GEOS-439

but i'm mentioning here cause its also killing kml output from oracle spatial datastore..

my getmap wms url that looks like this:

http://webdev1.ipe.nt.gov.au/geoserver/wms?Service=wms&Version=1.1.0&R
eq uest=GetMap&Width=800&Height=800&Srs=EPSG:4326&Bgcolor=0xCEFFFF&Format
=a pplication/vnd.google-earth.kml+XML&Styles=&Transparent=True&Layers=nt
li
s:CADASTRE&bbox=130,-20,131,-19

results in the following oracle sql: (i've abreviated attribute/column

names to '*')

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,
13 0.0,-19.0,130.0,-20.0)),"GEOMETRY",'mask=anyinteract querytype=WINDOW') = 'TRUE'

(which doesn't work)

but it seems the name of the geometry column is in the wrong place.. it should be:

SELECT * FROM "CADASTRE" WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM
_I
NFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,1
31 .0,-19.0,130.0,-19.0,130.0,-20.0)),'mask=anyinteract querytype=WINDOW') = 'TRUE'

(which works)

the wfs server is fine for all type os sptail queries, only the wms seems to have issues.

i'm running geoserver 1.3.2 on windows 2000 on Apache Tomcat/4.1.29 on

JVM 1.4.2_03-b02, connecting to oracle 10g.

i'm guessing that when bug GEOS 439 gets fixed so will this, but i thought i'd raise it cause its stopping me from using the kml/kmz feature.

stack trace follows including the error that oracle spits..thanks,

-ivan

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE ServiceExceptionReport SYSTEM "http://webdev1.ipe.nt.gov.au:80/geoserver/schemas//wms/1.1.1/WMS_exce
pt ion_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1"> <ServiceException code="">org.geotools.data.DataSourceException: Error

Performing SQL query: SELECT &quot;MI_PRINX&quot;, &quot;LAISKEY&quot;, &quot;LOCATION&quot;, &quot;LTOCODE&quot;, &quot;PARCEL&quot;, &quot;PART_PARCEL&quot;, &quot;PARCEL_TYPE&quot;, &quot;AREA_M2&quot;, &quot;ST_NUMBER&quot;, &quot;ST_PART&quot;, &quot;ST_NAME&quot;, &quot;ST_TYPE&quot;, &quot;ST_SUBURB&quot;, &quot;SURVEY&quot;, &quot;TEN_REF_TYPE&quot;, &quot;TEN_REF_NUM&quot;,

&quot;TEN_STATUS&quot;, &quot;TEN_VOL_TYPE&quot;, &quot;TEN_VOLUME&quot;, &quot;TEN_FOLIO&quot;, &quot;TP_ZONE&quot;, &quot;GEOMETRY&quot;, &quot;STATUS_CODE&quot;, &quot;PFI&quot;, &quot;UFI&quot;, &quot;FEAT_NAME&quot;, &quot;OWN_CATEGORY&quot;, &quot;PROPERTY_NAME&quot; FROM &quot;CADASTRE&quot; WHERE
SDO_RELATE(MDSYS.SDO_GEOMETRY(2003,8311,NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1
,1003,1),MDSYS.SDO_ORDINATE_ARRAY(130.0,-20.0,131.0,-20.0,131.0,-19.0,
13 0.0,-19.0,130.0,-20.0)),&quot;GEOMETRY&quot;,&apos;mask=anyinteract
querytype=WINDOW&apos;) = &apos;TRUE&apos; at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java
:9
08)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.
ja
va:656)
  at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollect
io
n.java:78)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.writeLayers(EncodeK
ML
.java:320)
  at
org.vfny.geoserver.wms.responses.map.kml.EncodeKML.encodeKML(EncodeKML
.j
ava:130)
  at
org.vfny.geoserver.wms.responses.map.kml.KMLMapProducer.writeTo(KMLMap
Pr
oducer.java:93)
  at
org.vfny.geoserver.wms.responses.GetMapResponse.writeTo(GetMapResponse
.j
ava:258)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.
ja
va:527)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java
:2
79)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher
.j
ava:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java
:1
15)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
ca
tionFilterChain.java:247)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lt
erChain.java:193)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetChar
ac
terEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
ca
tionFilterChain.java:213)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lt
erChain.java:193)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
lv
e.java:256)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
lv
e.java:191)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2
41
6)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
va
:180)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcher
Va
lve.java:171)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
va
:172)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:641)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.

java:174)
  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext
.i
nvokeNext(StandardPipeline.java:643)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:4
80)
  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
  at

org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

  at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263)
  at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
  at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
  at

org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:

562)
  at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
ol
.java:619)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-13226: interface not supported without a spatial index
ORA-06512: at &quot;MDSYS.MD&quot;, line 1723
ORA-06512: at &quot;MDSYS.MDERR&quot;, line 8
ORA-06512: at &quot;MDSYS.SDO_3GL&quot;, line 62

  at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
12
5)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
  at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
  at

oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)

  at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatem
en
t.java:961)
  at
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.ja
va
:463)
  at

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.

java:1037)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1
18
3)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java
:8
97)
  ... 48 more

</ServiceException> </ServiceExceptionReport>

----------------------------------------------------------------------
--- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV
DEV _______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

!DSPAM:1003,44c718cf291791410093335!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org