| View: | [ 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 ] |
| Articles Tutorials |
- Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 1 by Robert Brunner - [Clicks: 262]
Climb aboard! This article begins your journey of writing Java applications that work with the Apache Derby database. Learn how to connect to an embedded Derby database by using a Derby embedded Java Database Connectivity (JDBC) driver. Plus find out about database metadata and how to properly handle SQL errors and warnings in your Java application that may be generated by Derby.
[Includes sample code]
http://www-128.ibm.com/developerworks/library/os-ad-trifecta9/index.html - Dec, 2006 - Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 1: The fancy front end by Noel Rappin - [Clicks: 199]
Google Web Toolkit (GWT) is a major step forward in the creation of dynamic JavaScript applications that run in users' Web browsers. Using GWT, developers can design the user interface (UI) and event model using familiar Java techniques while GWT does the hard work of making the code friendly for all the major browsers. Learn the basics of GWT in this first article in a series, including how GWT lets you create an Asynchronous JavaScript + XML (Ajax) application and still write your code in the Java language. Discover how to create and run a small sample GWT application -- a hot new Web 2.0 business called Slicr, which sells pizza online.
http://www-128.ibm.com/developerworks/opensource/library/os-ad-gwt1/ - Dec, 2006 - Using Apache Derby databases, Part 2: Manage IT services beyond mere deployment by Stephen B. Morris - [Clicks: 55]
Rolling out increasingly advanced software offerings and the demands of more technically savvy users exacerbate the problem of IT service provision. Simply deploying software, like Apache Derby databases, and hoping for resiliency is no longer sufficient. Management needs to be automated. In this article -- the second in a two-part series -- find out how IBM autonomic computing technology, particularly the IBM Autonomic Integrated Development Environment (AIDE) toolkit, may be an effective solution. Learn how you can use this technology with Apache Derby to create the basis of a converged provider environment.
http://www-128.ibm.com/developerworks/library/os-ad-mgobj2/index.html - Nov, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 7 by Robert Brunner - [Clicks: 65]
With this article you've reached an important point in mastering fundamental database concepts as they relate to the Apache Derby database. This article reviews how to modify an SQL query to group related rows together to provide summary statistics database information. Then it introduces the concept of a view, which can be used to simplify database application development by creating a virtual table that represents the results of an SQL query. Finally, you'll learn about database indexes, which you can use to locate specific table rows. After you've mastered these advanced database concepts, you'll be well positioned to begin developing Java database applications with Apache Derby.
[Includes sample code]
http://www-128.ibm.com/developerworks/library/os-ad-trifecta8/index.html - Nov, 2006 - Using Apache Derby databases, Part 1: Managed objects in a converged provider environment by Stephen B. Morris - [Clicks: 33]
This two-part series addresses the importance of the automated management of Apache Derby databases using (as an example) IBM autonomic computing touchpoint technology and Web Services Distributed Management (WSDM). This article, Part 1, introduces the growing need for automated IT management, which is facilitated by the centralization and consolidation of applications, data centers, and front- and back-office functions. Discover how you can use Derby as a managed element, including working with the database's unified utilization and management requirements and how using FCAPS can help you design an IT management solution.
http://www.ibm.com/developerworks/library/os-ad-mgobj/index.html - Oct, 2006 - Develop an application with Apache Derby, Apache MyFaces, and Facelets by Susan L. Cline - [Clicks: 488]
Learn how to develop a JavaServer Faces (JSF) application using Apache Derby, Apache MyFaces, and Facelets. The ready-to-download sample application in this article uses a Model-View-Controller (MVC) architecture to illustrate the power of the MyFaces components and the ease of developing with Apache Derby and the latest view technology, Facelets.
[Includes sample code]
http://www-128.ibm.com/developerworks/library/os-ad-derbymyfaces/index.html - Oct, 2006 - An analysis of the Apache Geronimo PetStore demo by J. Jeffrey Hanson - [Clicks: 409]
Want practical instructions for building an enterprise application that you can use in your business? The iBATIS PetStore application is an example application that originated from the Sun Java BluePrints program. The application illustrates how to use the capabilities of the iBATIS persistence framework, the all-Java Apache Derby database, and Java Platform, Enterprise Edition (Java EE) to develop a simple cross-platform enterprise application. This article provides tips and techniques that you can use to exploit the features of iBATIS, Derby, and Apache Geronimo to construct a flexible and usable implementation of the PetStore application.
[Includes sample code]
http://www-128.ibm.com/developerworks/java/library/os-ag-petstore/index.html - Oct, 2006 - Try on Derby for size by Jeff Hanson - [Clicks: 95]
Jeff Hanson illustrates how to get started using the Apache Derby database. In this tutorial, he covers installation, use as both an embedded database engine and as a network server, creation and deletion of a database, and more.
[Includes sample code]
http://www.javaworld.com/javaworld/jw-09-2006/jw-0929-derby.html - Sep, 2006 - Configureless J2EE development with Stripes, Apache Derby, and Eclipse by B.J. Allmon - [Clicks: 189]
In the search for more portable and lightweight enterprise solutions, Java 2 Platform, Enterprise Edition (J2EE) developers can leverage both Stripes and Apache Derby for rapid, lightweight, J2EE development. Learn how to develop, package, and deploy a simple Stripes application that performs Create, Retrieve, Update, and Delete (CRUD) operations on a Derby database.
[Formats: html, pdf]
http://www.ibm.com/developerworks/edu/os-dw-os-ad-configureless.html - Aug, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 6 by Robert Brunner - [Clicks: 68]
Along with creating a database schema and populating tables with data, being able to selectively modify data is one of the most important skills necessary for a database developer. This article teaches you how to selectively delete or update data in an existing table and how to modify the structure of an existing table. To perform data modifications on a more complex database schema, you'll learn about embedded subqueries, both scalar and table, with data update and data insert operations. You'll also find out how to delete and modify data in complex schemas using the Apache Derby database.
http://www-128.ibm.com/developerworks/library/os-ad-trifecta7/index.html - Aug, 2006 - Cloudscape and Ajax - An example by Susan L. Cline - [Clicks: 39]
Cloudscape and Derby are great database servers for Ajax applications -- particularly if the client and server are on the same host -- due to their zero admin requirements and ability to be embedded. This article explains all the steps and requirements to create an embedded database and Web server application. The source code and a ready to run application provided as a zip file are available for download. The Derby or Cloudscape database acts as the data repository, the Jetty Web server or servlet container handles the HTTP requests, and Ajax technologies are used to enhance the presentation and responsiveness of the client.
[Includes sample code]
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0607cline/ - Jul, 2006 - Back to basics: Scripting Apache Derby's ij tool by Nicholas Chase - [Clicks: 58]
Everybody's building Web applications these days. But what if you just want a little bit of data? Do you really need to go to the trouble of creating a whole application? Doesn't Derby provide a tool for that? Well, of course it does. Derby's main command line tool, ij, is designed for just that: manipulating and retrieving the data in the database from the command line. But ij is more than just a place to enter select statements. It provides a fairly comprehensive suite of tools and commands, such as the use and manipulation of cursors. This article explains the use of ij's advanced scripting capabilities. You may never go back to a Web application again.
http://www-128.ibm.com/developerworks/opensource/library/os-ad-ij/ - Jul, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 5 by Robert Brunner - [Clicks: 48]
The SQL SELECT statement lets you perform queries against an Apache Derby database to select data from multiple tables where certain conditions are valid. This article builds on previous articles in this series to develop even more powerful SELECT statements. Learn how to use the ORDER BY clause and DISTINCT keywords to modify the rows of data selected by a query; how to include basic mathematical operators in a query; and how to work with the primary built-in SQL functions to convert data from one data type to another, to compute aggregate quantities, to perform mathematical operations, to work with date and time data, and to work with character strings.
http://www-128.ibm.com/developerworks/opensource/library/os-ad-trifecta6/ - Jul, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 4 by Robert Brunner - [Clicks: 51]
The Apache Derby software provides a powerful, open source database that can be used as a persistent store for a wide range of database applications. One of the main reasons for this popularity is Apache Derby's query support, which lets you selectively extract columns from specific rows across one or more tables that satisfy some Boolean condition. Learn about Apache Derby's query capabilities and how to use the SELECT statement to perform complex queries.
[Includes sample code]
http://www-128.ibm.com/developerworks/opensource/library/os-ad-trifecta5/ - Jun, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 3 by Robert Brunner - [Clicks: 75]
Learn how to create a self-documenting SQL command file, which you can execute as often as necessary, by placing SQL commands in a text file along with useful comments. After introducing the basic principles of a SQL script file, this article presents three ways to execute a script file. Then you'll review the fundamentals of inserting data into a table using the SQL INSERT statement, including seeing examples that insert ten new rows in different ways. Finally, the article presents a script that automates this INSERT operation and displays the newly inserted data for validation.
[Includes sample code]
http://www-128.ibm.com/developerworks/java/library/os-ad-trifecta4/index.html - May, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 2 by Robert Brunner - [Clicks: 109]
Learn about several basic database concepts, including schemas, tables, and column data types, and get a simple introduction to Structured Query Language (SQL). This article -- focusing on the database developer role -- presents the basic data types you can use to store data in an Apache Derby database, and then you'll use them to create a simple schema with two tables in Apache Derby for a fictitious store. To view the schema contents of a database, you'll use the Apache Derby tool, dblook, to dump the contents of the database. The article wraps up with a brief discussion on dropping tables.
http://www-128.ibm.com/developerworks/opensource/library/os-ad-trifecta3/ - Apr, 2006 - Using Java DB in Desktop Applications by John O'Conner - [Clicks: 119]
This article describes how to download, install, integrate, and deploy Java DB within desktop Java technology applications. A demo application called Address Book demonstrates how to work with Java DB as an embedded database.
http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javadb/ - Mar, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 1 by Robert Brunner - [Clicks: 98]
Want to start using Apache Derby right now? This multi-part series featured in the "Developing with Apache Derby: Hitting the Trifecta" column will get you up and running with the Derby database in no time. This first installment introduces the basic concepts of relational databases with an emphasis on how these topics relate to the Derby database. You'll learn about the ACID test, demonstrated with a simple example, and the ij tool, which you can use to interactively connect to and query an Apache Derby database. Then the rest of this series will help you become a master at working with Apache Derby.
http://www-128.ibm.com/developerworks/opensource/library/os-ad-trifecta2/ - Mar, 2006 - Developing with Apache Derby -- Hitting the Trifecta: Introduction to Apache Derby by Robert Brunner - [Clicks: 72]
At some point, almost every application developer confronts the need to save data. With the growth of Internet- or Web-enabled applications, this need has become even more acute. This installment of the regular column "Developing with Apache Derby -- Hitting the Trifecta" introduces Apache Derby -- an open source, standards-based, small-footprint Java database system -- compares it to other database systems, and discusses issues related to downloading and installing it. By the end of this article, you'll be ready to start developing database applications using Derby.
http://www-128.ibm.com/developerworks/java/library/os-ad-trifecta1/index.html - Feb, 2006
- Real-world Apache Derby: Who needs Ajax, anyway? by Dave Warner - [Clicks: 24]
Asynchronous JavaScript + XML (Ajax) is a dynamite technique for greatly enhancing the user experience on the Web. But it pays to remember that it's only necessary because of the distance between the information source and the browser. Shorten that distance, and much of the need for Ajax goes away. This tutorial -- the second in this series on Apache Derby database use -- offers an alternate technique, one that allows reuse across several different environments.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-ajax.html - Dec, 2006 - Apache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with Derby by David Medinets - [Clicks: 18]
Continue on your mission to make your resources service-oriented architecture (SOA)-friendly. Part 1 of this three-part tutorial series showed you how to use WS-Resources to refer to Apache Derby data and structures from within the inherently stateless environment of Web services. Exposing a database entity through a Web service resource helps you easily provide state and database information through the standardized Web Services Resource Framework (WSRF). But how do you monitor the resource to check for changes? WS-Notification standard Web services. This installment, Part 2, walks you through producing and consuming Web services notifications with Apache Derby and teaches you about WS-Notification, which provides another standardized interface for the monitoring and examination of a Web service.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-ws2.html - Oct, 2006 - Apache Derby resources from the Web services perspective, Part 1: Derby data as WS-Resources by David Medinets - [Clicks: 13]
As the world moves in the direction of service-oriented architecture (SOA), it becomes crucial that all of your resources are SOA friendly. That may mean they produce services, that they consume services, or that they are services. This three-part tutorial series looks at Apache Derby from the perspective of making it Web services-aware. Web services are stateless, but most applications are not. This tutorial, Part 1, shows you how to use WS-Resources to refer to Derby data and structures from within the inherently stateless environment of Web services.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-ws1.html - Oct, 2006 - Real-world Apache Derby, Part 1: Apache Derby and OpenOffice.org Calc by Dave Warner - [Clicks: 27]
Apache Derby signals a sea change in both desktop and Web-based applications. For the first time, that elusive target for developers -- complete data portability -- is easily attainable. This tutorial, the first in a series, shows how you can use Derby as a data store to overcome row-length limitations in OpenOffice.org's Calc and use that program's interface for data analysis while leaving the storage to Derby.
[Formats: html, pdf]
http://www.ibm.com/developerworks/edu/os-dw-os-ad-datastore1.html - Sep, 2006 - Get a head start with JDBC 4.0 using Apache Derby by Victor J. Soderberg - [Clicks: 45]
At the time of this writing, the Java Database Connectivity (JDBC) 4.0 specification is expected to be released from beta testing. It offers developers several enhancements to speed development and create a more object-oriented paradigm with regard to accessing and manipulating data stores. This specification relies heavily on existing technologies, such as Generics, the Metadata Facility, and JDBC RowSet. This tutorial demonstrates some of the new functions of the JDBC 4.0 specification in conjunction with the Apache Derby database.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-jdbc.html - Aug, 2006 - Exposing an Apache Derby stored procedure as a Web service by Viktor Zeltser, Nicholas Chase - [Clicks: 55]
Because of its small footprint, we often think of Apache Derby in terms of an embedded database. But what about in distributed environments, such as Web services or service-oriented architectures (SOAs)? Walk through this tutorial to find out how to build a Derby stored procedure, expose it as a Web service, and access that service.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/opensource/edu/os-dw-os-ad-websvc.html - Jun, 2006 - Use Apache Derby in your OpenLaszlo applications, Part 2: Storing and embedding data by Tyler Anderson - [Clicks: 268]
Since OpenLaszlo's open source announcement, many developers have been using OpenLaszlo to create user-friendly rich Internet applications. Many of these applications require a database solution to have dynamic data fed to them. Because OpenLaszlo runs on Apache Tomcat by default, which supports JavaServer Pages (JSP) and servlets (Java), Apache Derby is an excellent database to use because it can be embedded in such applications and because Derby is written in pure Java code. In this tutorial, you'll build a management interface to the online shopping console created in Part 1. You'll also allow orders to be written to the database and enable management to edit, delete, and add new items to the database via the OpenLaszlo user interface (UI).
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-laszlo2.html - Apr, 2006 - Use Apache Derby in your OpenLaszlo applications, Part 1: Supplying data using Derby by Tyler Anderson - [Clicks: 205]
Since OpenLaszlo's open source announcement, many developers have been using OpenLaszlo to create user-friendly, rich Internet applications. Many of these applications require a database solution to have dynamic data fed to them. Because OpenLaszlo runs on Apache Tomcat by default, which in turn supports JavaServer Pages (JSP) and servlets (Java technology), Apache Derby is an excellent database to use. It can be embedded in such applications, and Derby is written in pure Java code. This tutorial uses an example of an online grocery store to illustrate the power of using OpenLaszlo with Apache Derby.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/opensource/edu/os-dw-os-ad-laszlo1.html - Mar, 2006 - Improve persistence with Apache Derby and iBATIS, Part 3: Transactions, caching, and dynamic SQL by Daniel Wintschel - [Clicks: 712]
This tutorial series has been demonstrating how you can improve persistence in your database-driven Java applications by combining Apache Derby's power as a small-footprint embeddable database with the iBATIS object-relational (OR) mapping framework. In Part 3, the final in the series, learn how iBATIS handles three advanced features of database-driven applications: transactions, caching, and dynamic SQL. Plus, find out how the Data Access Objects (DAO) framework can operate on its own without the Data Mapper framework.
[Formats: html, pdf]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-ibatis3.html - Mar, 2006 - Improve persistence with Apache Derby and iBATIS, Part 2: Data definition in Derby by Daniel Wintschel - [Clicks: 340]
In this second tutorial of a three-part series, learn more about how you can improve persistence in your database-driven Java applications by combining Apache Derby's power as a small-footprint embeddable database with the iBATIS object-relational (OR) mapping framework. In Part 2, you use iBATIS's Data Access Objects (DAO) and Data Mapper to access an application's underlying data structure effectively.
[Formats: HTML, PDF]
http://www-128.ibm.com/developerworks/opensource/edu/os-dw-os-ad-ibatis2.html - Feb, 2006 - Improve persistence with Apache Derby and iBATIS, Part 1: Initial configuration, semantics, and a simple test by Daniel Wintschel - [Clicks: 722]
The iBATIS database-mapping framework -- a popular Java framework for object-relational (OR) mapping -- is now an Apache open source project. This tutorial is the first in a three-part series demonstrating how to combine Apache Derby's power as a small-footprint embeddable database with iBATIS and use this combination to improve persistence in your database-driven Java applications. In Part 1, you learn about iBATIS's advantages as a persistence mechanism and focus on the iBATIS Data Mapper framework.
[Formats: HTML, PDF]
http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-ibatis1.html - Jan, 2006
