AW: Re: [Geoserver-users] one connecten to ArcSDE with several Layers

Chris_Holmes1 · May 11, 2006, 11:17pm

Hmmmm...

We might have had to disable that? Gabriel, do you remember? Is it still possible to connect to ArcSDE with just one connection?

Gabriel wrote the code originally, so he can probably say better.

Albert wrote:

Hi Chris
Yes, I'm talking about the number of connections that GeoServer makes
with the backend ArcSDE instance. If I set both pool.minConnections and pool.maxConnections to 1 then GeoServer gives me the following error message.
“Exception while getting layers list: No free connection found to query the layers list”

What have I to change to have different layers but only one connection?

Thank You
Albert

Von: Chris Holmes <cholmes@anonymised.com>
An: Brent Owens <brentowens@anonymised.com>
Betreff: Re: [Geoserver-users] one connecten to ArcSDE with several Layers
Datum: Wed, 10 May 2006 11:25:10 -0400

Or are you talking about the number of connections that GeoServer makes with the backend ArcSDE instance? Like you have a limited number of connections, as per ESRI's restrictive licensing?
In that case you can set the params when configuring the ArcSDE datastore. There is pool.minConnections and pool.maxConnections. If you set both of those to 1 then GeoServer should be able to make all its requests sharing the same connection.
best regards,
Chris
Brent Owens wrote:

Hi Albert,

Using what you have in the xml there should work:

<name>sde:city,sde:wood,sde:river</name>

That is what I used on the sigma site. Try removing the spaces if it doesn't work.

Brent Owens
(The Open Planning Project)

Albert wrote:

Hi,
I want to display more than one Layer for example River, City and Wood in the Chart which I can the several Layers on or switch off. At this should one connecten to ArcSDE. What I've to change in the Code what I've one connected and that I can grab for the servel Layers?

  <layerlist>
    <layer queryable="1" hidden="0">
      <server service="OGC:WMS" version="1.1.1" title="local">
        <onlineresource xlink:type="simple" xlink:href="../../wms"/>
      </server>
      <name>sde:city, sde:wood, sde:river</name>
      <title>Everything(City, Wood, River)</title>
       <srs>EPSG:4326</srs>
      <formatlist><format current="1">image/jpeg</format></formatlist>
    </layer>
  </layerlist>

Thanks Albert

Schnell und einfach ohne Anschlusswechsel zur Lycos DSL Flatrate wechseln und 3 Monate kostenlos ab effektiven 5,21 EUR pro Monat im ersten Jahr surfen.
<a

href=http://www.lycos.de/startseite/online/dsl/index.html?prod=DSL&trackingI
D=email_footertxt>http://www.lycos.de/startseite/online/dsl/index.html?prod=
DSL&trackingID=email_footertxt</a>

-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache

Geronimo

<a

href=http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=12164
2>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642</
a>> _______________________________________________

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

--
Chris Holmes
The Open Planning Project
<a href=http://topp.openplans.org>http://topp.openplans.org</a>

Schnell und einfach ohne Anschlusswechsel zur Lycos DSL Flatrate wechseln und 3 Monate kostenlos ab effektiven 5,21 EUR pro Monat im ersten Jahr surfen.
http://www.lycos.de/startseite/online/dsl/index.html?prod=DSL&trackingID=email_footertxt

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

Gabriel_Roldan2 · May 15, 2006, 11:03pm

not yet, sorry.

The improvements leaving in complex-features will make it a lot easier for
removing this limitation once moved to fm.
(once moved to fm because I don't plan to develop on complex-features but to
port it to fm)

Gabriel
On Friday 12 May 2006 01:17, Chris Holmes wrote:

Hmmmm...

We might have had to disable that? Gabriel, do you remember? Is it
still possible to connect to ArcSDE with just one connection?

Gabriel wrote the code originally, so he can probably say better.

Albert wrote:
> Hi Chris
> Yes, I'm talking about the number of connections that GeoServer makes
> with the backend ArcSDE instance. If I set both pool.minConnections and
> pool.maxConnections to 1 then GeoServer gives me the following error
> message. “Exception while getting layers list: No free connection found
> to query the layers list”
>
> What have I to change to have different layers but only one connection?
>
> Thank You
> Albert
>
>>Von: Chris Holmes <cholmes@anonymised.com>
>>An: Brent Owens <brentowens@anonymised.com>
>>Betreff: Re: [Geoserver-users] one connecten to ArcSDE with several
>> Layers Datum: Wed, 10 May 2006 11:25:10 -0400
>>
>>
>>Or are you talking about the number of connections that GeoServer makes
>>with the backend ArcSDE instance? Like you have a limited number of
>>connections, as per ESRI's restrictive licensing?
>>In that case you can set the params when configuring the ArcSDE
>>datastore. There is pool.minConnections and pool.maxConnections. If
>>you set both of those to 1 then GeoServer should be able to make all its
>>requests sharing the same connection.
>>best regards,
>>Chris
>>
>>Brent Owens wrote:
>>>Hi Albert,
>>>
>>>Using what you have in the xml there should work:
>>>
>>><name>sde:city,sde:wood,sde:river</name>
>>>
>>>That is what I used on the sigma site. Try removing the spaces if it
>>>doesn't work.
>>>
>>>Brent Owens
>>>(The Open Planning Project)
>>>
>>>Albert wrote:
>>>>Hi,
>>>>I want to display more than one Layer for example River, City and Wood
>>>>in the Chart which I can the several Layers on or switch off. At this
>>>>should one connecten to ArcSDE. What I've to change in the Code what
>>>>I've one connected and that I can grab for the servel Layers?
>>>>
>>>> <layerlist>
>>>> <layer queryable="1" hidden="0">
>>>> <server service="OGC:WMS" version="1.1.1" title="local">
>>>> <onlineresource xlink:type="simple" xlink:href="../../wms"/>
>>>> </server>
>>>> <name>sde:city, sde:wood, sde:river</name>
>>>> <title>Everything(City, Wood, River)</title>
>>>> <srs>EPSG:4326</srs>
>>>> <formatlist><format current="1">image/jpeg</format></formatlist>
>>>> </layer>
>>>> </layerlist>
>>>>
>>>> Thanks Albert
>>>>
>>>>Schnell und einfach ohne Anschlusswechsel zur Lycos DSL Flatrate
>>>>wechseln und 3 Monate kostenlos ab effektiven 5,21 EUR pro Monat im
>>>>ersten Jahr surfen.
>>>><a
>>
>>href=http://www.lycos.de/startseite/online/dsl/index.html?prod=DSL&tracki
>>ngI
>> D=email_footertxt>http://www.lycos.de/startseite/online/dsl/index.html?p
>>rod= DSL&trackingID=email_footertxt</a>
>>
>>>-------------------------------------------------------
>>>Using Tomcat but need to do more? Need to support web services,
>>> security? Get stuff done quickly with pre-integrated technology to make
>>> your job easier
>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache
>>
>>Geronimo
>>
>>><a
>>
>>href=http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=12
>>164
>> 2>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216
>>42</ a>> _______________________________________________
>>
>>>Geoserver-users mailing list
>>>Geoserver-users@lists.sourceforge.net
>>>https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>--
>>Chris Holmes
>>The Open Planning Project
>><a href=http://topp.openplans.org>http://topp.openplans.org</a>
>
> Schnell und einfach ohne Anschlusswechsel zur Lycos DSL Flatrate wechseln
> und 3 Monate kostenlos ab effektiven 5,21 EUR pro Monat im ersten Jahr
> surfen.
> http://www.lycos.de/startseite/online/dsl/index.html?prod=DSL&trackingID=
>email_footertxt

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