Java Mybatis3 PoolDataSource as Singletone
i made simple program that connect with Postgresql, to select data from database.
i set 5 thread to select database and i use PoolDataSource default setting.
DAO class is singletone, SqlsessionFactory also same, Sqlsession is method scope.
ExecutorService service = Executors.newFixedThreadPool(5);
service.submit(()->{
//select each another table
});
and i saw stacktrace in Jconsole.
one thread approach popConnection method in PoolDataSource, another thread was wait.
and one thread approach query execute method in Postgresql, another thread was wait.
i think that database connection must be synchronized.
but only one thread can approach query execute?
there is no way to execute query same time with another thread?
or this cause is PoolDataSource made as singleton?
Thanks.
java multithreading mybatis java-threads
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
add a comment |
i made simple program that connect with Postgresql, to select data from database.
i set 5 thread to select database and i use PoolDataSource default setting.
DAO class is singletone, SqlsessionFactory also same, Sqlsession is method scope.
ExecutorService service = Executors.newFixedThreadPool(5);
service.submit(()->{
//select each another table
});
and i saw stacktrace in Jconsole.
one thread approach popConnection method in PoolDataSource, another thread was wait.
and one thread approach query execute method in Postgresql, another thread was wait.
i think that database connection must be synchronized.
but only one thread can approach query execute?
there is no way to execute query same time with another thread?
or this cause is PoolDataSource made as singleton?
Thanks.
java multithreading mybatis java-threads
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
Are you positive that threads are waiting for the connection from the pool and not on the response from the DB? Can you share an output of thejstack -p you_process_idwhich shows this?
– Roman Konoval
Nov 16 '18 at 8:33
add a comment |
i made simple program that connect with Postgresql, to select data from database.
i set 5 thread to select database and i use PoolDataSource default setting.
DAO class is singletone, SqlsessionFactory also same, Sqlsession is method scope.
ExecutorService service = Executors.newFixedThreadPool(5);
service.submit(()->{
//select each another table
});
and i saw stacktrace in Jconsole.
one thread approach popConnection method in PoolDataSource, another thread was wait.
and one thread approach query execute method in Postgresql, another thread was wait.
i think that database connection must be synchronized.
but only one thread can approach query execute?
there is no way to execute query same time with another thread?
or this cause is PoolDataSource made as singleton?
Thanks.
java multithreading mybatis java-threads
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
i made simple program that connect with Postgresql, to select data from database.
i set 5 thread to select database and i use PoolDataSource default setting.
DAO class is singletone, SqlsessionFactory also same, Sqlsession is method scope.
ExecutorService service = Executors.newFixedThreadPool(5);
service.submit(()->{
//select each another table
});
and i saw stacktrace in Jconsole.
one thread approach popConnection method in PoolDataSource, another thread was wait.
and one thread approach query execute method in Postgresql, another thread was wait.
i think that database connection must be synchronized.
but only one thread can approach query execute?
there is no way to execute query same time with another thread?
or this cause is PoolDataSource made as singleton?
Thanks.
java multithreading mybatis java-threads
java multithreading mybatis java-threads
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
asked Nov 15 '18 at 1:55
KJ HEYKJ HEY
143
143
Are you positive that threads are waiting for the connection from the pool and not on the response from the DB? Can you share an output of thejstack -p you_process_idwhich shows this?
– Roman Konoval
Nov 16 '18 at 8:33
add a comment |
Are you positive that threads are waiting for the connection from the pool and not on the response from the DB? Can you share an output of thejstack -p you_process_idwhich shows this?
– Roman Konoval
Nov 16 '18 at 8:33
Are you positive that threads are waiting for the connection from the pool and not on the response from the DB? Can you share an output of the
jstack -p you_process_id which shows this?– Roman Konoval
Nov 16 '18 at 8:33
Are you positive that threads are waiting for the connection from the pool and not on the response from the DB? Can you share an output of the
jstack -p you_process_id which shows this?– Roman Konoval
Nov 16 '18 at 8:33
add a comment |
0
active
oldest
votes
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%2f53311341%2fjava-mybatis3-pooldatasource-as-singletone%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53311341%2fjava-mybatis3-pooldatasource-as-singletone%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
Are you positive that threads are waiting for the connection from the pool and not on the response from the DB? Can you share an output of the
jstack -p you_process_idwhich shows this?– Roman Konoval
Nov 16 '18 at 8:33