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.
