<log4j-appender name="DB" class="org.apache.log4j.jdbc.JDBCAppender">
        <error-manager>
            <only-once />
        </error-manager>
        <level name="DEBUG" />
        <properties>
            <property name="URL">jdbc:sqlserver://localhost:1433;databaseName=myDB
            </property>
            <property name="driver">com.microsoft.sqlserver.jdbc.SQLServerDriver
            </property>
            <property name="user">User</property>
            <property name="password">UserPass</property>
            <property name="sql">exec [dbo].[usp_insert_log_table]  'MyTestJBOSS','clientIP','serverIP','%p','%m'</property>
        </properties>
    </log4j-appender>

    <root-logger>
        <!-- Set the root logger priority via a system property, with a default
            value. -->
        <level name="${jboss.server.log.threshold:DEBUG}" />
        <handlers>
            <handler-ref name="CONSOLE" />
            <handler-ref name="FILE" />
            <handler-ref name="DB" />
        </handlers>
    </root-logger>`

<log4j-appender name="DB" class="org.apache.log4j.jdbc.JDBCAppender">
   <param name="URL" value="jdbc:sqlserver://localhost:1433;databaseName=myDB"/>
   <param name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
   <param name="user" value="User"/>
   <param name="password" value="UserPass"/>
   <param name="sql" value="exec [dbo].[usp_insert_log_table] 'MyTestJBOSS','clientIP','serverIP','%p','%m'"/>
</log4j-appender>