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: Van Halbert
Fix For: 8.7.1.6_2, 8.11
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}