Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 17235 invoked from network); 13 Sep 2007 06:42:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Sep 2007 06:42:33 -0000 Received: (qmail 31385 invoked by uid 500); 13 Sep 2007 06:42:26 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 31342 invoked by uid 500); 13 Sep 2007 06:42:26 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 31333 invoked by uid 99); 13 Sep 2007 06:42:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Sep 2007 23:42:25 -0700 X-ASF-Spam-Status: No, hits=4.2 required=10.0 tests=DEAR_SOMETHING,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of msatoor@gmail.com designates 209.85.132.244 as permitted sender) Received: from [209.85.132.244] (HELO an-out-0708.google.com) (209.85.132.244) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Sep 2007 06:42:23 +0000 Received: by an-out-0708.google.com with SMTP id c8so67151ana for ; Wed, 12 Sep 2007 23:42:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=jEh2K2SpCm0/Jtlrf5sf+HwecuXxmJPmQ5ZjxKvnMh0=; b=bLpZmYd12n/7mKIVUKpXeYmanAR7Y7xllTeuKYhqMV44Uf5QMfjE5Z/cw/n6xBmFsSvrVtpdDa9m4XOM+hOD6gT83HSmAJI/0PbM5FtgQnezRSJ2oTEgA2oxcsErAkWNA/uJEDHhERJysNESqWQ0340OZhODE96rGHGIso3iwDc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=c+G6d83cbQngIU2a18YPhymnyuA3W9qFbhF51ALbZpY7QpDgE692sg/xDZD3iWLe+LjEfKJ+TYQ91B6tnJWhOTDaIqMsSKiJYtj0D4sbVNzVJZigr9+Pz6l+PL2SD48FRi7VXjOq1Z1rFgt17NSvlL7WAvpd3FSUE+kgzNEYbk4= Received: by 10.100.195.10 with SMTP id s10mr290362anf.1189665722897; Wed, 12 Sep 2007 23:42:02 -0700 (PDT) Received: by 10.100.131.1 with HTTP; Wed, 12 Sep 2007 23:42:02 -0700 (PDT) Message-ID: Date: Wed, 12 Sep 2007 23:42:02 -0700 From: "Mamta Satoor" To: derby-dev@db.apache.org Subject: Re: Embedded mode: multiple connection & read-only Db In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11543_14538746.1189665722884" References: X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_11543_14538746.1189665722884 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello Chris, JDBC provides a way to mark the JDBC connections as read-only using * java.sql.Connection.setReadOnly. *But this probably won't help your particular software configuration because it relies on the Connection getter to call the api to mark the Connection as read-only. Mamta On 9/12/07, Lu, Chris (NIH/NLM/LHC) [C] wrote: > > Dear Sir: > > > > I run into Derby last week and found it is very nice and easy to use. > Especially with embedded mode makes it easy for software need to be > distributed. However there are two features that I can't found in Derby: > > > > 1). Multiple users (connections) > > Multiple connections are only provided for embedded Derby Server (not the > pure embedded mode, org.apache.derby.EmbeddedDriver). Please correct me if > I am wrong. > > > > 2). Read-only > > Derby provide a way for running on read-only media. However, does not > provide a flag to set the database to > > read-only. In our application, we store all data in the database and don't > expect/want the end users to modify it after we distribute the software. > > > > Currently, we are using Hyper-Sonic SQL database. HSqlDb is also developed > in 100% Java and don't provide multiple connection for embedded mode with > R-W mode. However, multiple connections are allowed when the flag of > "read-only" is set to "true" in the embedded mode. Very nice and useful > feature. > > > > Just wondering if Derby plan to provide the same features in the near > future. Thank you very much and have a nice day! > > > > n Chris, Ph.D. > > n Sr. Systems Architect > > n Lockheed Martin/MSD/NLM/NIH > > > > > > > > > > > > > ------=_Part_11543_14538746.1189665722884 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hello Chris,
 
JDBC provides a way to mark the JDBC connections as read-only using java.sql.Connection.setReadOnly. But this probably won't help your particular software configuration because it relies on the Connection getter to call the api to mark the Connection as read-only.
 
Mamta
 
On 9/12/07, Lu, Chris (NIH/NLM/LHC) [C] <chlu@mail.nih.gov> wrote:

Dear Sir:

 

I run into Derby last week and found it is very nice and easy to use. Especially with embedded mode makes it easy for software need to be distributed. However there are two features that I can't found in Derby:

 

1). Multiple users (connections)

Multiple connections are only provided for embedded Derby Server (not the pure embedded mode, org.apache.derby.EmbeddedDriver). Please correct me if I am wrong.

 

2). Read-only

Derby provide a way for running on read-only media. However, does not provide a flag to set the database to

read-only. In our application, we store all data in the database and don't expect/want the end users to modify it after we distribute the software.

 

Currently, we are using Hyper-Sonic SQL database. HSqlDb is also developed in 100% Java and don't provide multiple connection for embedded mode with R-W mode. However, multiple connections are allowed when the flag of  "read-only" is set to "true" in the embedded mode. Very nice and useful feature.

 

Just wondering if Derby plan to provide the same features in the near future. Thank you very much and have a nice day!

 

n       Chris, Ph.D.

n       Sr. Systems Architect

n       Lockheed Martin/MSD/NLM/NIH

 

 

 

 

 

 


------=_Part_11543_14538746.1189665722884--