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

[Jan Stastny (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jan Stastny updated TEIID-3524:
-------------------------------
    Description: 
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:
{code:xml}
<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>
{code}


  was:
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>




> 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:
> {code:xml}
> <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>
> {code}



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