brainstorm: NextReports Server: Connection Logging

Thursday, May 21, 2015

NextReports Server: Connection Logging

Starting from NextReports 8.1 connection creation is written to log for debug purposes. By default all connections are written to connections.log found inside <server_install_folder>/logs folder. Default log level type is INFO

Inside <server_install_folder>/webapps/nextreports-server/WEB-INF/classes/log4j.properties user can change log level from INFO to DEBUG, to see information from the pool when a connection is created/used:

log4j.logger.ro.nextreports.server.util.ConnectionUtil=INFO, CONNECTION_FILE
log4j.additivity.ro.nextreports.server.util.ConnectionUtil=false

Users will be able to see on DEBUG level how many connections are in pool (min and max values), how many connection are active, idle or busy.

In case you experience some connections problems (like timeouts) and you are sure your database is up and running, you should put this log's level on DEBUG and start accumulating data to reproduce the problem again.

No comments:

Post a Comment

About Me

Mihai Dinca-Panaitescu

Working with Java since 1998 with focus on both server back-end and UI.

In the late 90's till 2003 when not so much frameworks were present I was involved in proprietary server implementation (with all the technology from that time like RMI, JDBC, transactions, Servlets, XML, XSL), user interface with SWING and a lot of algorithms for agriculture business.

In middle 2000's I was involved in many custom development projects adding more flavor to my knowledge : JBoss and OC4J servers, J2EE, Hibernate, EHCache, Ant, JUnit, TestNG

From 2008 I was part of NextReports, starting with designer development in SWING. Then NextReports Server came to life and new technologies were adopted : Spring, JPA, JCR, Wicket, jQuery, Jersey, Maven, Ivy, Git, Android.

Since starting of 2014 I developed a HTML5 library called NextCharts which can be found on github.

I’m currently part of the NextReports developing team at Advantage Software Factory, a local leading provider of business software solutions. NextReports is a business reporting suite composed of reports designer, reporting engine and reporting server. Besides this product, ASF also developed a debt collection software and a CRM solution.