RE: Transaction Management?

2004-06-03 Thread Jarrell, Maury
systemProperty2.save( con ); > > Transaction.commit(con); > > fail( "There was no exeception inserting a duplicate > key"); > } > > catch( TorqueException e ) > { >

Transaction Management?

2004-06-03 Thread Jarrell, Maury
Hello all, Where would I go to find out how transactions are managed in Torque? I've looked over the web site, the Wiki, and the mailing list archives and haven't found an explanation. I'm writing a backup routine using Torque to backup Oracle databases. I'm using the peer class generated by To

RE: Oracle 9i TIMESTAMP in primary key problems

2004-04-01 Thread Jarrell, Maury
> > So it seems that if you use Oracle 9i you can ... > - use Oracle DATE and run with Oracle 8i drivers > - use Oracle DATE, run with Oracle 9i drivers and the Village patch > - use Oracle TIMESTAMP, run with Oracle 9i drivers but don't use dates > in primary keys > > .../Bob Thanks for yo

RE: Oracle 9i TIMESTAMP in primary key problems

2004-04-01 Thread Jarrell, Maury
> Totally unrelated, but I thought using "real-world data" as a primary > key (or portion thereof) was generally a no-no in the DB world. Did I > misunderstand? > > Dave You didn't misunderstand at all. I have had my share of frustrations dealing with Oracle dates and nulls, and wondered what

RE: Oracle 9i TIMESTAMP in primary key problems

2004-04-01 Thread Jarrell, Maury
Bob, What were the original problems you encountered? I did a couple of searches on the list archive and couldn't find them. Thanks, Maury -Original Message- From: Bob Davison [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:59 AM To: [EMAIL PROTECTED] Subject: Oracle 9i TIME