[
https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038748#comment-13038748
]
Aki Yoshida commented on CXF-3534:
----------------------------------
Maybe we need to first clarify which drivers are supported by RMTxStore and
discuss how we should proceed.
Althought it's simple to make the current RMTxStore to also work for Oracle,
the question remains for other drivers (e.g., MSSQL not working with BLOB).
If we want to support other drivers or make life easier for people writing
their own store implementaiton, should we introduce an abtraction in RMTxStore?
please comment.
thanks. 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
> Assignee: Aki Yoshida
> 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
