Why intermittently fuse taking 8+ seconds to get a connection from db ?
Issue
- We are facing issue with pooled connection from datasource. We have been having a lot of lag with getting pooled connections from datasource. Appdynamics shows that its taking 8+ seconds to get a connection from db. This is intermittent in nature. Below is the db connection code we use. Any ideas to fix this :
<service interface="javax.sql.DataSource">
<service-properties>
<entry key="osgi.jndi.service.name" value="jdbc/TestDataSource" />
</service-properties>
<bean class="com.ibm.db2.jcc.DB2DataSource">
<property name="serverName" value="${db.server.host}" />
<property name="portNumber" value="${db.server.port}" />
<property name="databaseName" value="${db.server.dbName}" />
<property name="currentSchema" value="${db.server.schema}" />
<property name="user" value="${db.server.user}" />
<property name="password" value="${db.server.password}" />
<property name="driverType" value="${db.server.drivertype}" />
<property name="dataSourceName" value="${db.server.dataSource.name}" />
</bean>
</service>
Environment
- Red Hat JBoss Fuse
- 6.0.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.