[Fwd: [jonas] EJB Entity mapping BLOB with Oracle]

[Philippe Durieux-2]

    Salut,

Est-ce que ca vous dit quelque chose ? Moi, je ne vois pas...

    Philippe


-------- Original Message --------
Subject: [jonas] EJB Entity mapping BLOB with Oracle
Date: Mon, 29 Jan 2007 12:04:43 +0100
From: zze-M2S LETANG A ext RD-BIZZ-LAN <aletang.ext@...>
Reply-To: jonas@...
To: <jonas@...>



Hi,

Using the oracle 9.2 thin driver for our EJB entity mapping, we
encountered a problem to retrieve blob from database.
Instead of getting blob content we get a constant array of 86 bytes that
is, according to web issues, the oracle's blob locator ?!

The problem is that we can't use the OCI driver (that seems to solve the
problem).

Moreover, our software architecture, based on Jonas (4.8.3), Java 5 with
EJB CMP bean, uses the oracle's rdb mapper
(datasource.mapper=rdb.oracle) to automatically maps database data in
our bean. (jdbc driver = ojdbc14.jar)

Is it a known bug ? Is it possible to change the way blob are retrieved ?

Thank you for your answer.

Aurélien


[philippe.durieux.vcf]

---

begin:vcard
fn:Philippe DURIEUX
n:DURIEUX;Philippe
org:<a href="http://www.bull.com"><img title="BULL" alt="BULL" border="0" src="http://www.bull.com/img/header/logobull.gif" /></a>Bull, Architect of an Open World ^TM;<font color="#397931">OPEN SOFTWARE R&D</font>
adr;quoted-printable:;;1 rue de Provence;Echirolles;Is=C3=A8re;38432;FRANCE
email;internet:Philippe.Durieux@...
title:<a href="http://jonas.objectweb.org"><font color="#397931">JOnAS Application Server</font></a>
tel;work:[phone]
x-mozilla-html:FALSE
version:2.1
end:vcard

---

--
You receive this message as a subscriber of the jorm@... mailing list.
To unsubscribe: mailto:jorm-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

[LEFEBVRE Alexandre RD-MAPS-GRE-2]

I seem to remember that we've had problems with dates, blobs, etc, with Oracle.

    alex

On 30 Jan 2007, at 10:43, Philippe Durieux wrote:

   Salut,

Est-ce que ca vous dit quelque chose ? Moi, je ne vois pas...

   Philippe

-------- Original Message --------

Subject: [jonas] EJB Entity mapping BLOB with Oracle

Date: Mon, 29 Jan 2007 12:04:43 +0100

From: zze-M2S LETANG A ext RD-BIZZ-LAN <aletang.ext@...>

Reply-To: jonas@...

To: <jonas@...>

Hi,

Using the oracle 9.2 thin driver for our EJB entity mapping, we encountered a problem to retrieve blob from database.

Instead of getting blob content we get a constant array of 86 bytes that is, according to web issues, the oracle's blob locator ?!

The problem is that we can't use the OCI driver (that seems to solve the problem).

Moreover, our software architecture, based on Jonas (4.8.3), Java 5 with EJB CMP bean, uses the oracle's rdb mapper (datasource.mapper=rdb.oracle) to automatically maps database data in our bean. (jdbc driver = ojdbc14.jar)

Is it a known bug ? Is it possible to change the way blob are retrieved ?

Thank you for your answer.

Aurélien

<philippe.durieux.vcf>

-- 

You receive this message as a subscriber of the jorm@... mailing list.

To unsubscribe: jorm-unsubscribe@...

For general help: sympa@...

ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

--

WARNING: NEW E-MAIL ADDRESS!

Alexandre Lefebvre, R&D Group Leader

France Telecom, Research & Development, MAPS/AMS

28 chemin du Vieux Chene - B.P. 98

38243 Meylan CEDEX - France

phone: [phone] - fax: [phone]

email: alexandre.lefebvre@...

email: alefebvr@...

--
You receive this message as a subscriber of the jorm@... mailing list.
To unsubscribe: mailto:jorm-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws