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 <[EMAIL PROTECTED]> To: Torque Users List <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> Reply-To: Apache Torque Users List <[EMAIL PROTECTED]> To: Apache Torque Users List <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, June 14, 2004 10:19 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ---------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]