use blob instead of long raw for messageBlob in Oracle schema ?

Hello,

I am using OpenJMS 0.7.6.1, with persistency in Oracle 9, using OCI driver.

Everything works just fine, but an additional requirement has arisen from my
project : as our Oracle database is replicated to another using Streams
mechanism, we cannot use long raws in table, since they are not handled by
Streams...

As using blob would be OK, I tried merely changing the database schema to use
blob in 'the messageBlob' column, but it does not work directly (which is not so
surprising).
After some look in several newsgroups, I learned several things (but correct me
if I am wrong):
 - using a blob data type in Oracle cannot be made using standard JDBC classes;
it has to use some Oracle-specific classes, thus breaking database independency
 - some people already succeeded in making OpenJMS use blob for 'messageBlob'
columns, but did not provide their configuration or code change.

Does anyone know what impact it would have for me to do this ? Would it need to
patch the OpenJMS source code (which I am very reluctant to do, since OpenJMS
version change would be much harder to follow) ? 

Thank you in advance

Antoine



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click