AppD Archive

How to show a database on Application Flow Map?

CommunityUser
Splunk Employee
Splunk Employee

We´ve being trying to monitor SQL calls appDynamic Lite. Even tough our aplicaton connects to a Oracle Database,  no database is shown on Application Flow Map,  consequently we cannot view any SQL Calls. Our application runs on JBoss AS 7.1.1 and jdk1.7.0_21 and connects to the database using Hibernate JTA. thanks.

0 Karma

Arun_Dasetty
Super Champion

Hi,

We understood that you have checked under "Overview" section in liteviewer UI , Can you send the screenshots depicting the issue and also send the zipped version logs directory under <AppServerAgentLite_install_dir> ?

Regards,

Arun

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Hi Arun,

Thanks for the reply. Answering to your question: Yes, we have checked under "Overview" section in liteviewer UI but the database connection is not shown. Our application (web Service) persists data both on a LDAP server and on a oracle database via JTA using Hibernate ORM. 

image.jpeg

0 Karma

Arun_Dasetty
Super Champion

Hi,

We see only the following business transactions from BT.log can you whether this APIs are making any Oracle JDBC backend calls from the code in the jvm where lite agent is installed?

================================

[MSC service thread 1-5] 14 Fev 2014 08:48:36,966  INFO - BT [1] Name [contextSourceTarget.afterPropertiesSet] Type [SPRING_BEAN] Custom [false]

br.com.b2br.ldap.connection.security.SSLLdapContextSource.afterPropertiesSet(SSLLdapContextSource.java)

http--127.0.0.1-8080-1] 14 Fev 2014 08:54:03,290  INFO - BT [2] Name [/GidWsNDSOiVende/GidWsNDSOiVende] Type [SERVLET] Custom [false]

org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java)
================================

We could see oracle jdbc interceptors applied fine from BCT.logs,:

============
Applying method interceptor exit.jdbc.PreparedStatementBind at oracle/jdbc/driver/OraclePreparedStatement.setLong ((IJ)V) id:172
Applying method interceptor exit.jdbc.AddBatchInterceptor at oracle/jdbc/driver/OracleStatementWrapper.addBatch ((Ljava/lang/String;)V) id:226
Applying method interceptor exit.jdbc.PreparedStatementBind at oracle/jdbc/driver/OraclePreparedStatementWrapper.setURL ((ILjava/net/URL;)V) id:219
Applying method interceptor exit.jdbc.GetConnection at org/jboss/jca/adapters/jdbc/WrapperDataSource.getConnection ((Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;) id:101
==========

Please be sure that if the oracle exit calls are made from different api that is not part of discovered BTs than we might not see the corresponding flow in overview screen. Keep us posted the requested information.

Regards,

Arun

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...