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] <[EMAIL PROTECTED]> 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 > > > > > > > > > > > > >
