Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 48262 invoked from network); 22 Nov 2007 07:16:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Nov 2007 07:16:23 -0000 Received: (qmail 63911 invoked by uid 500); 22 Nov 2007 07:16:10 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 63887 invoked by uid 500); 22 Nov 2007 07:16:10 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 63876 invoked by uid 99); 22 Nov 2007 07:16:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Nov 2007 23:16:10 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [64.81.61.238] (HELO cantara.com) (64.81.61.238) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Nov 2007 07:15:58 +0000 Received: from [68.26.168.119] (001-753-886.area1.spcsdns.net [68.26.168.119] (may be forged)) (authenticated bits=0) by cantara.com (8.13.1/8.13.1) with ESMTP id lAM7FfSj005601 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO) for ; Wed, 21 Nov 2007 23:15:45 -0800 Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <20071122070812.GA23749@dotster.com> References: <20071122070812.GA23749@dotster.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Raul Acevedo Subject: Re: Oracle Date Village Patch Date: Thu, 22 Nov 2007 02:15:39 -0500 To: "Apache Torque Users List" X-Mailer: Apple Mail (2.752.2) X-Spam-Score: -7.5 BAYES_00,RJA_TECHNOLOGY [] X-Spam-Sender: Sender [] X-Scanned-By: MIMEDefang 2.48 on 64.81.61.238 X-Virus-Checked: Checked by ClamAV on apache.org Supposedly starting the JVM with -Doracle.jdbc.V8Compatible=true fixes this: http://wiki.apache.org/db-torque/OracleFAQ However it didn't work for me, even after setting the Torque mapping to TIMESTAMP. I had to change the columns from DATE to TIMESTAMP. Raul Acevedo http://www.cantara.com On Nov 22, 2007, at 2:08 AM, Brendan Miller wrote: > > It seems I have a knack for running into problems that were > discussed at > length and (partially?) solved ages ago. > > That said, I have a table in Oracle with a column of type DATE. It > doesn't matter whether I tell Torque this is a DATE or TIMESTAMP > column in the schema.xml, because as we all know, Village uses this > crazy ResultSetMetaData business. (SELECT * FROM TABLENAME WHERE 1 > = -1 !!!) > > So I read of several places where there is a Village patch that makes > re-interprets Oracle's reporting of DATE types to be Timestamps or > somesuch. Bascially, something so that when I have a java.util.Date > field in one of my table objects, I can setField(new Date()) and have > the database show hours/minutes/seconds. > > Where is this code? Or what is the workaround? I do not have the > freedom of altering the existing table to use timestamp types. > > Brendan > > --------------------------------------------------------------------- > 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