Stanley Bradbury wrote:
Nat Gross wrote:
If all users access the database via a J2ee or JEE application server,
which Derby mode is recommended?
1. Performance wise.
2. Db Admin wise.
Thanks;
nat
Since the App server provides nework connectivity most people simply
embed Derby in the App Server, setup the necessary datasources and use
these to access the database(s) (three Derby with App server papers can
be found at: http://db.apache.org/derby/integrate/index.html).
If, however, you need to access the database from an application that
will not be using the datasource(s) registered with the App server then
you will need to use Network Server as well. These is increased
administration and slight performance degredation when Network server is
used.
To use the Network Server, how would one change the Global Datasource in
the Global Context example at
<http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html>?
Would it just require a change to the driverClassName? If so to what?
Would it be possible to quantify the amount of performance degradation
using the Network Server over the Embedded Driver?
Thanks
Jim