OracleXMLQuery class with DB2

bea

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,

Aug 27 '07 #1

Subscribe Reply

1645

Knut Stolze

bea wrote:

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?

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.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Aug 27 '07 #2

bea

On Aug 27, 4:16 pm, Knut Stolze <sto...@de.ibm.comwrote:

bea wrote:
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?

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.

--
Knut Stolze
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?

Aug 27 '07 #3

Harold Lee

On Aug 27, 8:43 am, bea <mbeatrizrodrig...@gmail.comwrote:

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

Aug 28 '07 #4

Similar topics

inner class constructors

by: Murat Tasan | last post by:

hi, i am having a small problem with constructing an inner class. i am using an inner class (and not a static nested class) because the methods of the inner class need access to the enclosing...

Java

Getting the super class via the super() function

by: Fernando Rodriguez | last post by:

Hi, I need to traverse the methods defined in a class and its superclasses. This is the code I'm using: # An instance of class B should be able to check all the methods defined in B #and A,...

Python

Default attribute in base class precludes delegation

by: Gabriel Genellina | last post by:

Hi In the following code sample, I have: - a Worker class, which could have a lot of methods and attributes. In particular, it has a 'bar' attribute. This class can be modified as needed. - a...

Python

Python doesn't know class of function ? : class C:def f():pass;l=[f]; print C.l[0].im_class

by: Robert | last post by:

Python doesn't know the class of a method when container not direct class attribute: >>> class X: .... def f():pass .... g=f .... l= .... >>> X.g <unbound method X.f>

Python

Correct syntax for definitions of inner classes of a template class.

by: Oplec | last post by:

Hi, I'm learning C++ as a hobby using The C++ Programming Language : Special Edition by Bjarne Stroustrup. I'm working on chpater 13 exercises that deal with templates. Exercise 13.9 asks for me...

C / C++

access public function of derived class through base class pointer

by: Banaticus Bart | last post by:

I wrote an abstract base class from which I've derived a few other classes. I'd like to create a base class array where each element is an instance of a derived object. I can create a base class...

C / C++

Page_load not called in base class

by: Andy | last post by:

Hi all, I have a site with the following architecture: Common.Web.dll - Contains a CommonPageBase class which inherits System.Web.UI.Page myadd.dll - Contains PageBase which inherits...

ASP.NET

Old template class works in VC++ Not in C++ Builder 5

by: Hamilton Woods | last post by:

Diehards, I developed a template matrix class back around 1992 using Borland C++ 4.5 (ancestor of C++ Builder) and haven't touched it until a few days ago. I pulled it from the freezer and...

C / C++

module to implement Abstract Base Class

by: emin.shopper | last post by:

I had a need recently to check if my subclasses properly implemented the desired interface and wished that I could use something like an abstract base class in python. After reading up on metaclass...

Python

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

Latest Bytes