[prev in list] [next in list] [prev in thread] [next in thread] 

List:       esb-java-dev
Subject:    Re: [Dev] Log sql
From:       Rajith Vitharana <rajithv () wso2 ! com>
Date:       2016-12-28 16:52:56
Message-ID: CAFoNQBJWBO1dhKd90fg9keB1GnKmFiNLYXgmq8Ks4DdoM19kpw () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi,

Can you try driver level login? for example you can enable logs from mysql
jdbc driver. For that you can specify the url as in [1](more details are in
[3] and [4]). For Oracle you can follow the link [2](see the section with
"Enabling and Using JDBC Logging")

[1]
- jdbc:mysql://host/db?logger=com.mysql.jdbc.log.Slf4JLogger&profileSQL=true
[2] - http://docs.oracle.com/cd/B28359_01/java.111/b31224/diagnose.htm
[3] -
https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html
[4] -
http://stackoverflow.com/questions/10903206/enabling-mysql-general-query-log-with-jdbc

Thanks,


On 28 December 2016 at 09:50, Koné Alioune Badara <
kone_a@etna-alternance.net> wrote:

> Hi,
>
> How can I display the Sql requests in the logs of wso2 idendity server?
>
> Regards,
>
> Alioune B KONÉ.
>
> _______________________________________________
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Rajith Vitharana

Senior Software Engineer,
WSO2 Inc. : wso2.com
Mobile : +94715883223
Blog : http://lankavitharana.blogspot.com/
<http://wso2.com/signature>

[Attachment #5 (text/html)]

<div dir="ltr">Hi,<div><br></div><div>Can you try driver level login? for example you \
can enable logs from mysql jdbc driver. For that you can specify the url as in \
[1](more details are in [3] and [4]). For Oracle you can follow the link [2](see the \
section with &quot;Enabling and Using JDBC Logging&quot;)  \
</div><div><br></div><div>[1] -  \
jdbc:mysql://host/db?logger=com.mysql.jdbc.log.Slf4JLogger&amp;profileSQL=true</div><div>[2] \
-  <a href="http://docs.oracle.com/cd/B28359_01/java.111/b31224/diagnose.htm">http://docs.oracle.com/cd/B28359_01/java.111/b31224/diagnose.htm</a></div><div>[3] \
-  <a href="https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configu \
ration-properties.html">https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html</a></div><div>[4] \
-  <a href="http://stackoverflow.com/questions/10903206/enabling-mysql-general-query-l \
og-with-jdbc">http://stackoverflow.com/questions/10903206/enabling-mysql-general-query \
-log-with-jdbc</a></div><div><br></div><div>Thanks,</div><div><br></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On 28 December 2016 at 09:50, Koné \
Alioune Badara <span dir="ltr">&lt;<a href="mailto:kone_a@etna-alternance.net" \
target="_blank">kone_a@etna-alternance.net</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>How can I display the \
Sql requests in the logs of wso2 idendity \
server?</div><div><br></div><div>Regards,<br clear="all"><div><br></div><div \
class="m_2384366786044783840gmail_signature" data-smartmail="gmail_signature"><div \
dir="ltr"><div>Alioune B KONÉ.</div></div></div> </div></div>
<br>______________________________<wbr>_________________<br>
Dev mailing list<br>
<a href="mailto:Dev@wso2.org">Dev@wso2.org</a><br>
<a href="http://wso2.org/cgi-bin/mailman/listinfo/dev" rel="noreferrer" \
target="_blank">http://wso2.org/cgi-bin/<wbr>mailman/listinfo/dev</a><br> \
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div \
class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div \
dir="ltr"><div><span style="color:rgb(34,34,34)">Rajith Vitharana</span><br \
style="color:rgb(34,34,34)"><br style="color:rgb(34,34,34)"><span \
style="color:rgb(34,34,34)">Senior Software Engineer,</span><br \
style="color:rgb(34,34,34)"><span style="color:rgb(34,34,34)">WSO2 Inc. :  </span><a \
href="http://wso2.com/" style="color:rgb(136,136,136)" \
target="_blank">wso2.com</a><br style="color:rgb(34,34,34)"><span \
style="color:rgb(34,34,34)">Mobile :  </span><a title="Call Now" \
style="color:rgb(136,136,136)">+94715883223</a><br></div><div \
style="color:rgb(136,136,136)"><span style="color:rgb(34,34,34)">Blog :  </span><a \
href="http://lankavitharana.blogspot.com/" \
target="_blank">http://lankavitharana.blogspot.com/</a></div><div \
style="color:rgb(136,136,136)"><a href="http://wso2.com/signature" \
target="_blank"><img \
src="http://c.content.wso2.com/signatures/wso2-signature-general.png" \
alt=""></a><br></div></div></div></div></div> </div>



_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev


[prev in list] [next in list] [prev in thread] [next in thread]