You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cxf.apache.org by "Maciej Starzyk (JIRA)" <ji...@apache.org> on 2011/05/18 13:35:47 UTC
[jira] [Created] (CXF-3534) RMTxStore unable to create tables in
Oracle DB (SQL Error: ORA-00902: invalid datatype)
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
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
[jira] [Issue Comment Edited] (CXF-3534) RMTxStore unable to create
tables in Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Resolved] (CXF-3534) RMTxStore unable to create tables in
Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aki Yoshida resolved CXF-3534.
------------------------------
Resolution: Fixed
Replaced BIGINT with DECIMAL(19,0) and this will now work for Oracle DB.
For other drivers, I will create a separate jira feature ticket.
Thus, I am closing this ticket.
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
> Assignee: Aki Yoshida
> Priority: Blocker
> Labels: ORA-00902, Oracle
> Fix For: 2.4.1
>
>
> 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
[jira] [Assigned] (CXF-3534) RMTxStore unable to create tables in
Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aki Yoshida reassigned CXF-3534:
--------------------------------
Assignee: Aki Yoshida
> 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
[jira] [Commented] (CXF-3534) RMTxStore unable to create tables in
Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038461#comment-13038461 ]
Aki Yoshida commented on CXF-3534:
----------------------------------
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
[jira] [Updated] (CXF-3534) RMTxStore unable to create tables in
Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CXF-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aki Yoshida updated CXF-3534:
-----------------------------
Fix Version/s: 2.4.1
> 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
> Fix For: 2.4.1
>
>
> 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
[jira] [Issue Comment Edited] (CXF-3534) RMTxStore unable to create
tables in Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (CXF-3534) RMTxStore unable to create tables in
Oracle DB (SQL Error: ORA-00902: invalid datatype)
Posted by "Aki Yoshida (JIRA)" <ji...@apache.org>.
[ 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