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] [Commented] (CXF-3534) RMTxStore unable to create tables in Oracle DB (SQL Error: ORA-00902: invalid datatype)
Date Tue, 24 May 2011 19:42:47 GMT

    [ 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

Mime
View raw message