JDBC Sender Adapter returns not all values of resultset

[SC]

Hi all,

we're migrating from PI 7.0 to PO 7.4

We've imported a Szenario where we poll a JDBC Table from an Oracle view. In 7.0 everything is ok but in PO 7.4 not all values from the resultset are transfered to the XML document.

It seems that alle xsd:string elements where not requested.

Has anyone a tip/Suggestion for us?

Thanks a lot

Christian

[SC · Accepted solution]

Problem solved!

We swapped the ojdbc6.jar from Version 12 to 11.2

[iaki_vila]

HI Christian,

How have you done the uppgrade?, have you reinstall the JDBC drivers?

Regards.

[SC]

Hi Inaki

no. We installed a new PO and do the Phase-out Method. Of course we've deployed the current JDBC Driver for Oracle ojdbc6.jar

In the meantime I did some Research and found out, that the Problem occours with the Oracle datatype VARCHAR2. No Column values of such defined column where returnd in the resultset.

Other columns, e. g. NUMBER are in the resultset.

We are using a Oracle i9 Database with ojdbc6.jar jdbc Driver.

Best regards

Christian