db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francois Orsini" <francois.ors...@gmail.com>
Subject Re: Derby in JEE appserver
Date Fri, 27 Apr 2007 02:20:41 GMT
Jim,

Taking the Tomcat example, you would need to change the driver class name to
point to the Derby Network Client One:
driverClassName="org.apache.derby.jdbc.ClientDriver"

and the JDBC connection URL to"
url="jdbc:derby://localhost:1527/JPetStoreDB" (if derby server runs on same
host and default port number of 1527)
See:
http://db.apache.org/derby/docs/dev/adminguide/adminguide-single.html#cadminappsclient

Of course, you would have to start Derby in a standalone server mode - you
can find more information here:
http://db.apache.org/derby/docs/dev/adminguide/adminguide-single.html#tadmincbdjhhfd

as well as copying the Derby network client JAR (derbyclient.jar) to the
Tomcat 'common' directory {Tomcat_Home}/common/lib and use the proper (see
above) driver class name and URL in the guidelines notes of:
http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html

Hope this helps.

On 4/23/07, Jim Shea <jshea@jpl.nasa.gov> wrote:
>
> 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
>

Mime
View raw message