[CXF-3534] RMTxStore unable to create tables in Oracle DB (SQL Error: ORA-00902: invalid datatype)

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.4
• Fix Version/s: 2.4.1
• Component/s: WS-* Components
• Labels: ORA-00902 Oracle

Environment

Oracle DB: 10.1.0.5.0

• Assignee: Akitoshi Yoshida
• Reporter: Maciej Starzyk
• Created: 18/May/11 11:34
• Updated: 08/Aug/11 14:43
• Resolved: 27/May/11 13:48

Description

Between CXF 2.3.4 and 2.4.0 in RMTxStore there is a change in data types for RM tables. All DECIMAL types have been changed to BIGINT. When starting application which uses RM the RMTxStore throws exception trying to create tables in Oracle DB:

java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:274)
at org.apache.cxf.ws.rm.persistence.jdbc.RMTxStore.createTables(RMTxStore.java:603)
at org.apache.cxf.ws.rm.persistence.jdbc.RMTxStore.init(RMTxStore.java:668)