Hi Gabriel,
i was just setting up a new environment. Java 6, tomcat 6.0.18 and geoserver 1.7.0. I also added the necessary ArcSDE client jars for ArcSDE 9.3 - jsde93_sdk.jar and jpe93_sdk.jar. Furthermore i installed the ArcSDE datastore jars gt-arcsde-2.5.1.jar, jsqlparser and commons-pool.jar. But i cannot create an ArcSDE datastore. I get the errormessage: "cannot create a validated object". When looking into the the ArcSDE-log i noticed that the connection from geoserver to SDE was successful. But GS doesn't hold it. The problem is surely not on SDE-side, because with the former 1.7.0-installation the datastore connection succeeded. Can it be something with the new environment (because its the only thing that is different now) - maybe a jar is needed when running java 6 or something like this?
Best regards
Albrecht
Albrecht Weiser,
E6, GIS Center
Hessische Zentrale für Datenverarbeitung (HZD)
Mainzer Straße 29, 65185 Wiesbaden
Tel.: 0611 340-3113
Fax: 0611 340-5113
E-Mail: albrecht.weiser-at-hzd.hessen.de
-----Ursprüngliche Nachricht-----
Von: Gabriel Roldan [mailto:groldan@anonymised.com]
Gesendet: Freitag, 7. November 2008 14:43
An: Weiser, Albrecht (HZD)
Betreff: Re: AW: AW: [Geoserver-users] WMS: cannot change
maxConnectionsOn Friday 07 November 2008 11:31:37 am you wrote:
> OK, i'll do so. The maxConnection was by default at 6, so
it was OK from
> this side, but nevertheless so slow. To exclude some
dependencies, i'll
> setup a totally new environment based on new java, tomcat
and geoserver and
> i'll also put the old tomcat/geoserver out of service and
then do again the
> benchmark. The latter test was quick'n dirty. Now from
scratch. But that
> will take some time. It will be surely next week until i
get back to you.ok, don't worry about that, it's not like I'm super free
neither but this is
something worth digging into.have fun.
Gabriel
> Best wishes
> Albrecht
>
> Albrecht Weiser,
> E6, GIS Center
>
> Hessische Zentrale für Datenverarbeitung (HZD)
> Mainzer Straße 29, 65185 Wiesbaden
> Tel.: 0611 340-3113
> Fax: 0611 340-5113
> E-Mail: albrecht.weiser-at-hzd.hessen.de
>
> > -----Ursprüngliche Nachricht-----
> > Von: Gabriel Roldan [mailto:groldan@anonymised.com]
> > Gesendet: Freitag, 7. November 2008 13:36
> > An: Weiser, Albrecht (HZD)
> > Betreff: Re: AW: [Geoserver-users] WMS: cannot change
maxConnections
> >
> > That's bad news... and in theory it shouldn't be
slower... what about
> > maxConnections? did the problem persist or were you able to
> > increase the
> > number of available connections?
> >
> > please do me a favor, enable the GEOTOOLS_DEVELOPER_LOGGING
> > logging profile an
> > send me back the geoserver.log by private email.
> >
> > Also please tell me about your environment, number and
> > average dataset
> > complexity (shape type, shape complexity, number of shapes),
> > number of
> > layers, sde version, backend RDBMS etc.
> >
> > I'll see if I can set up a comparative benchmark over against
> > the two versions
> > but this things are usually hard to diagnose.. for the test
> > datasets I used
> > (client's data) when developed the improved arcsde extensions
> > it probed to be
> > faster and more reliable... but one never know,
regressions happen.
> >
> > Cheers,
> >
> > Gabriel
> >
> > On Friday 07 November 2008 06:30:59 am you wrote:
> > > Hi Gabriel,
> > > thanks for answering. I installed 1.7.0 (By the way it
> >
> > serves just "?" for
> >
> > > the special german characters - It should better be
compiled with
> > > iso8859-1). When testing with jmeter it was VERY slow!! The
> >
> > average was 22
> >
> > > seconds for all 50 requests while answering times for UMN
> >
> > mapserver and
> >
> > > ArcIMS for the same requests are between 3 to 7 seconds.
> >
> > That's not ok for
> >
> > > a productive environment. I installed the 1.7.0 on the same
> >
> > tomcat where
> >
> > > 1.6.3 is running on. The tomcat is of release 5.5.26 and it
> >
> > uses java 5. I
> >
> > > know, that for geoserver are newer components
recommended, but is it
> > > possible, that 1.7.0 is much slower than 1.6.3 in the same
> >
> > environment?
> >
> > > Best wishes
> > > Albrecht
> > >
> > > Albrecht Weiser,
> > > E6, GIS Center
> > >
> > >
> > >
> > > Hessische Zentrale für Datenverarbeitung (HZD)
> > > Mainzer Straße 29, 65185 Wiesbaden
> > > Tel.: 0611 340-3113
> > > Fax: 0611 340-5113
> > > E-Mail: albrecht.weiser-at-hzd.hessen.de
> > >
> > > > -----Ursprüngliche Nachricht-----
> > > > Von: Gabriel Roldan [mailto:groldan@anonymised.com]
> > > > Gesendet: Donnerstag, 6. November 2008 17:22
> > > > An: geoserver-users@lists.sourceforge.net
> > > > Cc: Weiser, Albrecht (HZD)
> > > > Betreff: Re: [Geoserver-users] WMS: cannot change
maxConnections
> > > >
> > > > Hi albercht,
> > > >
> > > > I notice you're using geoserver 1.6.3. Hence, I suggest you
> > > > to try out with a
> > > > newer version (1.7.0 should work) since the arcsde plugin was
> > > > improved a big
> > > > deal since 1.6.3, and one of the aspects it got better is on
> > > > connection
> > > > handling.
> > > > I'm not sure why exactly you're getting that behaviour in
> > > > 1.6.3, but truth is,
> > > > that's dead code no longer maintained so if you can switch to
> > > > a newer version
> > > > that'd be great.
> > > >
> > > > Waiting for your comments.
> > > >
> > > > Cheers,
> > > >
> > > > Gabriel
> > > >
> > > > On Thursday 06 November 2008 02:04:18 pm
> > > >
> > > > Albrecht.Weiser@anonymised.com wrote:
> > > > > Hi list,
> > > > > i'm doing some stress tests on geoserver with the apache
> > > >
> > > > jmeter tool. I'm
> > > >
> > > > > simulating 5 concurrent users (by 5 threads) each with
> >
> > 10 sequential
> >
> > > > > requests in an interval of 1 second (alltogether 50
> >
> > requests in 10
> >
> > > > > seconds). That shouldn't be too much for geoserver because
> > > >
> > > > it's running on
> > > >
> > > > > a double quad core machine with 16GB RAM and WIN 2003
> > > >
> > > > platform. As Backend
> > > >
> > > > > i am using ArcSDE on Oracle (i'm using geoserver 1.6.3,
> > > >
> > > > tomcat 5.5.26) I
> > > >
> > > > > was just getting a handful of images back from geoserver
> > > >
> > > > with every test
> > > >
> > > > > while the vast majority didn't work . When looking at the
> > > >
> > > > log, i found this
> > > >
> > > > > error: "java.util.NoSuchElementException: Could not aquire
> > > > > feature:org.geotools.data.DataSourceException: The
> >
> > maximun of 2 to
> >
> > > > >
org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde,
> > > > > server=srvumwgeo005.umwelt.hessen.de, port=5151,
instance=null,
> > > > > user=geoview_user, password=*****, minConnections=2,
> > > >
> > > > maxConnections=2,
> > > >
> > > > > connTimeOut=1000] has been reached" Hence i was changing
> > > >
> > > > the datastore
> > > >
> > > > > configuration. Setting up the pool.maxConnections up to 8
> > > >
> > > > and the pool
> > > >
> > > > > timeout up to 8000ms. That showed no success. Still the
> > > >
> > > > same error. Even
> > > >
> > > > > the "maxConnections=2, connTimeOut=1000" was still the same
> > > >
> > > > and didn't
> > > >
> > > > > change (Although the configuration window shows the
> >
> > right values). I
> >
> > > > > restartet tomcat. Still the same error. I restarted the
> >
> > whole server
> >
> > > > > (sometimes its necessary on windows machines). Still the
> > > >
> > > > same. It looks
> > > >
> > > > > like my settings of maxConnections wasn't beeing taken from
> > > >
> > > > geoserver. I
> > > >
> > > > > also stopped some other services to release connections to
> > > >
> > > > ArcSDE and
> > > >
> > > > > increased the maximum numbers of connections of ArcSDE. But
> > > >
> > > > still the same
> > > >
> > > > > with geoserver WMS. It looks like the problem is
> > > >
> > > > geoserver-side. I attached
> > > >
> > > > > a verbose log of the last test to the mail. Hope that
> > > >
> > > > someone knows where
> > > >
> > > > > the problem could be. Thanks
> > > > > Albrecht
> > > > >
> > > > >
> > > > > --
> > > > > Albrecht Weiser,
> > > > > E6, GIS Center
> > > > >
> > > > > Hessische Zentrale für Datenverarbeitung (HZD)
> > > > > Mainzer Straße 29, 65185 Wiesbaden
> > > > > E-Mail: albrecht.weiser-at-hzd.hessen.de