You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2009/12/19 12:00:02 UTC
[Db-derby Wiki] Update of "WorkingWithDerby" by fredric9
Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.
The "WorkingWithDerby" page has been changed by fredric9.
The comment on this change is: Netbeans 5.5 not available.
http://wiki.apache.org/db-derby/WorkingWithDerby?action=diff&rev1=44&rev2=45
--------------------------------------------------
## page was renamed from DerbyInstruction
-
The UsesOfDerby Wiki page lists products (and projects) that use or work with Derby. This page lists actual resources that show how to use a given product or technology with Derby. Please add your entries to the table listed below.
- ''The Apache Derby project encourages the community to add links to this page, but does not endorse or warrant those external links.''
+ ''The Apache Derby project encourages the community to add links to this page, but does not endorse or warrant those external links.''
## Please leave the anchors in place below -- pages on the Derby web site need to be updated to not reference them
- <<Anchor(Tutorials)>>
- <<Anchor(Courses)>>
- <<Anchor(Examples)>>
- <<Anchor(Demos)>>
+ <<Anchor(Tutorials)>> <<Anchor(Courses)>> <<Anchor(Examples)>> <<Anchor(Demos)>>
+ ||Title ||Format ||Topics ||Description ||
+ ||[[http://db.apache.org/derby/binaries/DerbyAndRedHatAppServer.pdf|Apache Derby and Red Hat Application Server: JOnAS Integration]] ||Article ||Red Hat App Server, JOnAS ||Shows how to configure and run Derby with the Red Hat Application Server. ||
+ ||[[http://db.apache.org/derby/papers/fortune_tut.html|Apache Derby Fortune Server Tutorial]] ||Tutorial ||SQL functions, Tomcat 5.0.28 ||From !ApacheCon US 2004, teaches the basics of embedded Derby and shows a couple ways to integrate it with other Apache products, including how to create SQL functions that use the Jakarta Mathematics and Regexp libraries and how to embed Derby in Tomcat 5.0.28. ||
+ ||[[http://db.apache.org/derby/papers/DerbyTut/index.html|Apache Derby Tutorial]] ||Tutorial ||Installation, ij, embedded, Network Server ||Introduces Derby basics to new users, including how to install the software, how to use ij, and how to use Derby in embedded mode and with the Network Server. ||
+ ||[[http://www.ibm.com/developerworks/db2/library/techarticle/dm-0509cline/index.html|Build Web applications with Eclipse, WTP, and Derby]] ||Article ||Eclipse, WTP, Derby plug-ins ||Shows how to use WTP and the Derby eclipse plug-ins, and features a sample application that uses JSPs, !JavaServer Pages Standard Tag Library (JSTL), and Servlets. ||
+ ||[[http://objectstyle.org/confluence/display/CAY/Cayenne+PetStore|Cayenne PetStore]] ||Article ||Cayenne, Struts ||Shows how to implement the classic Petstore Java application with Cayenne and Struts. ||
+ ||[[http://www.ibm.com/developerworks/db2/library/techarticle/dm-0607cline/|Cloudscape and Ajax -- An example: Create an embedded database and Web server application]] ||Article ||Ajax, !JavaScript ||Shows how to create an Address Book Web application using Derby and Ajax. ||
+ ||[[http://www.ibm.com/developerworks/edu/dm-dw-dm-0412kubasta-i.html?S_TACT=104AHW11;S_CMP=LIB|Cloudscape Detective]] ||Tutorial ||Relational databases ||Introduces users to relational database concepts using Derby. ||
+ ||[[http://mail-archives.apache.org/mod_mbox/db-derby-user/200612.mbox/<45...@CharlieKelly.com>|Configuration files for JBoss using Derby]] ||Mail list ||JBoss ||Shows how to configure JBoss to use Derby ||
+ ||[[http://developers.sun.com/javadb/overview/product_tour/|Database-in-a-browser]] ||Demo ||Ajax, Java plug-in !LiveConnect ||!ApacheCon US 2005 demo that shows how a database embedded in a browser can be used to persist data from a tax return being created either online or offline. ||
+ ||[[http://coffeecode.net/archives/16-Apache-Derby-tutorial-OSCON-2005-materials.html|Deep Dive with Apache Derby: Perl, PHP, and Python]] ||Tutorial ||Perl, PHP, Python ||From OSCON 2005, highlights non-java access to Derby databases. ||
+ ||[[http://wiki.apache.org/db-derby/DerbyAndPerlWithDBDJDBC|Derby and Perl with DBD::JDBC]] ||Derby Wiki ||Perl ||How to use Derby with Perl and DBD. ||
+ ||[[http://wiki.apache.org/db-derby/DerbySQLroutines|DerbySQLroutines]] ||Derby Wiki ||SQL functions and procedures ||Describes how to implement SQL routines -- functions and procedures -- in java. Feel free to add examples! ||
+ ||[[http://www.netbeans.org/kb/docs/ide/java-db.html|Derby Tutorial -- NetBeans 6.5]] ||Tutorial ||!NetBeans 6.5, Java DB, DB GUI, SQL scripts, development tools ||Demonstrates how to set up a connection to Sun's Java DB database (applies to Derby as well) in !NetBeans IDE 6.5. Once a connection is made, you can begin working with the database in the IDE, allowing you to create tables, populate them with data, run SQL statements and queries, and more. ||
+ ||[[http://rifers.org/wiki/display/RIFE/Easy+DB+setup+with+Apache+Derby|Easy DB setup with Apache Derby]] ||Blog ||RIFE ||Shows how to setup RIFE to use Derby. ||
+ ||[[http://www.eclipse.org/birt/tutorial/basic/|Eclipse BIRT tutorial]] ||Tutorial ||Eclipse, BIRT ||Includes the Derby engine+embedded driver and a sample Derby database. ||
+ ||[[http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html|Embedding Apache Derby in Tomcat and creating an iBATIS JPetStore Demo]] ||Article ||iBATIS, Tomcat 5.5 ||Shows how to setup and deploy the JPetStore 4.0 web application using Derby as the database, iBATIS as the persistence layer, and Tomcat as the J2EE server. ||
+ ||HibernateHelp ||Derby Wiki ||Hibernate ||Various tips on using Derby with Hibernate. ||
+ ||[[http://nagpals.com/blog/default.cfm/2006/9/19/Installing-Apache-Derby-Database-on-ColdFusionMX-702|Installing Apache Derby Database on ColdFusionMX 7.0.2]] ||Blog ||!ColdFusion ||Shows how to setup embedded Derby to work with ColdFusion ||
+ ||[[http://www.techbookreport.com/tutorials/apachederby.html|Introduction To Apache Derby - Java Database]] ||Tutorial ||Installation, CLI (ij), JDBC (embedded only) ||Introductory tutorial describing Derby and showing how to get started using the embedded driver. ||
+ ||[[http://www.regdeveloper.co.uk/2006/11/08/java_database_derby/|Java databasing with Derby]] ||Tutorial ||Installation, ij, embedded, JDBC ||This article shows how to embed Derby 10.2 in a java application. ||
+ ||[[http://www.onjava.com/pub/a/onjava/2006/08/02/jjdbc-4-enhancements-in-java-se-6.html|JDBC 4.0 Enhancements in Java SE 6]] ||Article ||JDBC ||An article on new JDBC 4.0 features which uses Derby as the example database. ||
+ ||[[http://javaevangelist.blogspot.com/2007/01/ldap-authentication-with-apache-derby.html|LDAP Authentication with Apache Derby]] ||Blog ||Authentication, LDAP ||How to use LDAP authentication with Apache Derby ||
+ ||[[http://objectinnovations.com/CourseOutlines/168.html|Object Innovations JDBC Course]] ||Course ||JDBC ||Commercial courseware that covers the fundamentals of database programming in Java using JDBC. Derby is the default database. ||
+ ||[[http://www.eactscongenitaldb.org/docs/OpenOffice_and_JDBC_for_data_access|OpenOffice and JDBC for data access]] ||Article ||!OpenOffice, GUI ||Explains how to access a Derby database directly from !OpenOffice using a JDBC connection. ||
+ ||[[http://chaoticjava.com/posts/out-of-the-box-database-notifications-jmx-and-derby-in-java-6/|Out-of-the-box database notifications: JMX and Derby in Java 6]] ||Article ||JMX ||Using a Derby database as a JMX observable object to provide alerts about significant data changes. ||
+ ||[[http://db.apache.org/derby/integrate/db_torque.html|Running the Torque Tutorial on Derby]] ||Tutorial ||Torque ||Summarizes the changes required to run the [[http://db.apache.org/torque/releases/torque-3.2/runtime/tutorial/index.html|Torque 3.2 tutorial]] on Derby 10.1 using the Derby embedded JDBC driver. ||
+ ||[[http://today.java.net/pub/a/today/2007/01/16/synchronizing-web-client-database.html|Synchronizing a Web Client Database: LocalCalendar and Google Calendar]] ||Article ||Synchronization ||Shows how to implement a local calendar that gets synchronized to a central store. ||
+ ||[[http://www.developers.net/external/1643|Use Apache Derby in your OpenLaszlo applications, Part 2: Storing and embedding data]] ||Tutorial ||!OpenLazlo ||Shows how to insert, update, and delete into a Derby database using the OpenLazlo markup language. ||
+ ||[[http://db.apache.org/derby/integrate/JPetStoreGeronimo.html|Using Apache Derby with iBATIS JPetStore 4 running on the Geronimo J2EE server]] ||Article ||iBATIS, Geronimo ||Shows how to setup and deploy the JPetStore 4.0 web application using Derby as the database, iBATIS as the persistence layer, and Geronimo as the J2EE server. ||
+ ||[[http://db.apache.org/derby/integrate/JPetStoreWebSphere.html|Using Apache Derby with iBATIS JPetStore 4 on the WebSphere Server]] ||Article ||iBATIS, !WebSphere ||Shows how to setup and deploy the JPetStore 4.0 web application using Derby as the database, iBATIS as the persistence layer, and !WebSphere as the J2EE server. ||
+ ||[[http://db.apache.org/derby/integrate/db_ddlutils.html|Using DdlUtils to Migrate Databases to Derby]] ||Tutorial ||!DdlUtils, Schema management, data migration ||Shows how to use Derby with [[http://db.apache.org/ddlutils/|DdlUtils]], which provides utilities for creating and working with Database Definition (DDL) files and for exporting and importing data in XML format. ||
+ ||[[http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javadb/|Using Java DB in Desktop Applications]] ||Article ||Desktop applications ||Features an example application (Address Book) which demonstrates how to work with Java DB (Sun's distribution of Apache Derby) as an embedded database within desktop Java technology applications. ||
+ ||[[http://db.apache.org/derby/integrate/JPOX_Derby.html|Using JPOX JDO with Derby]] ||Article ||JPOX JDO, Apache JDO ||Provides an example that uses JPOX JDO to persist and retrieve data to and from Apache Derby. ||
+ ||[[http://db.apache.org/derby/integrate/SQuirreL_Derby.html|Using SQuirreL SQL Client with Derby]] ||Article ||SQuirreL SQL, GUIs ||Shows how to set up SQuirreL to access Derby databases via the Derby Embedded Driver and Client Drivers with the 10.1 version of Derby. ||
+ ||[[http://today.java.net/pub/a/2007/03/20/javadb-end-to-end-security.html|JavaDB End-to-End Security]] ||Article ||Security ||How to make Java DB (Derby) 10.2 more secure, including: Database encryption, connection authentication, SQL authorization, securing the environment (Java Security Manager) ||
+ ||[[http://developers.sun.com/learning/javaoneonline/j1sessn.jsp?sessn=TS-45170&yr=2007&track=3|JavaDB Performance]] ||Slide show ||Performance ||This presentation gives an overview of how to configure Java DB (Derby) to achieve optimal performance while being able to handle failure scenarios without losing data. ||
+ ||[[http://www.papercut.com/anonftp/pub/open-source/apache-derby/ApacheDerbyAJUGPresentation.pdf|Using Apache Derby in the real world]] ||Slide show ||Introduction and usage domains ||Slides used to present Derby and its use in the real world. Presentation held at the Australian Java User's Group meeting in Melbourne. (also [[http://docs.google.com/Present?docid=dcz4c74g_82nr92vgnt&skipauth=true|HTML version here]]) ||
- || Title || Format || Topics || Description ||
- || [[http://db.apache.org/derby/binaries/DerbyAndRedHatAppServer.pdf|Apache Derby and Red Hat Application Server: JOnAS Integration]] || Article || Red Hat App Server, JOnAS || Shows how to configure and run Derby with the Red Hat Application Server.||
- || [[http://db.apache.org/derby/papers/fortune_tut.html|Apache Derby Fortune Server Tutorial]] || Tutorial || SQL functions, Tomcat 5.0.28 || From !ApacheCon US 2004, teaches the basics of embedded Derby and shows a couple ways to integrate it with other Apache products, including how to create SQL functions that use the Jakarta Mathematics and Regexp libraries and how to embed Derby in Tomcat 5.0.28. ||
- || [[http://db.apache.org/derby/papers/DerbyTut/index.html|Apache Derby Tutorial]] || Tutorial || Installation, ij, embedded, Network Server || Introduces Derby basics to new users, including how to install the software, how to use ij, and how to use Derby in embedded mode and with the Network Server. ||
- ||[[http://www.ibm.com/developerworks/db2/library/techarticle/dm-0509cline/index.html|Build Web applications with Eclipse, WTP, and Derby]]||Article|| Eclipse, WTP, Derby plug-ins || Shows how to use WTP and the Derby eclipse plug-ins, and features a sample application that uses JSPs, !JavaServer Pages Standard Tag Library (JSTL), and Servlets.||
- || [[http://objectstyle.org/confluence/display/CAY/Cayenne+PetStore|Cayenne PetStore]] || Article || Cayenne, Struts || Shows how to implement the classic Petstore Java application with Cayenne and Struts.||
- || [[http://www.ibm.com/developerworks/db2/library/techarticle/dm-0607cline/|Cloudscape and Ajax -- An example: Create an embedded database and Web server application]] || Article || Ajax, !JavaScript || Shows how to create an Address Book Web application using Derby and Ajax. ||
- || [[http://www.ibm.com/developerworks/edu/dm-dw-dm-0412kubasta-i.html?S_TACT=104AHW11;S_CMP=LIB|Cloudscape Detective]] || Tutorial || Relational databases || Introduces users to relational database concepts using Derby. ||
- || [[http://mail-archives.apache.org/mod_mbox/db-derby-user/200612.mbox/%3c45743323.4000706@CharlieKelly.com%3e|Configuration files for JBoss using Derby]] || Mail list || JBoss || Shows how to configure JBoss to use Derby ||
- ||[[http://developers.sun.com/javadb/overview/product_tour/|Database-in-a-browser]] || Demo || Ajax, Java plug-in !LiveConnect || !ApacheCon US 2005 demo that shows how a database embedded in a browser can be used to persist data from a tax return being created either online or offline. ||
- || [[http://coffeecode.net/archives/16-Apache-Derby-tutorial-OSCON-2005-materials.html|Deep Dive with Apache Derby: Perl, PHP, and Python]] || Tutorial || Perl, PHP, Python || From OSCON 2005, highlights non-java access to Derby databases. ||
- || [[http://wiki.apache.org/db-derby/DerbyAndPerlWithDBDJDBC|Derby and Perl with DBD::JDBC]] || Derby Wiki || Perl || How to use Derby with Perl and DBD. ||
- || [[http://wiki.apache.org/db-derby/DerbySQLroutines|DerbySQLroutines]] || Derby Wiki || SQL functions and procedures || Describes how to implement SQL routines -- functions and procedures -- in java. Feel free to add examples!||
- || [[http://www.netbeans.org/kb/55/derby-demo.html|Derby Tutorial -- NetBeans 5.5]] || Tutorial || !NetBeans 5.5, GUI, development tools || Derby support is included in [[http://www.netbeans.org/|NetBeans]] (starting with version 5.0). This tutorial shows how to use the Derby (or Java DB) module in !NetBeans 5.5.||
- || [[http://www.netbeans.org/kb/docs/ide/java-db.html|Derby Tutorial -- NetBeans 6.5]] || Tutorial || !NetBeans 6.5, Java DB, DB GUI, SQL scripts, development tools || Demonstrates how to set up a connection to Sun's Java DB database (applies to Derby as well) in !NetBeans IDE 6.5. Once a connection is made, you can begin working with the database in the IDE, allowing you to create tables, populate them with data, run SQL statements and queries, and more.||
- || [[http://rifers.org/wiki/display/RIFE/Easy+DB+setup+with+Apache+Derby|Easy DB setup with Apache Derby]] || Blog || RIFE || Shows how to setup RIFE to use Derby. ||
- || [[http://www.eclipse.org/birt/tutorial/basic/|Eclipse BIRT tutorial]] || Tutorial || Eclipse, BIRT || Includes the Derby engine+embedded driver and a sample Derby database.||
- || [[http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html|Embedding Apache Derby in Tomcat and creating an iBATIS JPetStore Demo]] || Article || iBATIS, Tomcat 5.5 || Shows how to setup and deploy the JPetStore 4.0 web application using Derby as the database, iBATIS as the persistence layer, and Tomcat as the J2EE server.||
- || HibernateHelp || Derby Wiki || Hibernate || Various tips on using Derby with Hibernate.||
- || [[http://nagpals.com/blog/default.cfm/2006/9/19/Installing-Apache-Derby-Database-on-ColdFusionMX-702|Installing Apache Derby Database on ColdFusionMX 7.0.2]] || Blog || !ColdFusion || Shows how to setup embedded Derby to work with ColdFusion ||
- || [[http://www.techbookreport.com/tutorials/apachederby.html|Introduction To Apache Derby - Java Database]] || Tutorial || Installation, CLI (ij), JDBC (embedded only) || Introductory tutorial describing Derby and showing how to get started using the embedded driver. ||
- || [[http://www.regdeveloper.co.uk/2006/11/08/java_database_derby/|Java databasing with Derby]] || Tutorial || Installation, ij, embedded, JDBC ||This article shows how to embed Derby 10.2 in a java application. ||
- || [[http://www.onjava.com/pub/a/onjava/2006/08/02/jjdbc-4-enhancements-in-java-se-6.html|JDBC 4.0 Enhancements in Java SE 6]] || Article || JDBC || An article on new JDBC 4.0 features which uses Derby as the example database. ||
- || [[http://javaevangelist.blogspot.com/2007/01/ldap-authentication-with-apache-derby.html|LDAP Authentication with Apache Derby]] || Blog || Authentication, LDAP || How to use LDAP authentication with Apache Derby ||
- || [[http://objectinnovations.com/CourseOutlines/168.html|Object Innovations JDBC Course]] || Course || JDBC || Commercial courseware that covers the fundamentals of database programming in Java using JDBC. Derby is the default database.||
- ||[[http://www.eactscongenitaldb.org/docs/OpenOffice_and_JDBC_for_data_access|OpenOffice and JDBC for data access]] || Article || !OpenOffice, GUI || Explains how to access a Derby database directly from !OpenOffice using a JDBC connection.||
- || [[http://chaoticjava.com/posts/out-of-the-box-database-notifications-jmx-and-derby-in-java-6/|Out-of-the-box database notifications: JMX and Derby in Java 6]] || Article || JMX || Using a Derby database as a JMX observable object to provide alerts about significant data changes.||
- || [[http://db.apache.org/derby/integrate/db_torque.html|Running the Torque Tutorial on Derby]] || Tutorial || Torque || Summarizes the changes required to run the [[http://db.apache.org/torque/releases/torque-3.2/runtime/tutorial/index.html|Torque 3.2 tutorial]] on Derby 10.1 using the Derby embedded JDBC driver.||
- ||[[http://today.java.net/pub/a/today/2007/01/16/synchronizing-web-client-database.html|Synchronizing a Web Client Database: LocalCalendar and Google Calendar]]|| Article || Synchronization || Shows how to implement a local calendar that gets synchronized to a central store.||
- || [[http://www.developers.net/external/1643|Use Apache Derby in your OpenLaszlo applications, Part 2: Storing and embedding data]] || Tutorial || !OpenLazlo || Shows how to insert, update, and delete into a Derby database using the OpenLazlo markup language. ||
- || [[http://db.apache.org/derby/integrate/JPetStoreGeronimo.html|Using Apache Derby with iBATIS JPetStore 4 running on the Geronimo J2EE server]] || Article || iBATIS, Geronimo || Shows how to setup and deploy the JPetStore 4.0 web application using Derby as the database, iBATIS as the persistence layer, and Geronimo as the J2EE server.||
- || [[http://db.apache.org/derby/integrate/JPetStoreWebSphere.html|Using Apache Derby with iBATIS JPetStore 4 on the WebSphere Server]] || Article || iBATIS, !WebSphere || Shows how to setup and deploy the JPetStore 4.0 web application using Derby as the database, iBATIS as the persistence layer, and !WebSphere as the J2EE server.||
- || [[http://db.apache.org/derby/integrate/db_ddlutils.html|Using DdlUtils to Migrate Databases to Derby]] || Tutorial || !DdlUtils, Schema management, data migration || Shows how to use Derby with [[http://db.apache.org/ddlutils/|DdlUtils]], which provides utilities for creating and working with Database Definition (DDL) files and for exporting and importing data in XML format.||
- || [[http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javadb/|Using Java DB in Desktop Applications]] || Article || Desktop applications || Features an example application (Address Book) which demonstrates how to work with Java DB (Sun's distribution of Apache Derby) as an embedded database within desktop Java technology applications. ||
- || [[http://db.apache.org/derby/integrate/JPOX_Derby.html|Using JPOX JDO with Derby]] || Article || JPOX JDO, Apache JDO || Provides an example that uses JPOX JDO to persist and retrieve data to and from Apache Derby.||
- || [[http://db.apache.org/derby/integrate/SQuirreL_Derby.html|Using SQuirreL SQL Client with Derby]] || Article || SQuirreL SQL, GUIs || Shows how to set up SQuirreL to access Derby databases via the Derby Embedded Driver and Client Drivers with the 10.1 version of Derby.||
- || [[http://today.java.net/pub/a/2007/03/20/javadb-end-to-end-security.html|JavaDB End-to-End Security]] || Article || Security || How to make Java DB (Derby) 10.2 more secure, including: Database encryption, connection authentication, SQL authorization, securing the environment (Java Security Manager) ||
- || [[http://developers.sun.com/learning/javaoneonline/j1sessn.jsp?sessn=TS-45170&yr=2007&track=3|JavaDB Performance]] || Slide show || Performance || This presentation gives an overview of how to configure Java DB (Derby) to achieve optimal performance while being able to handle failure scenarios without losing data. ||
- || [[http://www.papercut.com/anonftp/pub/open-source/apache-derby/ApacheDerbyAJUGPresentation.pdf|Using Apache Derby in the real world]] || Slide show || Introduction and usage domains || Slides used to present Derby and its use in the real world. Presentation held at the Australian Java User's Group meeting in Melbourne. (also [[http://docs.google.com/Present?docid=dcz4c74g_82nr92vgnt&skipauth=true|HTML version here]])||
-