JDBC type NUMERIC - Database type NUMBER - But "Will be read back as DECIMAL"!?
--------------------------------------------------------------------------------
Key: DDLUTILS-263
URL: https://issues.apache.org/jira/browse/DDLUTILS-263
Project: DdlUtils
Issue Type: Improvement
Components: Core - Oracle
Reporter: Shant Bozian
Assignee: Thomas Dudziak
I am using the Ddlutils API to migrate a database model from Sybase to Oracle.
The IDENTITY columns (of NUMERIC type) I have in Sybase are being migrated to
Oracle with the proper behaviour: creation of a sequence and a trigger on those
columns, with the type conversion from NUMERIC to NUMBER.
However, when going back from Oracle to Sybase, I cannot retrieve those
IDENTITY columns because of the following problem: NUMBER in Oracle is read
back as DECIMAL which causes the following error in Sybase during the table
creation:
Identity field [..] must be a numeric with a scale of 0. It may not be nullable
or encrypted.
I don't understand the purpose of this "Will be read back as DECIMAL"
behaviour!
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
