Is the MySQL command $myconnection->disconnect(); required in Perl
Is it required that I call the MySQL command
$myconnection->disconnect(); before exiting my Perl scripts? I've read somewhere that it's not necessary, but I want to be sure.
Thanks
mysql perl
asked Nov 12 at 5:41
Sergio D. Caplan
178110
add a comment |
Is it required that I call the MySQL command
$myconnection->disconnect(); before exiting my Perl scripts? I've read somewhere that it's not necessary, but I want to be sure.
Thanks
mysql perl
asked Nov 12 at 5:41
Sergio D. Caplan
178110
1
Do you mean the DBI method? If so, read the docs: metacpan.org/pod/DBI#disconnect
– Shawn
Nov 12 at 5:59
add a comment |
Is it required that I call the MySQL command
$myconnection->disconnect(); before exiting my Perl scripts? I've read somewhere that it's not necessary, but I want to be sure.
Thanks
mysql perl
asked Nov 12 at 5:41
Sergio D. Caplan
178110
Is it required that I call the MySQL command
$myconnection->disconnect(); before exiting my Perl scripts? I've read somewhere that it's not necessary, but I want to be sure.
Thanks
mysql perl
mysql perl
asked Nov 12 at 5:41
Sergio D. Caplan
178110
asked Nov 12 at 5:41
Sergio D. Caplan
178110
asked Nov 12 at 5:41
Sergio D. Caplan
178110
asked Nov 12 at 5:41
Sergio D. Caplan
178110
asked Nov 12 at 5:41
Sergio D. Caplan
178110
178110
1
Do you mean the DBI method? If so, read the docs: metacpan.org/pod/DBI#disconnect
– Shawn
Nov 12 at 5:59
add a comment |
1
Do you mean the DBI method? If so, read the docs: metacpan.org/pod/DBI#disconnect
– Shawn
Nov 12 at 5:59
1
1
Do you mean the DBI method? If so, read the docs: metacpan.org/pod/DBI#disconnect
– Shawn
Nov 12 at 5:59
Do you mean the DBI method? If so, read the docs: metacpan.org/pod/DBI#disconnect
– Shawn
Nov 12 at 5:59
add a comment |
1 Answer
1
active
oldest
votes
No, that's not required. The connection will close naturally when your script exits.
Generally speaking, $dbh->disconnect() is only required in a few very specific situations. Most of the time, you can rely on the connection being closed when the script exits, or when all copies of the handle have gone out of scope.
answered Nov 12 at 7:21
duskwuff
145k19176229
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%2f53256461%2fis-the-mysql-command-myconnection-disconnect-required-in-perl%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
No, that's not required. The connection will close naturally when your script exits.
Generally speaking, $dbh->disconnect() is only required in a few very specific situations. Most of the time, you can rely on the connection being closed when the script exits, or when all copies of the handle have gone out of scope.
answered Nov 12 at 7:21
duskwuff
145k19176229
add a comment |
No, that's not required. The connection will close naturally when your script exits.
Generally speaking, $dbh->disconnect() is only required in a few very specific situations. Most of the time, you can rely on the connection being closed when the script exits, or when all copies of the handle have gone out of scope.
answered Nov 12 at 7:21
duskwuff
145k19176229
add a comment |
No, that's not required. The connection will close naturally when your script exits.
Generally speaking, $dbh->disconnect() is only required in a few very specific situations. Most of the time, you can rely on the connection being closed when the script exits, or when all copies of the handle have gone out of scope.
answered Nov 12 at 7:21
duskwuff
145k19176229
No, that's not required. The connection will close naturally when your script exits.
Generally speaking, $dbh->disconnect() is only required in a few very specific situations. Most of the time, you can rely on the connection being closed when the script exits, or when all copies of the handle have gone out of scope.
answered Nov 12 at 7:21
duskwuff
145k19176229
answered Nov 12 at 7:21
duskwuff
145k19176229
answered Nov 12 at 7:21
duskwuff
145k19176229
answered Nov 12 at 7:21
duskwuff
145k19176229
145k19176229
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53256461%2fis-the-mysql-command-myconnection-disconnect-required-in-perl%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
1
Do you mean the DBI method? If so, read the docs: metacpan.org/pod/DBI#disconnect
– Shawn
Nov 12 at 5:59