Mixing
How to log the SQL being run by the node in VaultService?
I would like to see in the log the SQLs that are being run when .queryBy is used. How do I go about adding this into the log4j xml to increase the visibility i.e debug level?
I have the the log below in my xml file.
<Loggers>
<Root level=“info”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Root>
<Logger name=“net.corda” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Logger>
<Logger name=“net.corda.node.services.config.ConfigHelper” level=“warn” additivity=“false”>
<AppenderRef ref=“Console”/>
</Logger>
<Logger name=“org.hibernate.SQL” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
</Logger>
corda
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
add a comment |
I would like to see in the log the SQLs that are being run when .queryBy is used. How do I go about adding this into the log4j xml to increase the visibility i.e debug level?
I have the the log below in my xml file.
<Loggers>
<Root level=“info”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Root>
<Logger name=“net.corda” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Logger>
<Logger name=“net.corda.node.services.config.ConfigHelper” level=“warn” additivity=“false”>
<AppenderRef ref=“Console”/>
</Logger>
<Logger name=“org.hibernate.SQL” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
</Logger>
corda
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
add a comment |
I would like to see in the log the SQLs that are being run when .queryBy is used. How do I go about adding this into the log4j xml to increase the visibility i.e debug level?
I have the the log below in my xml file.
<Loggers>
<Root level=“info”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Root>
<Logger name=“net.corda” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Logger>
<Logger name=“net.corda.node.services.config.ConfigHelper” level=“warn” additivity=“false”>
<AppenderRef ref=“Console”/>
</Logger>
<Logger name=“org.hibernate.SQL” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
</Logger>
corda
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
I would like to see in the log the SQLs that are being run when .queryBy is used. How do I go about adding this into the log4j xml to increase the visibility i.e debug level?
I have the the log below in my xml file.
<Loggers>
<Root level=“info”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Root>
<Logger name=“net.corda” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
<AppenderRef ref=“RollingFile-Appender”/>
</Logger>
<Logger name=“net.corda.node.services.config.ConfigHelper” level=“warn” additivity=“false”>
<AppenderRef ref=“Console”/>
</Logger>
<Logger name=“org.hibernate.SQL” level=“trace” additivity=“false”>
<AppenderRef ref=“Console-Appender”/>
</Logger>
corda
corda
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
edited Nov 21 '18 at 9:48
Adrian
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
asked Nov 21 '18 at 8:46
AdrianAdrian
623111
623111
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
The correct syntax, in either the node's log4j2.xml or log4j2-test.xml (for tests), is to set the level to debug as per:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
<AppenderRef ref="RollingFile-Appender"/>
</Logger>
Please ensure you are modifying the correct log4j2.xml file.
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
add a comment |
If the results your were expecting do not match actual returned query results you can add an entry to your log4j2.xml configuration file to enable display of executed SQL statements:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
</Logger>
You'll need to change it in log4j2-test.xml too if you're running against unit tests.
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408208%2fhow-to-log-the-sql-being-run-by-the-node-in-vaultservice%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The correct syntax, in either the node's log4j2.xml or log4j2-test.xml (for tests), is to set the level to debug as per:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
<AppenderRef ref="RollingFile-Appender"/>
</Logger>
Please ensure you are modifying the correct log4j2.xml file.
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
add a comment |
The correct syntax, in either the node's log4j2.xml or log4j2-test.xml (for tests), is to set the level to debug as per:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
<AppenderRef ref="RollingFile-Appender"/>
</Logger>
Please ensure you are modifying the correct log4j2.xml file.
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
add a comment |
The correct syntax, in either the node's log4j2.xml or log4j2-test.xml (for tests), is to set the level to debug as per:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
<AppenderRef ref="RollingFile-Appender"/>
</Logger>
Please ensure you are modifying the correct log4j2.xml file.
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
The correct syntax, in either the node's log4j2.xml or log4j2-test.xml (for tests), is to set the level to debug as per:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
<AppenderRef ref="RollingFile-Appender"/>
</Logger>
Please ensure you are modifying the correct log4j2.xml file.
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
answered Nov 21 '18 at 10:29
Jose CollJose Coll
33613
33613
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
add a comment |
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
This is correct. See stackoverflow.com/questions/52305928/… for an example of a logging configuration file you can add this block to and instructions on getting your node to pick it up.
– Joel
Nov 21 '18 at 10:36
add a comment |
If the results your were expecting do not match actual returned query results you can add an entry to your log4j2.xml configuration file to enable display of executed SQL statements:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
</Logger>
You'll need to change it in log4j2-test.xml too if you're running against unit tests.
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
add a comment |
If the results your were expecting do not match actual returned query results you can add an entry to your log4j2.xml configuration file to enable display of executed SQL statements:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
</Logger>
You'll need to change it in log4j2-test.xml too if you're running against unit tests.
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
add a comment |
If the results your were expecting do not match actual returned query results you can add an entry to your log4j2.xml configuration file to enable display of executed SQL statements:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
</Logger>
You'll need to change it in log4j2-test.xml too if you're running against unit tests.
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
If the results your were expecting do not match actual returned query results you can add an entry to your log4j2.xml configuration file to enable display of executed SQL statements:
<Logger name="org.hibernate.SQL" level="debug" additivity="false">
<AppenderRef ref="Console-Appender"/>
</Logger>
You'll need to change it in log4j2-test.xml too if you're running against unit tests.
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
edited Nov 21 '18 at 9:41
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
answered Nov 21 '18 at 9:23
Cais ManaiCais Manai
767714
767714
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
add a comment |
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
Added my log xml in the question as example. Its not working still.
– Adrian
Nov 21 '18 at 9:48
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408208%2fhow-to-log-the-sql-being-run-by-the-node-in-vaultservice%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
