RE: Oracle 9i TIMESTAMP in primary key problems

2004-04-01 Thread Bob Davison
e schemas we have to write code for. .../Bob -Original Message- From: Dave Newton [mailto:[EMAIL PROTECTED] Sent: 01 April 2004 16:55 To: Apache Torque Users List Subject: RE: Oracle 9i TIMESTAMP in primary key problems > From: Bob Davison [mailto:[EMAIL PROTECTED] > Due to the proble

RE: Oracle 9i TIMESTAMP in primary key problems

2004-04-01 Thread Bob Davison
[mailto:[EMAIL PROTECTED] Sent: 01 April 2004 16:30 To: 'Apache Torque Users List' Subject: RE: Oracle 9i TIMESTAMP in primary key problems 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 -----O

Oracle 9i TIMESTAMP in primary key problems

2004-04-01 Thread Bob Davison
Hi folks, More problems with the Oracle 9i DATE vs TIMESTAMP issue. Due to the problems with the Oracle 9i JDBC drivers and DATE columns we moved to TIMESTAMP columns instead. This seemed fine until we used one of these columns in a primary key. When Torque does an update or delete it builds a