Uploaded image for project: 'CXF'
  1. CXF
  2. CXF-3534

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.4
    • 2.4.1
    • WS-* Components
    • Oracle DB: 10.1.0.5.0

    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)

      Attachments

        Activity

          People

            ay Akitoshi Yoshida
            maciejstarzyk Maciej Starzyk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: