there is not needed to use hibernate in every j2ee applications. you can use jdbc simply as defined in the following picture
the code in red color shows how to use log4j for logging sql scripts and the code in brown color shows how to call mssql stored procedures using jdbc.