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

> 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) ? 

You may be able to change the schema to use blobs, if you upgrade
to the Oracle 10g drivers. These apparently handle blobs 
differently to Oracle 9, and are backwardly compatible. 

-Tim



-------------------------------------------------------
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