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-262) No support for the Sybase TIMESTAMP native datatype?
Date Wed, 08 Sep 2010 09:27:32 GMT
No support for the Sybase TIMESTAMP native datatype?
----------------------------------------------------

                 Key: DDLUTILS-262
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-262
             Project: DdlUtils
          Issue Type: Improvement
          Components: Core - Sybase
            Reporter: Shant Bozian
            Assignee: Thomas Dudziak


I am using the Ddlutils API to migrate a database model from Sybase to Oracle. I noticed that
there isn't anything in DdlUtils that recognizes the TIMESTAMP datatype in Sybase.

When going from Sybase to Oracle, timestamp is converted to raw(8). Then, when going back
from Oracle to Sybase, raw(8) is converted back to varbinary, as there is no special field
in the model to tell this was an original Sybase TIMESTAMP column.

So far so good, so I tried to modify the database model in the code and set the desired TIMESTAMP
type wherever necessary, but that wasn't possible neither as there is no JDBC datatype which
corresponds to the Sybase TIMESTAMP native datatype!

So it seems there is no way to create a TIMESTAMP column in Sybase, through DdlUtils!?

-- 
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