Skip to content

Instantly share code, notes, and snippets.

@dodgex
Created February 16, 2017 10:10
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dodgex/b863cf5f20575f3e33b3935dcceb81fa to your computer and use it in GitHub Desktop.
Save dodgex/b863cf5f20575f3e33b3935dcceb81fa to your computer and use it in GitHub Desktop.
tiny helper to enable hibernate sql trace logging and resotring previous log level
import org.slf4j.LoggerFactory;
import ch.qos.logback.classic.Level;
import ch.qos.logback.classic.Logger;
public class SqlLog {
private static final Logger LOG =
(Logger) LoggerFactory.getLogger(SqlLog.class);
private static final Logger sql =
(Logger) LoggerFactory.getLogger("org.hibernate.SQL");
private static final Logger binder = (Logger) LoggerFactory
.getLogger("org.hibernate.type.descriptor.sql.BasicBinder");
private static final Level sqlLevel = sql.getLevel();
private static final Level binderLevel = binder.getLevel();
public static void trace() {
sql.setLevel(Level.DEBUG);
binder.setLevel(Level.TRACE);
LOG.debug("SQL Trace enabled");
}
public static void restore() {
sql.setLevel(sqlLevel);
binder.setLevel(binderLevel);
LOG.debug("SQL Trace disabled");
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment