HSQLDB - Is it possible to read property values?
0
HSQLDB is highly configurable, allowing to set properties like this:
SET SESSION RESULT MEMORY ROWS <integer>
I would like to know if it is also possible to retrieve the current values.
I don't mind using Java code if this isn't possible via SQL.
java hsqldb rdbms
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
add a comment |
0
HSQLDB is highly configurable, allowing to set properties like this:
SET SESSION RESULT MEMORY ROWS <integer>
I would like to know if it is also possible to retrieve the current values.
I don't mind using Java code if this isn't possible via SQL.
java hsqldb rdbms
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
2
Did you tryINFORMATION_SCHEMA.SYSTEM_PROPERTIES?
– a_horse_with_no_name
Nov 16 '18 at 8:35
I just did and indeed the properties seem to be stored there, if you make the comment an answer I will accept it. However these seem to be session properties and I wonder where should I look for database properties. Continuing with the original example another property of this kind would be the one set withSET DATABASE DEFAULT RESULT MEMORY ROWS <unsigned integer literal>.
– Karl S.
Nov 16 '18 at 9:25
1
Session settings are reported withINFORMATION_SCHEMA.SYSTEM_SESSIONINFObut theRESULT MEMORY ROWSis not reported there. You can write a Java function to get it from the current session and create an SQL function based on it.
– fredt
Nov 16 '18 at 21:47
add a comment |
0
0
0
HSQLDB is highly configurable, allowing to set properties like this:
SET SESSION RESULT MEMORY ROWS <integer>
I would like to know if it is also possible to retrieve the current values.
I don't mind using Java code if this isn't possible via SQL.
java hsqldb rdbms
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
HSQLDB is highly configurable, allowing to set properties like this:
SET SESSION RESULT MEMORY ROWS <integer>
I would like to know if it is also possible to retrieve the current values.
I don't mind using Java code if this isn't possible via SQL.
java hsqldb rdbms
java hsqldb rdbms
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
asked Nov 16 '18 at 8:28
Karl S.Karl S.
746
746
2
Did you tryINFORMATION_SCHEMA.SYSTEM_PROPERTIES?
– a_horse_with_no_name
Nov 16 '18 at 8:35
I just did and indeed the properties seem to be stored there, if you make the comment an answer I will accept it. However these seem to be session properties and I wonder where should I look for database properties. Continuing with the original example another property of this kind would be the one set withSET DATABASE DEFAULT RESULT MEMORY ROWS <unsigned integer literal>.
– Karl S.
Nov 16 '18 at 9:25
1
Session settings are reported withINFORMATION_SCHEMA.SYSTEM_SESSIONINFObut theRESULT MEMORY ROWSis not reported there. You can write a Java function to get it from the current session and create an SQL function based on it.
– fredt
Nov 16 '18 at 21:47
add a comment |
2
Did you tryINFORMATION_SCHEMA.SYSTEM_PROPERTIES?
– a_horse_with_no_name
Nov 16 '18 at 8:35
I just did and indeed the properties seem to be stored there, if you make the comment an answer I will accept it. However these seem to be session properties and I wonder where should I look for database properties. Continuing with the original example another property of this kind would be the one set withSET DATABASE DEFAULT RESULT MEMORY ROWS <unsigned integer literal>.
– Karl S.
Nov 16 '18 at 9:25
1
Session settings are reported withINFORMATION_SCHEMA.SYSTEM_SESSIONINFObut theRESULT MEMORY ROWSis not reported there. You can write a Java function to get it from the current session and create an SQL function based on it.
– fredt
Nov 16 '18 at 21:47
2
2
Did you try
INFORMATION_SCHEMA.SYSTEM_PROPERTIES?– a_horse_with_no_name
Nov 16 '18 at 8:35
Did you try
INFORMATION_SCHEMA.SYSTEM_PROPERTIES?– a_horse_with_no_name
Nov 16 '18 at 8:35
I just did and indeed the properties seem to be stored there, if you make the comment an answer I will accept it. However these seem to be session properties and I wonder where should I look for database properties. Continuing with the original example another property of this kind would be the one set with
SET DATABASE DEFAULT RESULT MEMORY ROWS <unsigned integer literal>.– Karl S.
Nov 16 '18 at 9:25
I just did and indeed the properties seem to be stored there, if you make the comment an answer I will accept it. However these seem to be session properties and I wonder where should I look for database properties. Continuing with the original example another property of this kind would be the one set with
SET DATABASE DEFAULT RESULT MEMORY ROWS <unsigned integer literal>.– Karl S.
Nov 16 '18 at 9:25
1
1
Session settings are reported with
INFORMATION_SCHEMA.SYSTEM_SESSIONINFO but the RESULT MEMORY ROWS is not reported there. You can write a Java function to get it from the current session and create an SQL function based on it.– fredt
Nov 16 '18 at 21:47
Session settings are reported with
INFORMATION_SCHEMA.SYSTEM_SESSIONINFO but the RESULT MEMORY ROWS is not reported there. You can write a Java function to get it from the current session and create an SQL function based on it.– fredt
Nov 16 '18 at 21:47
add a comment |
0
active
oldest
votes
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
);
);
draft saved
draft discarded
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%2f53334023%2fhsqldb-is-it-possible-to-read-property-values%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
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53334023%2fhsqldb-is-it-possible-to-read-property-values%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
2
Did you try
INFORMATION_SCHEMA.SYSTEM_PROPERTIES?– a_horse_with_no_name
Nov 16 '18 at 8:35
I just did and indeed the properties seem to be stored there, if you make the comment an answer I will accept it. However these seem to be session properties and I wonder where should I look for database properties. Continuing with the original example another property of this kind would be the one set with
SET DATABASE DEFAULT RESULT MEMORY ROWS <unsigned integer literal>.– Karl S.
Nov 16 '18 at 9:25
1
Session settings are reported with
INFORMATION_SCHEMA.SYSTEM_SESSIONINFObut theRESULT MEMORY ROWSis not reported there. You can write a Java function to get it from the current session and create an SQL function based on it.– fredt
Nov 16 '18 at 21:47