Thanks for you help. I was hoping there was a mapping mechanism (3.0.1 feature?), but I suppose synonyms will work.
Thanks again! -Ryan -----Original Message----- From: Quinton McCombs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 10:33 AM To: Turbine Users List Subject: RE: Using IDBroker with existing Oracle sequences Existing oracle sequences? Hmmm... Torque picks the name of the sequence to use for each table for you. The format is SEQ_<table_name>. You can get around this by creating synonyms if you can't change the names but must still use them. > -----Original Message----- > From: Ryan Clifton [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 12:17 PM > To: [EMAIL PROTECTED] > Subject: Using IDBroker with existing Oracle sequences > > > Hello, > > I have recently installed the stand-alone Torque distribution > and have basically gotten everything working.. except one > critical piece. I can't for the life of me figure out how to > get the IDBroker to link to my existing Oracle sequences and > use them. I've been searching the internet for a few hours > and while I've seen plenty of people who say 'use the native > setting on IDBroker', I've can't find any instructions on how > to actually set it up. > > If you could point me in the right direction or explain how > to go about doing what I want, I would really appreciate it. > > Just to explain a bit more of where I am: > > I used the 'jdbc' task to reverse my database into XML. I > then generated my Torque java classes. I can select existing > records, so I know that my db connections are working. When > I insert, I currently get an error stating that the primary > key is 'null'. I was expecting the save() method to > automatically fill this in. I've read and figured out how to > get around that by setting 'setNew(true)' and then it will go > to the IDBroker. Then I was thinking, how on earth will the > IDBroker know where to go to get the sequence number? So > that's where I am.. > > Thanks! > > Ryan Clifton > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
