james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Short" <ssh...@postx.com>
Subject [PATCH] Fix Issue 247 Oracle DB and add support for DB2
Date Mon, 05 Apr 2004 16:22:25 GMT

This patch is for branch "branch_2_1_fcs" only.

The attached patch fixes the Oracle DB issue, #247, by changing the data
type for message-body and message-attributes from longraw to blob. In
order to get this to work I had to change the JDBC code that retrieves
these fields to use getBlob instead of getBytes.  I have tested this
change with MySql, Oracle  and DB2.

In order to add the Oracle SQL for "retrieveMessageBodySizeSQL" I have
used the function dbms_lob.getlength() and I think this requires Oracle
8 or higher. I tested with Oracle 9.



View raw message