[
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
