How to handle java call out result set data in Oracle Service Bus 11g?

I have a java call out in a OSB service to run a simple select query from the database.the java code turns this result set into xml format and then returns this xml as string.but when ever i try to use this data in a transformation xquery it only shows the below in the response variable:

<con:java-content ref="jcid:2120886c:168088e4a35:-524c" xmlns:con="http://www.bea.com/wli/sb/context"/> .

what i suspect is that the OSB is unable to handle the xml string.

code to convert result set into a xml string:

private static String toXML(ResultSet rs) throws SQLException {

    ResultSetMetaData rsmd = rs.getMetaData();

    int colCount = rsmd.getColumnCount();

    StringBuffer xml = new StringBuffer();

    xml.append("<ns1:OutputCollection xmlns:ns1="http://xmlns.oracle.com/namespace">");



    while (rs.next()) {

        xml.append("<ns1:Output>");



        for (int i = 1; i <= colCount; i++) {

            String columnName = rsmd.getColumnName(i);

            Object value = rs.getObject(i);

            xml.append("<ns1:" + columnName + ">");



            if (value != null) {

                xml.append(value.toString().trim());

            }

            xml.append("</ns1:" + columnName + ">");

        }

        xml.append("</ns1:Output>");

    }



    xml.append("</ns1:OutputCollection>");





    return xml.toString();



}

edited Jan 2 at 20:56

asked Jan 2 at 20:33

Pallab Mahata

Please add code that transforms ResultSet into XML

– Ivan
Jan 2 at 20:48

edited the question and added the code.

– Pallab Mahata
Jan 2 at 20:56

add a comment |

<con:java-content ref="jcid:2120886c:168088e4a35:-524c" xmlns:con="http://www.bea.com/wli/sb/context"/> .

what i suspect is that the OSB is unable to handle the xml string.

code to convert result set into a xml string:

private static String toXML(ResultSet rs) throws SQLException {

    ResultSetMetaData rsmd = rs.getMetaData();

    int colCount = rsmd.getColumnCount();

    StringBuffer xml = new StringBuffer();

    xml.append("<ns1:OutputCollection xmlns:ns1="http://xmlns.oracle.com/namespace">");



    while (rs.next()) {

        xml.append("<ns1:Output>");



        for (int i = 1; i <= colCount; i++) {

            String columnName = rsmd.getColumnName(i);

            Object value = rs.getObject(i);

            xml.append("<ns1:" + columnName + ">");



            if (value != null) {

                xml.append(value.toString().trim());

            }

            xml.append("</ns1:" + columnName + ">");

        }

        xml.append("</ns1:Output>");

    }



    xml.append("</ns1:OutputCollection>");





    return xml.toString();



}

edited Jan 2 at 20:56

asked Jan 2 at 20:33

Pallab Mahata

Please add code that transforms ResultSet into XML

– Ivan
Jan 2 at 20:48

edited the question and added the code.

– Pallab Mahata
Jan 2 at 20:56

add a comment |

<con:java-content ref="jcid:2120886c:168088e4a35:-524c" xmlns:con="http://www.bea.com/wli/sb/context"/> .

what i suspect is that the OSB is unable to handle the xml string.

code to convert result set into a xml string:

private static String toXML(ResultSet rs) throws SQLException {

    ResultSetMetaData rsmd = rs.getMetaData();

    int colCount = rsmd.getColumnCount();

    StringBuffer xml = new StringBuffer();

    xml.append("<ns1:OutputCollection xmlns:ns1="http://xmlns.oracle.com/namespace">");



    while (rs.next()) {

        xml.append("<ns1:Output>");



        for (int i = 1; i <= colCount; i++) {

            String columnName = rsmd.getColumnName(i);

            Object value = rs.getObject(i);

            xml.append("<ns1:" + columnName + ">");



            if (value != null) {

                xml.append(value.toString().trim());

            }

            xml.append("</ns1:" + columnName + ">");

        }

        xml.append("</ns1:Output>");

    }



    xml.append("</ns1:OutputCollection>");





    return xml.toString();



}

edited Jan 2 at 20:56

asked Jan 2 at 20:33

Pallab Mahata

<con:java-content ref="jcid:2120886c:168088e4a35:-524c" xmlns:con="http://www.bea.com/wli/sb/context"/> .

what i suspect is that the OSB is unable to handle the xml string.

code to convert result set into a xml string:

private static String toXML(ResultSet rs) throws SQLException {

    ResultSetMetaData rsmd = rs.getMetaData();

    int colCount = rsmd.getColumnCount();

    StringBuffer xml = new StringBuffer();

    xml.append("<ns1:OutputCollection xmlns:ns1="http://xmlns.oracle.com/namespace">");



    while (rs.next()) {

        xml.append("<ns1:Output>");



        for (int i = 1; i <= colCount; i++) {

            String columnName = rsmd.getColumnName(i);

            Object value = rs.getObject(i);

            xml.append("<ns1:" + columnName + ">");



            if (value != null) {

                xml.append(value.toString().trim());

            }

            xml.append("</ns1:" + columnName + ">");

        }

        xml.append("</ns1:Output>");

    }



    xml.append("</ns1:OutputCollection>");





    return xml.toString();



}

java oracle xml-parsing weblogic11g osb

edited Jan 2 at 20:56

asked Jan 2 at 20:33

Pallab Mahata

edited Jan 2 at 20:56

asked Jan 2 at 20:33

Pallab Mahata

edited Jan 2 at 20:56

asked Jan 2 at 20:33

Pallab Mahata

asked Jan 2 at 20:33

Pallab Mahata

asked Jan 2 at 20:33

Pallab Mahata

Please add code that transforms ResultSet into XML

– Ivan
Jan 2 at 20:48

edited the question and added the code.

– Pallab Mahata
Jan 2 at 20:56

add a comment |

Please add code that transforms ResultSet into XML

– Ivan
Jan 2 at 20:48

edited the question and added the code.

– Pallab Mahata
Jan 2 at 20:56

Please add code that transforms ResultSet into XML

– Ivan
Jan 2 at 20:48

edited the question and added the code.

– Pallab Mahata
Jan 2 at 20:56

add a comment |

1 Answer
1

active

oldest

votes

See https://docs.oracle.com/cd/E13159_01/osb/docs10gr3/userguide/context.html#wp1106656.

OSB sees the return value as a reference to a java object. It doesn't know what a java string is or how to handle it. You will have to convert it to an XmlObject or let the java callout return an XmlObject.

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

add a comment |

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');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54012792%2fhow-to-handle-java-call-out-result-set-data-in-oracle-service-bus-11g%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

See https://docs.oracle.com/cd/E13159_01/osb/docs10gr3/userguide/context.html#wp1106656.

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

add a comment |

See https://docs.oracle.com/cd/E13159_01/osb/docs10gr3/userguide/context.html#wp1106656.

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

add a comment |

See https://docs.oracle.com/cd/E13159_01/osb/docs10gr3/userguide/context.html#wp1106656.

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

See https://docs.oracle.com/cd/E13159_01/osb/docs10gr3/userguide/context.html#wp1106656.

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

answered Jan 4 at 13:35

Wesley De Keirsmaeker

738527

add a comment |

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');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu