Hi Wolfgang,
Your explanation seems correct. We don't use the commons-dbcp library on maven side and so we can't specify any sonar.jdbc.validationQuery parameter as this is the case on Sonar web side. But, I'm pretty sure you should be able to setup JDBC Oracle parameter in the jdbc url or through environment variables as this is a case with MySQL jdbc driver ?
regards,
Freddy
On Fri, Oct 23, 2009 at 5:59 PM, Wolfgang Engelhaupt
<engelhaupt@...> wrote:
Hello,
I've separate machines for analyzing the projects and for the sonar-instance
itself. Sometimes the connection between these machines seems to be slow
(1MBit/s) and this causes with some bigger projects a SQLException with
Oracle XE: SQL Error 17002 (I/O Exception, Connection reset). The total
execution time was 50 minutes until the error occurs. I think the problem
could be, that the connection was established to the beginning of the
analyze but never used. After some time the jdbc driver closes the
connection. Is it possible to configure the timeout via a
sonar.jdbc...-property?
Thanks,
Wolfgang
--
View this message in context: http://www.nabble.com/Configurable-timeout-for-JDBC-Connection--tp26029001p26029001.html
Sent from the Sonar user mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
