[PATCH] Fix Issue 247 Oracle DB and add support for DB2

[Steve Short <ss...@postx.com>]

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.

Regards
Steve

 <<patch_oracle_db2.txt>> 

RE: [PATCH] Fix Issue 247 Oracle DB and add support for DB2

["Noel J. Bergman" <no...@devtech.com>]

Steve,

Committed to CVS.  Please review the change in CVS.

	--- Noel


---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org