Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 8669 invoked from network); 4 Sep 2007 01:49:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Sep 2007 01:49:34 -0000 Received: (qmail 76156 invoked by uid 500); 4 Sep 2007 01:49:27 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 76126 invoked by uid 500); 4 Sep 2007 01:49:27 -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 76115 invoked by uid 99); 4 Sep 2007 01:49:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Sep 2007 18:49:27 -0700 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: domain of brdohman@eiu.edu designates 139.67.14.62 as permitted sender) Received: from [139.67.14.62] (HELO eureka.eiu.edu) (139.67.14.62) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 04 Sep 2007 01:49:23 +0000 Received: from potrero.eiu.edu (potrero.eiu.edu [139.67.14.46]) by eureka.eiu.edu (Postfix) with ESMTP id 8D3D52940DBF for ; Mon, 3 Sep 2007 20:20:55 -0500 (CDT) Date: Mon, 3 Sep 2007 20:20:55 -0500 (CDT) From: Brandon Dohman To: Derby Discussion Message-ID: <12701403.201791188868855536.JavaMail.root@potrero.eiu.edu> In-Reply-To: Subject: how to lock a table MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [127.0.0.1] X-Virus-Checked: Checked by ClamAV on apache.org I am wanting to lock a table so that I can write information to it w/out having potential duplicate information written to the database table at the same time. I am using jdbc to connect to a derby db with java and wondering if there was an sql command that I can use to lock the table and then unlock it when I am done w/ my update. I did some googling but wasn't able to come up with anything useful, maybe I was looking in the wrong place. all help is much appreciated.