-
15. Re: Database connection gets closed?
andreas_w May 26, 2015 2:22 AM (in response to andreas_w)I enabled the tracer on our server. Now I have a logfile which I can analyize with the tracer-report but I am getting the following exception:
java.lang.NullPointerException at org.jboss.jca.as.tracer.HTMLReport.generatePoolIndexHTML(HTMLReport.java:321) at org.jboss.jca.as.tracer.HTMLReport.main(HTMLReport.java:1748)
Maybe the problem is that in the logfile there is no "clean" shutdown of the server because I had to kill the process (with -9) to stop it? Do you have any ideas what I could do?
-
16. Re: Database connection gets closed?
jesper.pedersen May 26, 2015 8:15 AM (in response to andreas_w)Yeah, you can do it like that -- or directly on the MySQL class that implements the close() method
-
17. Re: Database connection gets closed?
jesper.pedersen May 26, 2015 8:19 AM (in response to andreas_w)Check if you have the "IJTRACER" TRACE log entries in your server.log file. If you do, then feel free to send an email to me with the download link.
I'll look at the NPE - which shouldn't happen no matter what.
-
18. Re: Database connection gets closed?
andreas_w May 27, 2015 6:27 AM (in response to jesper.pedersen)I checked the log-file. The "IJTRACER"-Statements are there. Thanks for your offer to check our logfile. Can I send you the link via email or somehow like this? The logfile shouldn't be public available. So I would be happy if you wouldn't share it with other people.
-
19. Re: Database connection gets closed?
jesper.pedersen May 27, 2015 7:16 AM (in response to andreas_w)Yes, send me the download link through email, and the file won't be shared. Check ironjacamar.org for details
-
20. Re: Database connection gets closed?
andreas_w May 27, 2015 8:17 AM (in response to jesper.pedersen)okay, thanks. Already sent you an email.
-
21. Re: Database connection gets closed?
jesper.pedersen May 28, 2015 9:56 AM (in response to andreas_w)The initial tracer improvements for this have been merged into 1.2
-
22. Re: Database connection gets closed?
jesper.pedersen Jun 1, 2015 2:22 PM (in response to jesper.pedersen)I have added a "Transaction" report, which shows how JCA resources are used within a transaction, and any resource adapter exception (such as SQLException) is now recorded and shown when the connection listener is returned for easier debugging.