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