• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Kenny M. · Mar 18, 2015 at 11:25 PM ·

Compatibility with H2 Java database

Hi Everyone,

I am trying to determine if dynaTrace is compatible with the H2 Java database.  H2 is a 100% java database typically used for embedded applications.

http://www.h2database.com/html/main.html

The DynaTrace 6.1 Release Notes states that:

generic support is available for any Type4 JDBC driver


Any help appreciated.   Thanks.

Kenny

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

3 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Kenny M. · Mar 20, 2015 at 11:00 AM

Hi,

Just wanted to close the loop on this one.  An additional restart of the base JVM process resolved the issue.  I now have the JDBC calls being instrumented properly including the database and related hotspot dashlets.  Thanks for everyone's assistance.

Kenny

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Andreas G. ♦ · Mar 20, 2015 at 06:15 PM 0
Share

Thanks for letting us know. Hope you get some good data access pattern data now in your purepaths. Keep us posted if you find someting interesting on H2 to share with the community

avatar image

Answer by Andreas G. · Mar 19, 2015 at 12:37 AM

Correct. If it is JDBC then everything shoudl work out-of-the-box,. Can you try the following though. Please try to restart your application and try it once more. Then please verify if every web request is really picked up as a PurePath. If possible execute some of your web requests that you know run a bit longer and also access the database. Once you have that export some of these PurePaths and send them over to me. I have a program called Share your PurePath that includes instructions on how you can share these purepaths with me

Andi

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Andreas G. · Mar 18, 2015 at 11:30 PM

Hi Kenny

If your app uses JDBC to access H2 then you should see all these SQL Statements being executed. If you use a different API to access H2 you can still see the calls to these APIs but will not automatically see them as Database calls. With custom sensors you can however configure dynatrace to capture all details you need, e.g: execute SQL Statements

The best case scenario in your case though is that you use JDBC - then you are all set

Andi

Comment

People who like this

0 Show 2 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Kenny M. · Mar 19, 2015 at 12:04 AM 0
Share

Andreas,

Thanks for the quick response.  The application does use the JDBC API's.  In my agents overview dashlet I am showing the dynaTrace agent is loaded and connected, the license is valid and the "event count" and "class load"  counters appear to have valid numbers in them.  

At this point, I only see a couple of PurePaths in the Transaction Flow screen.  The Database and Database Hotspot dashlets have no information.  I suspect a missing sensor configuration possibly.  From reading your reply it sounds like the JDBC calls should be getting instrumented as part of the auto sensor settings though.

Thanks.

Kenny

avatar image Harald B. Kenny M. · Mar 19, 2015 at 08:33 PM 0
Share

Kenny,

JDBC calls are instrumented by the JDBC sensor. Please be sure that this sensor is placed and active

regards

Harry

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A