Logging spring oracle connection details[Hibernate + Hikari + SpringBoot]

788 Views Asked by At

I am working oracle DB and experiencing unknown Timeout issue when migrated my application from AWS to GCP. I need to have TNS and SpringOra logs so that the cause could be identified.

I am using Logback-spring.xml.

<?xml version="1.0" encoding="UTF-8"?>
<configuration>

    <include resource="com/sabre/ngp/boot/logging/logback/base.xml"/>

    <appender name="SOUT" class="ch.qos.logback.core.ConsoleAppender">

        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
            <Pattern>[%d{dd-MMM-yyyy HH:mm:ss.SSS}] [%logger] [%-5level] - %msg%n</Pattern>
        </encoder>
    </appender>

    <logger name="com.zaxxer.hikari" level="ALL" additivity="false">
        <appender-ref ref="SOUT"/>
    </logger>

    <logger name="org.springframework.orm.jpa" level="ALL" additivity="false">
        <appender-ref ref="SOUT"/>
    </logger>
    
    <logger name="org.hibernate" level="ALL" additivity="false">
        <appender-ref ref="SOUT"/>
    </logger>

</configuration>
0

There are 0 best solutions below