Sonar fails when oracle reboots

[David Mata]

Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings

sonar.jdbc.maxActive:                                      10

sonar.jdbc.maxIdle:                                           3

sonar.jdbc.minIdle:                                            0

sonar.jdbc.maxWait:                                    5000

sonar.jdbc.minEvictableIdleTimeMillis:        180000

sonar.jdbc.timeBetweenEvictionRunsMillis:  30000

Many thanks!!

[Patroklos Papapetrou]

Hi David

I think you are facing the issue discussed here

http://sonar.15.n6.nabble.com/Automatically-recover-from-connection-unavailable-td3183789.html 

and here 

http://sonar.15.n6.nabble.com/Recover-from-lost-Oracle-connection-tt4999150.html#none

and I am afraid that Oracle driver doesn't support auto reconnect but you can vote for the relevant issue

http://jira.codehaus.org/browse/SONAR-3542

Regards

Patroklos

Master Sonar with Sonar in Action book by Manning Publications  

2012/6/25 David Mata <[hidden email]>

Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings

sonar.jdbc.maxActive:                                      10

sonar.jdbc.maxIdle:                                           3

sonar.jdbc.minIdle:                                            0

sonar.jdbc.maxWait:                                    5000

sonar.jdbc.minEvictableIdleTimeMillis:        180000

sonar.jdbc.timeBetweenEvictionRunsMillis:  30000

Many thanks!!

[Andreas Schilling]

hi David!

we experienced the same problem, there was a thread on this mailinglist some weeks ago.
There already is an issue registered here:
http://jira.codehaus.org/browse/SONAR-3542

So, the Sonar-guys will take care of that :-)

Kind regards,

Andreas Schilling
CAE Processes & Data Management
-------------------------------------------------------------------
Dipl. Inf. Andreas Schilling
Senior Software Architect

TWT GmbH
Science & Innovation
Bernhäuser Str. 40 - 42
73765 Neuhausen

Tel: +49 - 7158 - 17 15 - 673
E-Mail: [hidden email]
--------------------------------------------------------------------
www.twt-gmbh.de
--------------------------------------------------------------------
Geschäftsführung: Dimitrios Vartziotis, Joachim Laicher (stv.)
Registergericht: Amtsgericht Stuttgart, HRB Nr. 212778
Umsatzsteuer: ID-Nr.: DE147841145
--------------------------------------------------------------------



Von:        David Mata <[hidden email]>
An:        [hidden email]
Datum:        25.06.2012 14:04
Betreff:        [sonar-user] Sonar fails when oracle reboots

---

Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings
sonar.jdbc.maxActive:                                      10
sonar.jdbc.maxIdle:                                           3
sonar.jdbc.minIdle:                                            0
sonar.jdbc.maxWait:                                    5000
sonar.jdbc.minEvictableIdleTimeMillis:        180000
sonar.jdbc.timeBetweenEvictionRunsMillis:  30000


Many thanks!!

[David Mata]

Thank you all!!

Meanwhile, I'll try a secure Jenkins stop before reboot oracle.

On Mon, Jun 25, 2012 at 2:10 PM, Andreas Schilling <[hidden email]> wrote:

hi David!

we experienced the same problem, there was a thread on this mailinglist some weeks ago.
There already is an issue registered here:
http://jira.codehaus.org/browse/SONAR-3542

So, the Sonar-guys will take care of that :-)

Kind regards,

Andreas Schilling
CAE Processes & Data Management
-------------------------------------------------------------------
Dipl. Inf. Andreas Schilling
Senior Software Architect

TWT GmbH
Science & Innovation
Bernhäuser Str. 40 - 42
73765 Neuhausen

Tel: <a href="tel:%2B49%20-%207158%20-%2017%2015%20-%20673" value="[phone]" target="_blank">+49 - 7158 - 17 15 - 673
E-Mail: [hidden email]
--------------------------------------------------------------------
www.twt-gmbh.de
--------------------------------------------------------------------
Geschäftsführung: Dimitrios Vartziotis, Joachim Laicher (stv.)
Registergericht: Amtsgericht Stuttgart, HRB Nr. 212778
Umsatzsteuer: ID-Nr.: DE147841145
--------------------------------------------------------------------



Von:        David Mata <[hidden email]>
An:        [hidden email]
Datum:        25.06.2012 14:04
Betreff:        [sonar-user] Sonar fails when oracle reboots

---

Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings
sonar.jdbc.maxActive:                                      10
sonar.jdbc.maxIdle:                                           3
sonar.jdbc.minIdle:                                            0
sonar.jdbc.maxWait:                                    5000
sonar.jdbc.minEvictableIdleTimeMillis:        180000
sonar.jdbc.timeBetweenEvictionRunsMillis:  30000


Many thanks!!

--
/******************************************/
DAVID MATA GÓRRIZ
Correos personales:
      [hidden email]
      [hidden email]
-----------------------------