I like the idea of using GUIDs, however, the DB is quite legacy and it was enough teeth pulling to get folks to agree to a surrogate key as it is. The key has to be a sequence, so my hands are tied there.
Thanks for the suggestion, cc On May 17, 10:35 am, Jason Dentler <jasondent...@gmail.com> wrote: > Your best option is probably to switch to a better POID generator: > guid.comb is my favorite, though many people prefer hilo. > > > > On Mon, May 17, 2010 at 9:24 AM, Corey Coogan <schmoo...@gmail.com> wrote: > > Hi gang, > > I'm using Oracle 10g and I'm working on getting DBA's to move > > away from composite keys to surrogate keys. They have started the > > migration on a few tables for me, but I've since learned during > > development that the sequences are causing problems in SQLite. > > > I typically use SQL Server and the identity columns are no issue, but > > SQLite doesn't know what to do with a sequence type. I would really > > like to use SQLite to test my mappings, queries, etc. > > > Is there anyway to abstract this type of ID generator from an Oracle > > Sequence? > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to nhus...@googlegroups.com. > > To unsubscribe from this group, send email to > > nhusers+unsubscr...@googlegroups.com<nhusers%2bunsubscr...@googlegroups.com> > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to nhus...@googlegroups.com. > To unsubscribe from this group, send email to > nhusers+unsubscr...@googlegroups.com. > For more options, visit this group > athttp://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhus...@googlegroups.com. To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
