Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1919A10ECC for ; Tue, 18 Feb 2014 13:14:07 +0000 (UTC) Received: (qmail 80234 invoked by uid 500); 18 Feb 2014 13:13:57 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 79824 invoked by uid 500); 18 Feb 2014 13:13:51 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 79817 invoked by uid 99); 18 Feb 2014 13:13:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Feb 2014 13:13:50 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=FSL_NEW_HELO_USER,RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of rick.hillegas@oracle.com designates 156.151.31.81 as permitted sender) Received: from [156.151.31.81] (HELO userp1040.oracle.com) (156.151.31.81) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Feb 2014 13:13:44 +0000 Received: from ucsinet22.oracle.com (ucsinet22.oracle.com [156.151.31.94]) by userp1040.oracle.com (Sentrion-MTA-4.3.2/Sentrion-MTA-4.3.2) with ESMTP id s1IDDNPF000653 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Tue, 18 Feb 2014 13:13:23 GMT Received: from userz7022.oracle.com (userz7022.oracle.com [156.151.31.86]) by ucsinet22.oracle.com (8.14.5+Sun/8.14.5) with ESMTP id s1IDDMUq022647 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 18 Feb 2014 13:13:23 GMT Received: from abhmp0005.oracle.com (abhmp0005.oracle.com [141.146.116.11]) by userz7022.oracle.com (8.14.5+Sun/8.14.4) with ESMTP id s1IDDMvF022634 for ; Tue, 18 Feb 2014 13:13:22 GMT Received: from dhcp-whq-twvpn-2-vpnpool-10-159-178-144.vpn.oracle.com (/10.159.178.144) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Tue, 18 Feb 2014 05:13:22 -0800 Message-ID: <53035C71.1080207@oracle.com> Date: Tue, 18 Feb 2014 05:13:21 -0800 From: Rick Hillegas User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.7; en-US; rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Re: adding a record to a table References: <1392433051206-137120.post@n7.nabble.com> <52FF6448.6010606@gmail.com> <1392494700312-137127.post@n7.nabble.com> <53007DC5.2000103@gmail.com> <1392629362323-137136.post@n7.nabble.com> <5301DE87.7000607@gmail.com> <1392698712147-137177.post@n7.nabble.com> In-Reply-To: <1392698712147-137177.post@n7.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Source-IP: ucsinet22.oracle.com [156.151.31.94] X-Virus-Checked: Checked by ClamAV on apache.org On 2/17/14 8:45 PM, Bob M wrote: > Hi guys (John and Rick) > Thank you for your considerations (even though they are a bit above my level > of comprehension) > > I have added a constraint a follows:- > > CONSTRAINT tablekey_pk PRIMARY KEY(Trading Date, Trading_Time) > however, lets step back a bit............after reading your suggested > readings > > [A] > 1) searching for derby.log on my C drive results in > 2 shortcuts > 4 text documents > and some other odd things............ > > The first text document is in C:\Databases dated 18/2/2014 1.17KB > The second is in C:\Users\Stan\Downloads same date 1.05KB > The third and fourth are dated 1 Dec 2013 > I don't understand why I have so many ? > > [B] > derby.properties file > I read that one has to provide this file oneself > and yet I have one! > it is located in C:\Users\Stan\.netbeans-derby > In that folder is also > (a) a subfolder called Weka Input > derby.log dated 1 Dec 2013 > the derby.properties is dated 18/2/2014 and contains two commented lines - a > heading and a date > I have since added the extra line as John has suggested > > But, my question is - does this setup look like a mess to you? Hi Bob, I don't see anything alarming. It looks as though you have more than one program which boots Derby. Typically, each program will have its own customized properties file and each program will have its own derby.log. The general rule is this: you need to create your own derby.properties file in the directory where you boot your program, and that's the same directory where you'll find your program-specific derby.log. Hope this helps, -Rick > > > -- > View this message in context: http://apache-database.10148.n7.nabble.com/adding-a-record-to-a-table-tp137120p137177.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. >