How are you checking oracle's connections?
Vince
Sent from my iPad
On Feb 4, 2013, at 8:49 AM,
"[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>> wrote:
Hello Andrea,
the option "validate connections" is already checked.
I am sure the DB does not close connections because I verified that during this
strange behaviour connections still were there.
No automatic process is scheduled on the database to kill sessions after a
certain period of time and no firewall can also do it because the DB and the
Geoserver are on the same subnet.
What can I do or check to avoid this?
Thanks
Mauro
2013/2/4 Andrea Aime
<[email protected]<mailto:[email protected]>>
On Mon, Feb 4, 2013 at 12:45 PM,
[email protected]<mailto:[email protected]>
<[email protected]<mailto:[email protected]>> wrote:
I often encounter the following error during which I cannot use geoserver
anymore.
On the database side, I still can view my connections in INACTIVE status.
After few minutes, Geoserver come back to work correctly.
Your Oracle database is closing connections that GeoSever is trying to pool,
either
because it is set so, or because it has been restarted, or because it is
configured to drop
them after a certain timeout.
The easiest fix is to enable the connection validation in your datastore
configuration panel
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313<tel:%2B39%200584%20962313>
fax: +39 0584 1660272<tel:%2B39%200584%201660272>
mob: +39 339 8844549<tel:%2B39%20%C2%A0339%208844549>
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
--
Mauro Bagazzi
SardegnaIT srl
Viale Trieste 186, Cagliari
Telefono : +39-0706064365
E-mail: <[email protected]<mailto:[email protected]>>
Skype: mauro.bagazzi
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
