Details
-
Bug
-
Resolution: Done
-
Major
-
8.7.1.6_2
-
None
-
None
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:
<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>
