Hi Manuel,
Since the connections to the arcsde server are maintained in the pool, and
you say your'e trying against a development server, if that server is being
shutted down from time to time, the pooled connections will become invalid.
(That whats happens to me on my dev environment).
This can be the root of the problem, or not. If you continue experiencing
this problem or any other with the ArcSDEDataStore please let me (us) know.
Feedback and bug reports are allway wellcomed.
I plan to implement some kind of fail tolerance inside the ArcSDE connection
pool, in order to recognize broken connections and attempt to establish a
new one while descarding the broken one.
It's just on my TODO list (wich for arcsde datastore is actually larger that
what I can manage by now), but yes, please send any bug report to this list
or use the issue tracking system
(http://jira.codehaus.org/secure/BrowseProject.jspa?id=10311) to report them
and assign them to me, so I'll don't forgot to check them out. You need to
create an account on that site and log in in order to be able to report
bugs.
Best regards,
Gabriel
-----Mensaje original-----
De: Manuel Mesquita Gomes [mailto:mmgomes@anonymised.com]
Enviado el: martes, 04 de mayo de 2004 15:45
Para: ROLDAN, Gabriel raul
Asunto: RE: [Geoserver-devel] ArcSDE connection drop
Hi, Gabriel,
thanks for the help. I've done what you told, for now.
To answer to your questions, i'm running ArcSDE 8.02 on Windows XP
Professional.
I don't know exactly why it happens. I've tried to make more than one
request at the same time and it worked.
Today, when i arrived at office it was down, before i've done anything.
However, this is a development server, and i'm not the only one using it.
There are other people accessing it through the internet, so i can't be sure
of waht exactly happened. I'll try the 4 connections for now and see how it
works.
Best regards,
Manuel Gomes
-----Original Message-----
From: ROLDAN, Gabriel raul [mailto:gabriel.raul.roldan@anonymised.com]
Sent: terça-feira, 4 de Maio de 2004 11:33
To: 'Manuel Mesquita Gomes'
Subject: RE: [Geoserver-devel] ArcSDE connection drop
Hi,
I'm pretty sure the error you're getting is exactly due to a timeout.
Quick fix: increment the maximun number of connections. You can doit through
the web admin app or manually editting catalog.xml to set <param
name="pool.minConnections" value="4"/> for example
Note in both cases you'll need to restart tomcat. I have setted up a jira
task to allow pool redimensioning without the need to restart de
application, but for now you'll need to.
Now, what I can't guess is the reasson why the only connection you had was
in use. As it was in use, you get that exception after the thread waited for
the pool.timeOut number of milliseconds.
Please tell me if this happens when you were making more than one
simultaneous request. I think not, and it could be a ArcSDEDAtaStore bug, so
pleaso provide as much info as you can.
just curious: what version of ArcSDE ar you using? over what RDBMS and SO?
Did you found a way to reproduce the error or is it completely random?
Best regards,
Gabriel Roldán