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

[Kylin Soong (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13079443#comment-13079443 ] 

Kylin Soong commented on TEIID-3524:
------------------------------------

This should work, if no we may need check the server.log check whether JPA insert have exeception throw?

Also for Reporter, can you check whether JPA batch insert be enabled, if so can you dump more log than JPA batch size, then check whether it work?

> 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
>
> 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)