cxf-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aki Yoshida (JIRA)" <j...@apache.org>
Subject [jira] [Issue Comment Edited] (CXF-3534) RMTxStore unable to create tables in Oracle DB (SQL Error: ORA-00902: invalid datatype)
Date Tue, 24 May 2011 09:16:47 GMT

    [ https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038461#comment-13038461
] 

Aki Yoshida edited comment on CXF-3534 at 5/24/11 9:16 AM:
-----------------------------------------------------------

I need to take a look at this problem.
aki

      was (Author: ay):
    This problem is not limited to Oracle DB but may occur in other DBs as well(e.g., some
IBM DB2 models). So I think we need to go back to use the DECIMAL type and use the long type
in memory for those values.

I just don't know how we should go for 4.0.1.
- can we just change the DB schema to use DECIMAL?
- if so, need a migration utility (or automatic migraiton mechanism) if the schema changes?
- or do we need to add the compatibility DECIMAL fields along with the current fields for
those not supporting BIGINT?
regards, aki
  
> 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
>              Labels: ORA-00902, Oracle
>
> 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

Mime
View raw message