Return-Path: Delivered-To: apmail-geronimo-dev-archive@www.apache.org Received: (qmail 37490 invoked from network); 21 Sep 2010 10:44:57 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 21 Sep 2010 10:44:57 -0000 Received: (qmail 30305 invoked by uid 500); 21 Sep 2010 10:44:57 -0000 Delivered-To: apmail-geronimo-dev-archive@geronimo.apache.org Received: (qmail 29886 invoked by uid 500); 21 Sep 2010 10:44:54 -0000 Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: dev@geronimo.apache.org List-Id: Delivered-To: mailing list dev@geronimo.apache.org Received: (qmail 29876 invoked by uid 99); 21 Sep 2010 10:44:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Sep 2010 10:44:53 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Sep 2010 10:44:52 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o8LAiWPI022574 for ; Tue, 21 Sep 2010 10:44:32 GMT Message-ID: <12554276.313501285065872369.JavaMail.jira@thor> Date: Tue, 21 Sep 2010 06:44:32 -0400 (EDT) From: "Ralf Baumhof (JIRA)" To: dev@geronimo.apache.org Subject: [jira] Created: (GERONIMO-5617) Timestamp precision (scale) openjpa -> Oracle MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Timestamp precision (scale) openjpa -> Oracle --------------------------------------------- Key: GERONIMO-5617 URL: https://issues.apache.org/jira/browse/GERONIMO-5617 Project: Geronimo Issue Type: Bug Security Level: public (Regular issues) Components: databases, persistence Affects Versions: 2.1.4 Environment: Geronimo 2.14 with JDK 1.5 update 20, on Window / Linux, Database Oracle 10g or 11 Reporter: Ralf Baumhof Timestamp precision should be up to 10 up -12 (nano second) with Datatype java.sql.Timestamp. On inserts to database only 10 up -3 is inserted. This is done with rounding at position 10 up -3. Example - the log lines beginning with a "#" the value of 5551110 is rounded to 12:16:06.006: 2010-09-21 12:16:06,646 INFO - $$vor update, timestamp.toString=2010-09-21 12:16:06.646 $$ nanos vor update=646000000 2010-09-21 12:16:06,646 INFO - (addition Millisekunden): 1 * 1110222 = 1110222 2010-09-21 12:16:06,646 INFO - $$nach update, timestamp.toString=2010-09-21 12:16:06.001110222 $$ nanos nach update=1110222 2010-09-21 12:16:06,662 INFO - $$vor update, timestamp.toString=2010-09-21 12:16:06.662 $$ nanos vor update=662000000 2010-09-21 12:16:06,662 INFO - (addition Millisekunden): 2 * 1110222 = 2220444 2010-09-21 12:16:06,662 INFO - $$nach update, timestamp.toString=2010-09-21 12:16:06.002220444 $$ nanos nach update=2220444 2010-09-21 12:16:06,662 INFO - $$vor update, timestamp.toString=2010-09-21 12:16:06.662 $$ nanos vor update=662000000 2010-09-21 12:16:06,662 INFO - (addition Millisekunden): 3 * 1110222 = 3330666 2010-09-21 12:16:06,662 INFO - $$nach update, timestamp.toString=2010-09-21 12:16:06.003330666 $$ nanos nach update=3330666 2010-09-21 12:16:06,677 INFO - $$vor update, timestamp.toString=2010-09-21 12:16:06.677 $$ nanos vor update=677000000 2010-09-21 12:16:06,677 INFO - (addition Millisekunden): 4 * 1110222 = 4440888 2010-09-21 12:16:06,677 INFO - $$nach update, timestamp.toString=2010-09-21 12:16:06.004440888 $$ nanos nach update=4440888 2010-09-21 12:16:06,693 INFO - $$vor update, timestamp.toString=2010-09-21 12:16:06.693 $$ nanos vor update=693000000 2010-09-21 12:16:06,693 INFO - (addition Millisekunden): 5 * 1110222 = 5551110 ###2010-09-21 12:16:06,693 INFO - $$nach update, timestamp.toString=2010-09-21 12:16:06.00555111 $$ nanos nach update=5551110 ###2010-09-21 12:16:36,583 INFO - $$ personAnschrift=4425 54852010-09-21 12:16:06.006 2010-09-21 12:16:36,583 INFO - $$ personAnschrift=4425 54842010-09-21 12:16:06.004 2010-09-21 12:16:36,583 INFO - $$ personAnschrift=4425 54832010-09-21 12:16:06.003 2010-09-21 12:16:36,583 INFO - $$ personAnschrift=4425 54822010-09-21 12:16:06.002 2010-09-21 12:16:36,583 INFO - $$ personAnschrift=4425 54812010-09-21 12:16:06.001 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.