Hi Carlos,
Some responses inline...
On 2/8/12 3:00 PM, Carlos de Luna Saenz wrote:
I really don't know if this is a good couple questions or not...
We are developing an embedded DB app that has a 1.74GB of files for the
database
I wonder if there is something like a shrink or compact command that
will reduce the amount of space for the app DB.
The SYSCS_UTIL.SYSCS_COMPRESS_TABLE and
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE procedures can be used to
reclaim unused space. Don't know how effective they will be for your
needs though. See
http://db.apache.org/derby/docs/10.8/ref/ref-single.html#rrefaltertablecompress
Is there a way to make it user/password protected? We don't want to
"start" a server on the program side but password protection would be
appreciated.
Derby currently supports 3 user/password authentication schemes,
discussed here:
http://db.apache.org/derby/docs/10.8/devguide/devguide-single.html#cdevcsecure42374
. In the next major feature release (10.9), we hope to introduce another
authentication scheme which should be easier to configure and
administer; it is described by the functional spec attached to
https://issues.apache.org/jira/browse/DERBY-866
Hope this helps,
-Rick
Greetings