There are two ways (due to the legacy of Hibernate) to enable SQL logging. The first is to simply enable SQL logging in the Hibernate configuration properties by setting the hibernate.show_sql property to true
Hibernate is a popular Java Object-Relational mapping tool (as if you didn't already know that!) . For debugging purposes you may want to see the actual SQL, including parameter values, that Hibernate sends to the database.
The main objective of the logfile viewer plugin is to have a tail in eclipse that allows to tail multiple files. Also important is the fact that the tailing is also syntax coloring depending on your settings.