RMTxStore unable to create tables in Oracle DB (SQL Error: ORA-00902: invalid
datatype)
---------------------------------------------------------------------------------------
Key: CXF-3534
URL: https://issues.apache.org/jira/browse/CXF-3534
Project: CXF
Issue Type: Bug
Components: WS-* Components
Affects Versions: 2.4
Environment: Oracle DB: 10.1.0.5.0
Reporter: Maciej Starzyk
Priority: Blocker
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)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
