This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
LightSpeed 5.0.2994.0 I have a migration where one of the field had ModelDataType.Int64 data type. After trying to use it with ProviderType.Oracle9 I got an exception
Well that's no good, Oracle should support long numbers. Anyway, I changed this field's datatype to ModelDataType.Guid both in migration's C# code and in *.lsmcheckpoint file but the error persists! Projects' cleaning/rebuilding was performed but did not help. Where else can migration take this info about Int64 field? And on related note, while there exists DataProvider.Oracle9Odp, there is no ProviderType.Oracle9Odp. Does that mean that migrations do not support ODP.NET? |
|
|
The reason for the error is we do not have a translation for Int64. Im not sure on the rationale as to why this limitation exists so we could look at adding one. What would you expect this to map to - e.g. NUMBER(18)?
|
|
|
Isn't NUMBER(19) the choice to have all possible System.Int64 values included? There could be some values which exceed Int64 though. But since there are no explicit Int64 fields in the model (maybe it's the mapping for KeyTable.NextId?), any mapping would help. |
|
|
Thanks - I will add it as NUMBER(19), we should have this merged in tomorrow and I will post an update once this has been merged in for the nightlies.
|
|
|
This has now been merged in and will be available in the next nightly build for you.
|
|
|
Thanks, Jeremy |
|