Petals BC SQL

No MONIT trace is logged if an error occurs getting a database connection

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.6.2
  • Fix Version/s: 1.6.3
  • Component/s: None
  • Security Level: Public
  • Description:
    Hide

    If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged:

    2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - 	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - 	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - 	...'

    The following MONIT traces are expected:

    1. provideExtFlowStepBegin,
    2. followed by provideExtFlowStepFailure.
    Show
    If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged: 
    2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - 	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - 	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - 	...'
    The following MONIT traces are expected:
    1. provideExtFlowStepBegin,
    2. followed by provideExtFlowStepFailure.
  • Environment:
    -

Activity

Transition Status Change Time Execution Times Last Executer Last Execution Date
New New Open Open
15s
1
Christophe DENEUX
Fri, 17 Mar 2017 - 15:16:51 +0100
Open Open In Progress In Progress
2s
1
Christophe DENEUX
Fri, 17 Mar 2017 - 15:16:53 +0100
In Progress In Progress Resolved Resolved
2h 15m
1
Christophe DENEUX
Fri, 17 Mar 2017 - 17:32:12 +0100

People

Dates

  • Created:
    Fri, 17 Mar 2017 - 15:16:36 +0100
    Updated:
    Fri, 17 Mar 2017 - 17:32:12 +0100
    Resolved:
    Fri, 17 Mar 2017 - 17:32:11 +0100
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Petals ESB. Try JIRA - bug tracking software for your team.