Mailing-List: contact issues-help@cxf.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cxf.apache.org
Date: Tue, 24 May 2011 19:42:47 +0000 (UTC)
From: "Aki Yoshida (JIRA)" <jira@apache.org>
To: issues@cxf.apache.org
Message-ID: 
 <1127125197.40263.1306266167374.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <963089831.22065.1305718547558.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (CXF-3534) RMTxStore unable to create tables in
 Oracle DB (SQL Error: ORA-00902: invalid datatype)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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