You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Sa...@equifax.com on 2006/01/17 17:39:16 UTC

Using Derby in J2EE webapp

would like to know if there is an example of using derby in a j2ee webapp.

Re: Using Derby in J2EE webapp

Posted by "Jean T. Anderson" <jt...@bristowhill.com>.

Andrus Adamchik wrote:
> ... 
> Since you asked for an example, here goes a self-plug:
> 
> http://objectstyle.org/confluence/display/CAY/Cayenne+PetStore
> 
> Cayenne PetStore contains Derby preconfigured to use the embedded  mode, 
> so the DB creation and initial data load happen automatically  when the 
> web app starts.


Thanks for the self plug -- it's entirely welcome.

  -jean

Re: Using Derby in J2EE webapp

Posted by Andrus Adamchik <an...@objectstyle.org>.

On Jan 17, 2006, at 11:39 AM, Samuel.Perez@equifax.com wrote:

>
> would like to know if there is an example of using derby in a j2ee  
> webapp.

It won't be any different from any other database. You connect to the  
database via JDBC API (DataSource or DriverManager) and go from  
there. Derby advantage is that you have an embedded mode, so on the  
low end, you won't have to run a separate server process.

Since you asked for an example, here goes a self-plug:

http://objectstyle.org/confluence/display/CAY/Cayenne+PetStore

Cayenne PetStore contains Derby preconfigured to use the embedded  
mode, so the DB creation and initial data load happen automatically  
when the web app starts.

Andrus Adamchik

Re: Using Derby in J2EE webapp

Posted by "Jean T. Anderson" <jt...@bristowhill.com>.

Samuel.Perez@equifax.com wrote:
> 
> would like to know if there is an example of using derby in a j2ee webapp. 

Here are several examples:

Geronimo + Derby: 
http://db.apache.org/derby/integrate/JPetStoreGeronimo.html
Tomcat + Derby: 
http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html
WebSphere + Derby: 
http://db.apache.org/derby/integrate/JPetStoreWebSphere.html

regards,

  -jean