db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Embedded mode: multiple connection & read-only Db
Date Thu, 13 Sep 2007 06:42:02 GMT
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
>
>
>
>
>
>
>
>
>
>
>
>
>

Mime
View raw message