OracleXMLQuery class with DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bea - 27 Aug 2007 11:32 GMT

Hi people,

I have a Java application working with Oracle.
I need it works with DB2 and the problem is that it uses the
OracleXMLQuery class.
This class works OK when it access to tables with TimeStamp, Integer
and String (varchar) columns but when the column is of BLOB type the
OracleXMLQuery constructor doesn't work.

Do you know can I solve the problem?

Thanks,

Reply to this Message

Knut Stolze - 27 Aug 2007 15:16 GMT

> Hi people,
>
[quoted text clipped - 6 lines]
>
> Do you know can I solve the problem?

I guess the reason is that Oracle accesses and handles BLOBs internally
different than DB2. Also, DB2 has native XML support, which may just make
no sense with Oracle's implementation. That's not much surprising.

You will have to use DB2's infrastructure. Maybe some abstraction layer
that provides a consistent interface to your application - over the Oracle
and DB2 classes - would be a good idea.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

bea - 27 Aug 2007 16:43 GMT

> > Hi people,
>
[quoted text clipped - 19 lines]
> DB2 z/OS Utilities Development
> IBM Germany

Thank you very much,

I don?t want to modify the Java application if this is possible.

I'm searching a Java package similar to the XSU of Oracle for DB2 but
I haven't found nothing.

Do you know if it exists anything like that?

Reply to this Message

Harold Lee - 28 Aug 2007 16:36 GMT

> I don?t want to modify the Java application if this is possible.
>
> I'm searching a Java package similar to the XSU of Oracle for DB2 but
> I haven't found nothing.
>
> Do you know if it exists anything like that?

If you don't want to (or can't) modify the Java code that uses the
OracleXMLQuery object, why not replace the implementation? The
interface to OracleXMLQuery seems simple enough, and DB2 has lots of
features that would help you build an XML representation of a
ResultSet or SQL String with ease... The OracleXMLDataSet constructor
is the only thing that might be hard to replace (but maybe you don't
need that).

- Harold

Reply to this Message