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
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
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
Kenny,
JDBC calls are instrumented by the JDBC sensor. Please be sure that this sensor is placed and active
regards
Harry
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
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
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
