Versions Compared

Old Version 2

changes.mady.by.user Glen Mazza

Saved on

compared with

New Version 3

changes.mady.by.user Glen Mazza

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
Notes on

Note: This is a newbie writing, this information may be incorrect and hence subject to change.

...

Geronimo's internal Derby installation:

...



* Geronimo's Derby installation runs

...

 in network client mode.  That means that both processes running in the same JVM as Geronimo (e.g., its underlying web applications) and different JVM's can access Derby databases created from within Geronimo's Console application

...

.

* The Geronimo Derby listener runs on the Derby's usual network port 1527.  

* Derby databases created from Geronimo's web-based Manager Console (DB Manager left-menu item) are stored in the {geronimo install}/var/derby directory.  To access a derby database instance from external applications (e.g.,

...

 Derby's ij query tool)

...

  • Derby databases can be created external to Geronimo, running with Derby's network client software, and accessed in client-server mode. In this case, applications running on multiple JVM's can access the database. See the Derby website for more details.
  • As explained in the link below, it is recommended for web applications using a pre-configured Derby database to use an EAR file, with the database compressed into a JAR file and kept separate from the WAR file. Next, using a Geronimo bean, the JAR file can be uncompressed and installed into the geronimo/var/derby directory (the usual location for embedded databases).
, use the standard network-client URL form (replacing the server name and database path as appropriate):

(Linux) connect 'jdbc:derby://localhost:1527//usr/myapps/geronimo-1.1.1/var/derby/MyTestDB;';

(Windows) connect 'jdbc:derby://localhost:1527/c:\working\derbyDBs\MyTestDB;';

If your database requires a username/password, append a string similar to "'user=myuser;password=mypass';" to the above.

* As explained in the link below, for installing web applications using the Derby database, it is recommended for web applications using a pre-configured Derby database to use an EAR file, with the database compressed into a JAR file and kept separate from the WAR file.  Next, using a Geronimo bean, the JAR file can be uncompressed and installed into the geronimo/var/derby directory (the usual location for embedded databases).

http://marc.info/?l=geronimo-user&m=118425695504466&w=2

...