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

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-3524:
------------------------------------

The issue is in how its deployed.   For standalone, need to deploy using the "path" setting.  Example:

/deployment=database-service.jar:add(runtime-name=database-service.jar,content=[{path=bin/scripts/database-service-1.1.0.jar/,archive=false,relative-to=jboss.home.dir}],enabled=true)

But note, this type of deployment doesn't work for domain, it wouldn't work.  Use the existing deployment method.

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