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
|
I need some help please !! I am trying to insert records into an oracle database via LightSpeed and I am confused why it assigns negative values to the identity column when I insert a large number of records at a time. these are my settings: IdentityMethod = IdentityMethod.Sequence;DataProvider = DataProvider.Oracle9; I would like to be able to use oracle's sequence and triggers to insert sequential integers into the identity column. LightSpeed sequence seems to work right but the numbers don't make any sense and are often negative ?? Insert doesn't fail, it just doesn't do what I would like it to do... I guess the question is how to utilize oracle's sequence or just avoid the negatives ??
Thanks.
|
|
|
There was a bug in 2.2 RTM which I think could have caused this if you were at the beginning of the sequence, and the context.IdentityBlockSize was greater than the sequence INCREMENT BY value. Check the INCREMENT BY of the sequence and either increase this to be at least as large the IdentityBlockSize, or decrease the IdentityBlockSize to be less than or equal to the INCREMENT BY value. The default IdentityBlockSize is 10. This bug should be fixed in current nightlies, so you could also download the latest from http://www.mindscape.co.nz/products/lightspeed/nightlybuilds.aspx (Express edition) or the store (retail editions) and give that a try -- if the issue still occurs in the nightly build, please let us know and we will investigate. |
|