db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saravana Krishnan Kannan" <skka...@mail.uky.edu>
Subject Re: [Fwd: RE: Date vs timestamp with Oracle]
Date Mon, 16 Aug 2004 05:18:40 GMT
Hi,

  I haven't tried to get it integrated with the main Village, but I'm definitely willing to
lend them the code if they would put it along with the main Village code. As of now my patch
has a lot of Oracle specific code, but that can simply set up village to call my code only
if the Metadata says the connection is an Oracle connection.

-Sarav


-----Original Message-----
From: Scott Eade <seade@backstagetech.com.au>
To: Torque Users List <torque-user@db.apache.org>
Date: Mon, 16 Aug 2004 14:27:31 +1000
Subject: [Fwd: RE: Date vs timestamp with Oracle]

I'm half way through applying the patch below to Torque 3.1.1 and HEAD.  
I don't use Oracle so I cannot if this is going to help or make things 
worse.

Can all you Oracle users out there please let me know your opinion?

I'm aiming to get a 3.1.1 release of torque out fairly soon and I would 
appreciate your feedback.

BTW: I am including a reference to your Sarav's patched Village 2.0 code 
in the Oracle HOWTO - I hope this is okay.  Shrav: Have you made any 
attempts at getting your changes committed to back to Village?

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au


-------- Original Message --------
Subject: 	RE: Date vs timestamp with Oracle
Date: 	Thu, 17 Jun 2004 09:44:32 -0700
From: 	Daniel Huang <danihuan@cisco.com>
Reply-To: 	Apache Torque Users List <torque-user@db.apache.org>
To: 	Apache Torque Users List <torque-user@db.apache.org>



Apply this patch to templates/sql/base/oracle/db.props:

Index: db.props
===================================================================
--- db.props    (revision 949)
+++ db.props    (revision 948)
@@ -19,8 +19,8 @@
 VARCHAR = VARCHAR2
 LONGVARCHAR = VARCHAR2 (2000)
 DATE = DATE
-TIME = TIME
-TIMESTAMP = TIMESTAMP
+TIME = DATE
+TIMESTAMP = DATE
 BINARY = LONG RAW
 VARBINARY = BLOB
 LONGVARBINARY = LONG RAW

Regards,
Daniel

-----Original Message-----
From: Raphael Mankin,,, [mailto:raph@panache.demon.co.uk]On Behalf Of
raph@mankin.org.uk
Sent: Monday, June 14, 2004 10:19 AM
To: torque-user@db.apache.org
Subject: Date vs timestamp with Oracle

I have just changed some of my DB fields from DATE to TIMESTAMP, however the
generated Oracle DDL is still DATE which drops the time part.

How do I get Torque to generate real date+time and not have to edit the DDL
by
hand?


BTW when I did this in mySQL I had no problems. I am using Torque 3.1.

--
                               Unfortunately, most programmers like to
                               program. Some of them would rather
                               program than eat or bathe.
                               - Larry Constantine


Raphael Mankin
E-Mail: raph@panache.demon.co.uk
----------------------------------




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message