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.
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
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