[ 
https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aki Yoshida updated CXF-3534:
-----------------------------

    Fix Version/s: 2.4.1

> 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
>            Assignee: Aki Yoshida
>            Priority: Blocker
>              Labels: ORA-00902, Oracle
>             Fix For: 2.4.1
>
>
> 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

Reply via email to