Please file a JIRA and submit the changes as a patch.   This is excellent!

https://issues.apache.org/jira/browse/CXF


Dan

On Thu August 27 2009 10:17:52 am Dan Ryazansky wrote:
> The current version of CXF uses a Derby database when Reliable messaging is
> turned on. However, we required use of ORACLE.
>
> I had to make the following changes to to make the code database agnostic
> in RMTxStore:
>
> from
> "CUR_MSG_NO DECIMAL(31, 0) NOT NULL DEFAULT 1, "
> to
> "CUR_MSG_NO DECIMAL(31, 0) DEFAULT 1 NOT NULL, "
> Derby doesn't care about the order of NOT NULL / DEFAULT, Oracle does
>
> from
> "EXPIRY BIGINT, "
> to
> "EXPIRY DECIMAL(31, 0), "
> Oracle doesn't have BIGINT. DECIMAL is the one data type that seems to work
> across different DBs.
>
> from
> "X0Y32".equals(ex.getSQLState())
> to
> "X0Y32".equals(ex.getSQLState()) || 955 == ex.getErrorCode()
> When checking for table creation (955 is the Oracle error code if the table
> already exists).
>
> Is this something that should be committed into the repository?

-- 
Daniel Kulp
dk...@apache.org
http://www.dankulp.com/blog

Reply via email to