Exatamente na raiz do resources
// ch.qos.logback.classic.util.ContextInitializer#CONFIG_FILE_PROPERTY
-Dlogback.configurationFile=logback-prod.xml
compile 'org.slf4j:slf4j-api:1.6.4'
compile group: 'ch.qos.logback', name: 'logback-classic', version: '1.2.3'
//compile 'ch.qos.logback:logback-core:1.2.3'
e seja feliz
Log4j
LogManager.getLogger("org.apache.commons").setLevel(Level.ALL);
org.apache.log4j.LogManager.getLogger("org.apache.commons").setLevel(org.apache.log4j.Level.ALL);
java native logger
java.util.logging.Logger.getLogger("org.hibernate.SQL").setLevel(Level.ALL);
java.util.logging.Logger.getLogger("org.hibernate.type").setLevel(Level.ALL);
slf4j
((ch.qos.logback.classic.Logger)LoggerFactory.getLogger("org.hibernate.type")).setLevel(Level.ALL);
((ch.qos.logback.classic.Logger)LoggerFactory.getLogger("org.hibernate.SQL")).setLevel(Level.ALL);
logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG
level, lo4j, slf4j, logback, loglevel, log level, logback commands, logback bookmarks