Parse procedure parameters (in and out) of oracle custom table type into java objects with jdbi annotations
I participate in project, that has java interface, containing methods to query oracle db. Methods are made using annotations like @SqlQuery, @SqlUpdate etc.
I need to call a procedure, that returns (or another procedure that takes as input) a parameter of custom db table type ( TYPE x IS TABLE OF VARCHAR(y) INDEX BY BINARY_INTEGER;).
I cant understand how can I pass this parameters using annotations. All answers that i found use, lets say, imperative way ( how to call procedure with out parameter as table type from a java class ). The key point in these solutions is registerOutParameter(2, Types.ARRAY, typeTableName). But in jdbi, registerOutParameter takes only 2 arguments as input.
Is it even possible to solve my problem using annotations or maybe i need to combine imperative and declarative ways of using jdbi (and if so, please, show me example of how to do it).
java oracle jdbc jdbi
edited Nov 13 at 9:09
Gayan Mettananda
62659
asked Nov 13 at 8:53
Kirill Brusinets
63
add a comment |
I participate in project, that has java interface, containing methods to query oracle db. Methods are made using annotations like @SqlQuery, @SqlUpdate etc.
I need to call a procedure, that returns (or another procedure that takes as input) a parameter of custom db table type ( TYPE x IS TABLE OF VARCHAR(y) INDEX BY BINARY_INTEGER;).
I cant understand how can I pass this parameters using annotations. All answers that i found use, lets say, imperative way ( how to call procedure with out parameter as table type from a java class ). The key point in these solutions is registerOutParameter(2, Types.ARRAY, typeTableName). But in jdbi, registerOutParameter takes only 2 arguments as input.
Is it even possible to solve my problem using annotations or maybe i need to combine imperative and declarative ways of using jdbi (and if so, please, show me example of how to do it).
java oracle jdbc jdbi
edited Nov 13 at 9:09
Gayan Mettananda
62659
asked Nov 13 at 8:53
Kirill Brusinets
63
add a comment |
I participate in project, that has java interface, containing methods to query oracle db. Methods are made using annotations like @SqlQuery, @SqlUpdate etc.
I need to call a procedure, that returns (or another procedure that takes as input) a parameter of custom db table type ( TYPE x IS TABLE OF VARCHAR(y) INDEX BY BINARY_INTEGER;).
I cant understand how can I pass this parameters using annotations. All answers that i found use, lets say, imperative way ( how to call procedure with out parameter as table type from a java class ). The key point in these solutions is registerOutParameter(2, Types.ARRAY, typeTableName). But in jdbi, registerOutParameter takes only 2 arguments as input.
Is it even possible to solve my problem using annotations or maybe i need to combine imperative and declarative ways of using jdbi (and if so, please, show me example of how to do it).
java oracle jdbc jdbi
edited Nov 13 at 9:09
Gayan Mettananda
62659
asked Nov 13 at 8:53
Kirill Brusinets
63
I participate in project, that has java interface, containing methods to query oracle db. Methods are made using annotations like @SqlQuery, @SqlUpdate etc.
I need to call a procedure, that returns (or another procedure that takes as input) a parameter of custom db table type ( TYPE x IS TABLE OF VARCHAR(y) INDEX BY BINARY_INTEGER;).
I cant understand how can I pass this parameters using annotations. All answers that i found use, lets say, imperative way ( how to call procedure with out parameter as table type from a java class ). The key point in these solutions is registerOutParameter(2, Types.ARRAY, typeTableName). But in jdbi, registerOutParameter takes only 2 arguments as input.
Is it even possible to solve my problem using annotations or maybe i need to combine imperative and declarative ways of using jdbi (and if so, please, show me example of how to do it).
java oracle jdbc jdbi
java oracle jdbc jdbi
edited Nov 13 at 9:09
Gayan Mettananda
62659
asked Nov 13 at 8:53
Kirill Brusinets
63
edited Nov 13 at 9:09
Gayan Mettananda
62659
asked Nov 13 at 8:53
Kirill Brusinets
63
edited Nov 13 at 9:09
Gayan Mettananda
62659
edited Nov 13 at 9:09
Gayan Mettananda
62659
edited Nov 13 at 9:09
Gayan Mettananda
62659
62659
asked Nov 13 at 8:53
Kirill Brusinets
63
asked Nov 13 at 8:53
Kirill Brusinets
63
asked Nov 13 at 8:53
Kirill Brusinets
63
63
add a comment |
add a comment |
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%2f53277115%2fparse-procedure-parameters-in-and-out-of-oracle-custom-table-type-into-java-ob%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
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.
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%2f53277115%2fparse-procedure-parameters-in-and-out-of-oracle-custom-table-type-into-java-ob%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
