[
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 3:14 PM:
-----------------------------------------------------------
Hi,
I think the best option would be to keep the code part of RMTxStore unchanged
but simply to change those BIGINT types to DECIMAL(19,0) in the DB-schema
declaration in this class.
I thought we may have problems changing the DB-schema, but I think it should be
okay because of the compatibilty between DECIMAL and BIGINT, both of which can
be read via getLong().
regards, aki
was (Author: ay):
I need to take a look at this problem.
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
