Topic
3 replies Latest Post - ‏2012-03-13T12:41:08Z by andreyn
andreyn
andreyn
3 Posts
ACCEPTED ANSWER

Pinned topic using XML with websphere jdbc adapter 2.6 on 11.2.0.2

‏2012-03-12T11:55:37Z |
Hi,

while upgrading a DB from 10g to 11R2, the developers encountered problems with the websphere adapter for JDBC while using XML.
the adapter is working with the oracle XML libraries such as xmltype_lib and the adapter fails to run the package procedures (specifically xmltype.createxml).
to my understanding, it works with 11R1 (the dev team tested it), and my guess is that the implementation of the xmltype_lib library changed in 11R2.

any idea how to approach this issue? is there any known overall changes to xmltype_lib in 11R2 ? if my assumption is correct there should be no problem fixing this issue by compiling older libraries or some sort of similar approach.
Updated on 2012-03-13T12:41:08Z at 2012-03-13T12:41:08Z by andreyn
  • SystemAdmin
    SystemAdmin
    67 Posts
    ACCEPTED ANSWER

    Re: using XML with websphere jdbc adapter 2.6 on 11.2.0.2

    ‏2012-03-12T16:51:19Z  in response to andreyn
    Hi andreyn,

    Can you pls provide me with some more information on this issue, so that I will be in a better position to suggest you the best possible solution for your problem:

    1. what is the websphere adapter for JDBC version that you are using ?
    2. What are you trying to achieve with the JDBC adapter.
    3. You mentioned about adapter is been used with XML, can you elaborate more on this ? Does the table in the DB contain an XML type column ?
    4. Was the DB2 upgrade, the only change done in the environment keeping all other things the same?

    Thanks,
    Vinod Valecha
    • andreyn
      andreyn
      3 Posts
      ACCEPTED ANSWER

      Re: using XML with websphere jdbc adapter 2.6 on 11.2.0.2

      ‏2012-03-13T11:36:33Z  in response to SystemAdmin
      1. JDBC adapter version 2.6, as stated in the header.
      2. the adapter is trying to run a PLSQL function, which is using the xmltype.createxml function that stored in the DB, and the thing is, when i run it with a debugger the function works as intended and when the adapter is trying to run it, it fails.
      3. its not as if the function selects xml typed fields of a DB table, it fails when using xmltype.createxml function on an xmltype object to format it properly.
      4. its not a DB2 upgrade, its an oracle upgrade, from 10203 to 11202, not DB2. another change that was made was that the db moved from unix to linux but i don't see how it can affect the issue.

      thanks in advance.