db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shant Bozian (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-263) JDBC type NUMERIC - Database type NUMBER - But "Will be read back as DECIMAL"!?
Date Wed, 08 Sep 2010 09:45:32 GMT
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.


Mime
View raw message