[teiid-issues] [JBoss JIRA] (TEIID-3524) Database Logging not working

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-3524:
----------------------------------

             Summary: Database Logging not working
                 Key: TEIID-3524
                 URL: https://issues.jboss.org/browse/TEIID-3524
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.7.1.6_2
            Reporter: Jan Stastny
            Assignee: Steven Hawkins


When using db logging in Teiid, nothing gets inserted into the db. Logs appear at server.log, but not in the db.
I set up the logging as follows:
Created java:/teiid-log-ds datasource.
Added these to logging subsystem:
<async-handler name="TEIID_COMMAND_LOG">
    <level name="DEBUG"/>
    <queue-length value="50"/>
    <overflow-action value="block"/>
    <subhandlers>
        <handler name="TEIID_JPA_LOG"/>
    </subhandlers>
</async-handler>
<async-handler name="TEIID_AUDIT_LOG">
    <level name="DEBUG"/>
    <queue-length value="50"/>
    <overflow-action value="block"/>
    <subhandlers>
        <handler name="TEIID_JPA_LOG"/>
    </subhandlers>
</async-handler>
<custom-handler name="TEIID_JPA_LOG" class="org.teiid.logger.DatabaseAppender" module="org.jboss.teiid.extensions">
   <level name="DEBUG"/>
</custom-handler>
<logger category="org.teiid.COMMAND_LOG">
   <level name="DEBUG"/>
      <handlers>
          <handler name="TEIID_COMMAND_LOG"/>
      </handlers>
</logger>
<logger category="org.teiid.AUDIT_LOG">
  <level name="DEBUG"/>
  <handlers>
    <handler name="TEIID_AUDIT_LOG"/>
  </handlers>
</logger>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)