 |
|
|
|
|
|
Offline Ajax with Apache Derby
People love Ajax applications so much that they are willing to use them instead
of their desktop equivalents. The only problem occurs when they fail to have network
access. This is when an offline feature is necessary. Apache Derby is a great option
for enabling offline access to Ajax-powered applications. Learn how to use Apache Derby
as a local data store that can be used to take your Ajax application offline.
|
|
Articles |
|
23 Sep 2008 |
|
| |
Rapid prototyping with Apache Derby and JRuby on Rails
Ruby on Rails has raised the bar in terms of rapid development of data-driven
Web sites. The JRuby project is making Ruby faster and more scalable than ever. One of
the great advantages to running Rails on the Java Virtual Machine is that you can
leverage other Java libraries, like the Apache Derby embedded database. The combination
of Derby, JRuby, and Rails allows for rapid prototyping of dynamic Web applications. Learn how to use these technologies together to help you prototype your next great idea.
|
|
Articles |
|
26 Aug 2008 |
|
| |
Migrating from Apache Tomcat Version 6.0.x to WebSphere Application Server Community Edition V2.1
This article walks you through deploying an application to Tomcat 6.0, then
migrating the code and deploying it to WebSphere Application Server Community Edition
V2.1. The sample application highlights some of the notable differences between the two implementations.
|
|
Articles |
|
06 Aug 2008 |
|
| |
Developing JPA Applications with WebSphere Application Server Community Edition
The Java Persistent API (JPA) makes it easier than ever to design and
develop the persistent part of JEE applications. This tutorial walks you through all
the nuances of this new API, developing a sample application using Eclipse and
WebSphere Application Server Community Edition. Both WebSphere Application Server
Community Edition and Eclipse are available for download at no charge, so you can get started in just a few minutes.
|
|
Tutorials |
|
30 Jul 2008 |
|
| |
What's new in WebSphere Application Server Community Edition V2.1
Explore the new features in WebSphere Application Server Community Edition V2.1,
including the ability to execute Geronimo commands using GShell, create multiple
server assemblies from you own set of servers, and fully control the server through
Expert mode and a new Monitoring portlet. This release improves on what is already the
most powerful open source application server available.
|
|
Articles |
|
29 Jul 2008 |
|
| |
Introduction to BIRT, Part 2
This demo shows how to create a data set from a data source created in Part 1, build an SQL query, build a table, preview a report, and run the report using the Business Intelligence and Reporting Tools (BIRT) viewer.
|
|
Demos |
|
04 Jun 2008 |
|
| |
Use JRuby on Rails and XML to supercharge Ajax with a Java Application Server
The Ruby on Rails framework has handy XML features that will make developing
with and serving database data in XML format to your JavaScript applications easier
than ever. JavaScript also has built-in XML parsing capabilities that make it a snap
to receive and parse data in XML format. But what if you now want to hook into Java
applications without having to deploy another server? That's where JRuby comes in.
JRuby on Rails is the Java implementation of the Ruby on Rails framework and brings the benefits of Rails to Java programming by allowing deployment of Ruby apps to Java application servers. In this tutorial, you'll develop a JRuby on Rails application deployable to a Java application server that will serve database data in XML format to an Ajax client that you'll build for film lovers to manage their online films database. You'll also deploy a couple of Java Server Pages pages on the same Java application server to assist the Ajax client in adding and updating films.
|
|
Tutorials |
|
27 May 2008 |
|
| |
Top 10 Open source tutorials and articles -- October 2009
Check out which Open source tutorials and articles developerWorks readers
found most interesting last month.
|
|
|
|
08 Feb 2008 |
|
| |
New to Open source
This guide places all the basics of open source in context to help you get started in the most wide-ranging, growing, and dynamic field of software development today. The open source zone is your source for how-to information, tools, and project updates to help you develop with open source technologies and use them with IBM's products. Topic areas include Eclipse, Apache, Derby/Cloudscape, Linux, scripting languages such as PHP, Perl, and Python, as well as broader discussions on licensing and open source development.
|
|
|
|
22 Aug 2007 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 6
Learn how to build a self-contained, deployable embedded Apache Derby database application.
In this article, the last one in this series, you map database tables into Java classes, write Data Access
Objects (DAOs), and combine them with your business logic classes into a complete database
application. You also learn how to package your application with the necessary
Derby database files to create a single compressed file that contains everything necessary
for your database application.
|
|
Articles |
|
14 Aug 2007 |
|
| |
Develop a simple Web application with Apache Wicket and Apache Geronimo
Apache Wicket is an innovative Java Web application framework that was
introduced a couple of years ago. It helps simplify Web application development by
clearly separating the roles of developers and designers. It lets you remove logical
code from the view layer, eliminating the need for JavaServer Pages (JSP), providing
a simple plain old Java object (POJO)-centric mode of development, and removing much
of the need for XML and other configuration file formats. In this tutorial, learn
how to set up your system to develop a simple Web application with Wicket, using
Apache Geronimo as your application server and Apache Derby as the embedded
database.
|
|
Tutorials |
|
10 Jul 2007 |
|
| |
Developing with Apache Derby — Hitting the Trifecta: Java database development with Derby, Part 5
Learn about the advanced features available when using prepared statements
with your Apache Derby database application. First, use the ij tool to dynamically
execute a PreparedStatement to enable rapid prototyping. Next, stream data into a
PreparedStatement to efficiently insert large quantities of data into a particular
column. Then use the ParameterMetaData object to obtain information, including
vendor-specific implementation details, about the individual parameters in your
PreparedStatement.
|
|
Articles |
|
22 May 2007 |
|
| |
Apache
Derby project resources
Find complete listings of the articles, tutorials, project info, and news you
need to stay up to date on developing with Apache Derby projects.
|
|
|
|
22 May 2007 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 4
Learn about SQL cursors and how you can use them to perform dynamic data
modification in an Apache Derby database. You can use SQL cursors both explicitly by
using the ij tool or implicitly by calling the appropriate Java methods. By
mastering this functionality, you can write Java applications that can selectively
modify data for your business applications.
|
|
Articles |
|
17 Apr 2007 |
|
| |
Training
Start here to find the tutorials and courses you need to stay up to date with open source projects and to keep your skills top notch.
|
|
|
|
05 Apr 2007 |
|
| |
Apache Derby resources from the Web services perspective, Part 3: Manage Apache Derby using Web Services Distributed Management
So far in this three-part tutorial series about the concept of WS-resources and the Web Services Resource Framework (WSRF), you've created a Person resource and learned how to use WS-Notifications with it. This final installment shows you how to look at WS-Resources from a different perspective -- that of a tangible item rather than a set of information. You'll create a Web service to control the Apache Derby database you've been using throughout this project as well as the client that treats Derby as a WS-Resource.
|
|
Tutorials |
|
23 Mar 2007 |
|
| |
Real-world Apache Derby, Part 4: Wrapping up: Tracking SOX compliance
So far, this series has covered the basics of storing and retrieving data in Apache Derby using SQL. This tutorial shows you how to use this knowledge in a straightforward way. In the previous tutorial, you developed a framework that allows you to store and manage Sarbanes-Oxley Act (SOX) compliance documents. Now you'll learn how to enter and report the information.
|
|
Tutorials |
|
20 Feb 2007 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 3
Learn how to modify an Apache Derby database from a Java program. This article builds on the
previous two articles in this series to demonstrate how to create and drop tables as well
as how to insert, update, and delete data in an Apache Derby database from within your Java
applications. This includes using the JDBC Statement and PreparedStatement classes, and using SQL batches for improved performance.
|
|
Articles |
|
20 Feb 2007 |
|
| |
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 3: Communication
In the last two articles in this series, you've discovered how to create a simple Web application using the Google Web Toolkit (GWT) and the Apache Derby relational database. Part 1 focused on using GWT to build the front end for a pizza delivery system called Slicr. In Part 2, you got a demonstration of the creation of a relational database using Derby, and a bare-bones demonstration of a mechanism for converting the database rows to Java objects. Now it gets interesting! In this third article, find out how to get the client and server talking to each other. You'll use the Remote Procedure Call (RPC) framework within GWT to make getting data off the server almost as simple as making a Java method call.
|
|
Articles |
|
13 Feb 2007 |
|
| |
Real-world Apache Derby, Part 3: Portable document storage
Document storage is hot, hot, hot! There has been an explosion of
methodologies and tool sets -- both open source and proprietary -- to fulfill the
demand for quickly locating and searching documents. Enabling technologies like
Alfresco, Sharepoint, or my favorite, TWiki, are powerful, but they have a fairly
high learning curve -- or worse, store the documents in a proprietary format. There
must be an easier way. Let's take Derby and mash it with a new feature in OpenOffice
2.0, the Open Document Format (ODF). Using these tools, you can create a repository
that lets you store, search, and extract ODF documents in a standards-based manner.
Also learn to use the power of the improved XML features of IBM DB2, Version 9 to
make this solution easier to implement.
|
|
Tutorials |
|
06 Feb 2007 |
|
| |
Developing with Apache Derby -- Hitting the trifecta: Java database development with Apache Derby, Part 2
Get a thorough overview on how to issue a simple database query against an Apache Derby database and how to process the selected results. Doing so requires the introduction of three new JDBC classes: Statement, ResultSet, and ResultSetMetaData. Learn how to use these classes with a JDBC database connection to quickly and easily extract data from an Apache Derby database into your own Java application.
|
|
Articles |
|
30 Jan 2007 |
|
| |
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 2: The reliable back end
In this second article in the series on using the Google Web Toolkit (GWT) to build Asynchronous JavaScript + XML (Ajax) applications, learn how to build the Apache Derby database for your Web application, and use it to drive the GWT. Part 1 of this
series introduced you to GWT and demonstrated how you can use it to create a rich-client front end
for a Web application. This time, you'll go behind the scenes and learn about setting up the
back end with your database and the code used to convert the data to a format that
GWT can use. By the end of this article, you'll be ready for the front end and back end
to talk to each other.
|
|
Articles |
|
23 Jan 2007 |
|
| |
Use Apache Derby to develop Eclipse plug-ins
Get a demonstration on how to use resource indexing with the Apache Derby database to develop Eclipse plug-ins. The Derby database embedded in Eclipse allows you to create an SQL database on the client side with no security issues or network problems, such as an unstable connection or high latency. An SQL database and the JDBC API provide an easy way to store information and quickly search previously stored data.
|
|
Articles |
|
16 Jan 2007 |
|
| |
Real-world Apache Derby: Who needs Ajax, anyway?
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.
|
|
Tutorials |
|
19 Dec 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 1
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.
|
|
Articles |
|
12 Dec 2006 |
|
| |
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 1: The fancy front end
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.
|
|
Articles |
|
05 Dec 2006 |
|
| |
Using Apache Derby databases, Part 2: Manage IT services beyond mere deployment
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.
|
|
Articles |
|
14 Nov 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 7
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.
|
|
Articles |
|
07 Nov 2006 |
|
| |
Using Apache Derby databases, Part 1: Managed objects in a converged provider environment
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.
|
|
Articles |
|
31 Oct 2006 |
|
| |
Develop an application with Apache Derby, Apache MyFaces, and Facelets
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.
|
|
Articles |
|
24 Oct 2006 |
|
| |
Apache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with Derby
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.
|
|
Tutorials |
|
17 Oct 2006 |
|
| |
An analysis of the Apache Geronimo PetStore demo
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.
|
|
Articles |
|
03 Oct 2006 |
|
| |
Apache Derby resources from the Web services perspective, Part 1: Derby data as WS-Resources
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.
|
|
Tutorials |
|
03 Oct 2006 |
|
| |
Real-world Apache Derby, Part 1: Apache Derby and OpenOffice.org Calc
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.
|
|
Tutorials |
|
26 Sep 2006 |
|
| |
Apache Geronimo and the Spring Framework, Part 3: Integrating DAO and ORM
Extend the Apache Geronimo application you created in Part 2 of this six-part tutorial series. First you explored the Geronimo application server, the Spring Framework, and Inversion of Control (IoC). Then you learned how to develop, configure, and deploy your first application based on the Spring Framework. In this installment, you'll learn how to let the integrated technologies -- like Spring Java Database Connectivity (JDBC) and Spring Data Access Objects (DAO) APIs -- do the work by reading your application data dynamically from an Apache Derby database. You'll also find out how to integrate Object Relational Mapping (ORM) into your application using iBATIS and appreciate the beauty of dependency injection by modifying the data sources in your application without touching the code.
|
|
Tutorials |
|
19 Sep 2006 |
|
| |
Get a head start with JDBC 4.0 using Apache Derby
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.
|
|
Tutorials |
|
29 Aug 2006 |
|
| |
Configureless J2EE development with Stripes, Apache Derby, and Eclipse
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.
|
|
Tutorials |
|
22 Aug 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 6
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.
|
|
Articles |
|
15 Aug 2006 |
|
| |
Easy database queries with JSTL SQL actions
Author Meenakshi G. Khanna shows you how to use the JSTL 1.1 SQL tag library to incorporate database operations into your JSPs.
|
|
Articles |
|
10 Aug 2006 |
|
| |
Back to basics: Scripting Apache Derby's ij tool
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.
|
|
Articles |
|
18 Jul 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 5
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.
|
|
Articles |
|
11 Jul 2006 |
|
| |
Exposing an Apache Derby stored procedure as a Web service
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.
|
|
Tutorials |
|
20 Jun 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 4
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.
|
|
Articles |
|
06 Jun 2006 |
|
| |
Get started with an open source CMS, Part 7: Enable WebDAV on an open source PHP content management system
In this tutorial, the last in a seven-part series, you'll use the PHP Web-based Authoring and Versioning (WebDAV) client you built in Part 5 to enable WebDAV on an open source content management system (CMS) application called PHP Web
Content Management System (PHPWCMS). The result lets you edit content through WebDAV so you can use WebDAV-enabled applications to access versioned files.
|
|
Tutorials |
|
30 May 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 3
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.
|
|
Articles |
|
12 May 2006 |
|
| |
Use Apache Derby in your OpenLaszlo applications, Part 2: Storing and embedding data
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).
|
|
Tutorials |
|
25 Apr 2006 |
|
| |
Extract database information using Eclipse and BIRT V2.0
The Eclipse Business Intelligence and Reporting Tools (BIRT) project comprises a set of open source plug-ins for Eclipse that you can use to create compelling reports for Web applications. Learn how to install BIRT V2.0, configure it for use with a database, employ its functionality to design dynamic reports and charts, and create templates for future reports.
|
|
Tutorials |
|
25 Apr 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 2
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.
|
|
Articles |
|
18 Apr 2006 |
|
| |
Online banking with Apache Geronimo and Axis2, Part 2: The service: Filling in the guts
Continue getting to the heart of using Apache Geronimo and Axis2 to build a complex Web services application. Part 2 of this three-part tutorial series walks you through setting up the Apache Derby database in preparation for the example online banking application. You'll create a client Web application to call operations implemented in the Web service, and you'll fully test the Web service with the client application.
|
|
Tutorials |
|
28 Mar 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 1
Ready to start using Apache Derby? 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.
|
|
Articles |
|
28 Mar 2006 |
|
| |
Use Apache Derby in your OpenLaszlo applications, Part 1: Supplying data using Derby
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.
|
|
Tutorials |
|
21 Mar 2006 |
|
| |
Improve persistence with Apache Derby and iBATIS, Part 3: Transactions, caching, and dynamic SQL
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.
|
|
Tutorials |
|
07 Mar 2006 |
|
| |
Improve persistence with Apache Derby and iBATIS, Part 2: Data definition in Derby
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.
|
|
Tutorials |
|
21 Feb 2006 |
|
| |
Developing with Apache Derby -- Hitting the Trifecta: Introduction to Apache Derby
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.
|
|
Articles |
|
14 Feb 2006 |
|
| |
Persist arbitrary data to Apache Derby
You can quickly and easily persist simple data to Apache Derby by taking advantage of Java dynamic proxies. In this tutorial, write a persistence API that you can integrate into any database-powered Java application. You use the API to store an application's configuration information and to notify the application when configuration items change.
|
|
Tutorials |
|
31 Jan 2006 |
|
| |
Improve persistence with Apache Derby and iBATIS, Part 1: Initial configuration, semantics, and a simple test
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.
|
|
Tutorials |
|
24 Jan 2006 |
|
| |
Get started with an open source CMS, Part 4: Create an Apache Derby JDBC store adapter
In this tutorial, Part 4 of a developerWorks series, find out how to create a custom store for Jakarta Slide that uses Apache Derby. Build a new database adapter to use Derby as the content and metadata store for Slide using Java Database Connectivity (JDBC), and learn how to handle problems, such as SQL syntax errors and INSERT trigger issues.
|
|
Tutorials |
|
10 Jan 2006 |
|
| |
Introduction to Apache Derby
Get the basic skills you need to use Apache Derby in Java 2 Platform, Enterprise Edition (J2EE) environments where Derby is embedded as a database, such as in Apache Geronimo. This tutorial demonstrates how to embed Derby within Geronimo and how to use Derby and Geronimo to deploy a Web-based e-commerce application. It also helps you become familiar with Derby's system tools, a set of utilities that make application development with Derby easy and straightforward.
|
|
Tutorials |
|
20 Dec 2005 |
|
| |
Create a Web storefront using PHP, Derby and PayPal, Part 3: Setting up orders, shipping, and e-mail
This series chronicles the building of a Web storefront in PHP using PHP Data Objects to access a Derby database. The storefront includes a user manageable shopping cart that allows item purchases using PayPal, and includes the ability for merchants to notify customers via e-mail on successful orders automatically. This final part covers the addition of transactions, a shipping component, and an e-mail notification feature.
|
|
Tutorials |
|
22 Nov 2005 |
|
| |
WebSphere migrations: Migrate from Gluecode SE or Apache Geronimo to WebSphere Application Server Community Edition
For Gluecode Standard Edition or Apache Geronimo users, this article explains how to migrate a J2EE application from either of these open source application server environments to IBM WebSphere Application Server Community Edition 1.0.
|
|
Articles |
|
18 Nov 2005 |
|
| |
Create a Web storefront using PHP and PayPal, Part 2: Collecting payments
This series chronicles the building of a Web storefront in PHP using PHP Data Objects to access a Derby database. The storefront includes a user manageable shopping cart that allows item purchases using PayPal, and includes the ability for merchants to notify customers via e-mail on successful orders automatically. Part 2 covers creating shopping carts and making payments via PayPal.
|
|
Tutorials |
|
15 Nov 2005 |
|
| |
Create a Web storefront using PHP and PayPal, Part 1: Pouring the foundation database
This series chronicles the building of a Web storefront in PHP using PHP Data Objects to access a Derby database. The storefront includes a user manageable shopping cart that allows item purchases using PayPal, and includes the ability for merchants to notify customers via e-mail on successful orders automatically.
|
|
Tutorials |
|
08 Nov 2005 |
|
| |
Eclipse-based tools for Apache Derby
Connect to and browse Apache Derby databases using Eclipse technology and explore the possibilities of using Derby from within Eclipse.
|
|
Articles |
|
27 Oct 2005 |
|
| |
Create a wiki system using Derby, Part 2: Java functions, procedures, and triggers
This two-part tutorial series demonstrates how to create a simple wiki system by embedding Apache Derby in a Web application server. Part 1 gave you an overview of the basic system and regular expressions. This tutorial shows you how to use Java functions, stored procedures, and triggers within the Derby database and outlines the advantages of using these features, including reducing the coupling between database and middle-tier code, minimizing the number of transactions opened, and increasing performance by reducing network traffic.
|
|
Tutorials |
|
25 Oct 2005 |
|
| |
Create a wiki system using Derby, Part 1: The basic system and regular expressions
One form of communication gaining popularity today is the wiki, which enables users -- not just administrators -- to make changes to a Web site directly through the Web interface, automatically adding features, such as formatting and outgoing links. In this two-part series, you use the ability to embed Apache Derby in a Web application server to create a simple wiki system. This first tutorial gives you an overview of the basic system and regular expressions.
|
|
Tutorials |
|
18 Oct 2005 |
|
| |
Isolated unit testing of persistence with Derby
Get help developing your database-driven unit-testing skills. Without isolation and automation, database-driven unit tests can become a maintenance nightmare of sporadic failures and bad test data. The open source Apache Derby database is ideal for completely automating and isolating unit tests, because it offers fast, in-process performance and zero administration. This tutorial gives you step-by-step examples on using Derby to write effective and maintainable unit tests that improve the quality of your application.
|
|
Tutorials |
|
11 Oct 2005 |
|
| |
Build a dynamic Derby application
This tutorial shows you how to build a dynamic Java analysis application that connects to Apache Derby. Explore the dynamic way the database stores new application logic, changing the logic of the database without touching the core client program. And learn about Java archive (JAR) signing and how to provide security for the application that uses hot-swappable .jar files.
|
|
Tutorials |
|
04 Oct 2005 |
|
| |
Build a Derby calendar, Part 3
In this final tutorial of the series, you'll finish
the calendar and reminder application using Java language
and the Apache Derby database. In Part 1 and Part 2 of this
three-part series, you created a basic calendar and reminder
application using a Derby database back end and a GUI and a
Web-based front end. Now that the proof of concept is
complete, you can add a more friendly interface and use
transactions and locking to create a truly multiuser system.
|
|
Tutorials |
|
27 Sep 2005 |
|
| |
IBM WebSphere Developer Technical Journal: What is Gluecode? And why?
This article provides an introduction to Gluecode, describes the components that make up Gluecode, and its relationship with IBM WebSphere Application Server.
|
|
Articles |
|
21 Sep 2005 |
|
| |
Build a Derby calendar, Part 2: Embedding options
Continue learning how to build a calendar and reminder application using the Java language and the Apache Derby database. In Part 2 of this three-part series, you'll turn the classes -- which you created to access the database in Part 1 -- into three different applications using Derby's single-user embedded mode, its multiuser network mode, and a combination of the two from within a Web environment.
|
|
Tutorials |
|
20 Sep 2005 |
|
| |
Build a Derby calendar, Part 1: Understanding JDBC
Build a calendar and reminder application using the Java language and the Apache Derby database in Part 1 of this three-part tutorial series. This tutorial starts by showing you how to install the database and exploring interactions with it through Java Database Connectivity (JDBC). Parts 2 and 3 will examine different options for including Derby in your application and Derby's transactional capabilities as we move from a single-user to a multiuser system. Finally, we'll move to a multimode system that includes a Web interface.
|
|
Tutorials |
|
13 Sep 2005 |
|
| |
An introduction to SQLite, an open source embeddable database
Databases have been an integral part of software applications since the dawn of the commercial application market several decades ago. As crucial as database management systems are, they also come with a large footprint, and considerable overhead in system resources and administration complexity. As software applications become less monolithic and more modular, a new type of database can be a better fit than the larger and more complex traditional database management systems. Embeddable databases run directly in the application process, offer zero-configuration run modes, and have very small footprints. This article introduces the popular SQLite database engine and describes how to use it in application development.
|
|
Articles |
|
21 Jul 2005 |
|
| |
Connect to Apache Derby databases using Python
Using Python to manipulate Derby databases allows us to quickly and easily explore, learn, and prototype relational database applications.
|
|
Articles |
|
19 May 2005 |
|
| |
Building a better J2EE server, the open source way
Gluecode Software is among the growing number of companies that are successfully commercializing open source software, and it has incorporated several up-and-coming open source middleware components -- including Apache Geronimo and Apache Derby, among others -- into a J2EE application server stack. After the recent announcement of IBM's acquisition of Gluecode, we sat down with one of Geronimo's main contributors and CTO of Gluecode, Jeremy Boynes, to hear his perspectives on Geronimo, Java directions, and the state of open source.
|
|
Articles |
|
10 May 2005 |
|
| |
An introduction to backup, restore, and rollforward recovery in IBM Cloudscape/Apache Derby
Ensure the recoverability of your Cloudscape data. Learn how the backup, restore, and rollforward recovery features work in IBM Cloudscape and Apache Derby. Through examples, find out how to restore your databases.
|
|
Articles |
|
17 Feb 2005 |
|
| |
Connect to Apache Derby databases using Jython
Using Jython to manipulate Derby databases allows us to quickly and easily explore, learn, and proptotype relational database applications.
|
|
Articles |
|
17 Feb 2005 |
|
| |
Using IBM Cloudscape V10 with IBM WebSphere Application Server V6
This article describes changes and new features in IBM Cloudscape Version V10, also known as the Derby release, and the process of how to configure IBM WebSphere Application Server to use this new version.
|
|
Articles |
|
26 Jan 2005 |
|
| |
Develop Apache Derby applications in Eclipse
Developing an Apache Derby application involves performing many tasks, such as creating and connecting to a database, writing a Java Database Connectivity (JDBC) client application and stored procedures, and deploying the resulting pieces to a production environment. Discover how you can use the various Eclipse-based Apache Derby tools together to ease your development process.
|
|
Articles |
|
20 Jan 2005 |
|
| |
Derby database development with Apache Ant
The open source Derby database engine provides developers with a powerful new tool for lightweight database development. Derby databases are file system based and portable across different types of systems. Because of this, a common strategy is to create databases at development time and ship them with the binary distribution as opposed to having it created on the fly. In this article, author James Snell introduces a handful of Apache Ant tasks that make it easier to incorporate the building and distribution of Derby databases into an application’s build process.
|
|
Articles |
|
16 Dec 2004 |
|
| |
ADO.NET and Cloudscape
ADO.NET support is available for IBM Cloudscape Version 10.0 and Apache Derby databases with Microsoft's Open Database Connectivity (ODBC), .NET Data Provider, and the IBM DB2 Run-Time client. This article is organized into sections describing Derby/Cloudscape's ADO.NET requirements, setup, and examples.
|
|
Articles |
|
28 Oct 2004 |
|
| |
Develop Perl applications with Apache Derby
Discover how to use Perl, Open Database Connectivity (ODBC), and the Perl Database Interface (DBI) to access data in an Apache Derby database. This article covers the installation of Perl, the ODBC driver, the Perl DBI, and Perl DBD-ODBC modules on Windows, and includes a sample Perl script that demonstrates connecting to, inserting data into, and selecting data from a Derby database.
|
|
Articles |
|
07 Oct 2004 |
|
| |
Connecting PHP Applications to Apache Derby
PHP (PHP:Hypertext Processor) is an open source scripting language for building Web pages. With PHP and Open Database Connectivity (ODBC) you can dynamically generate Web pages from data stored in IBM Cloudscape and Apache Derby databases. This article shows you how to install and configure PHP on Windows. Also, you'll gain an understanding of the PHP scripting language by learning how to connect to, insert data into, and select data from a Derby database.
|
|
Articles |
|
30 Sep 2004 |
|
| |
ODBC programming using Apache Derby
This article introduces you to ODBC programming with Apache Derby or IBM Cloudscape as the backend data source. You'll learn how ODBC applications differ from embedded SQL applications, how to set up Apache Derby as an ODBC data source, and how an ODBC application is structured. In addition, the author covers error handling and includes an example.
|
|
Articles |
|
23 Sep 2004 |
|
| |
IBM Cloudscape: Understanding Java class path
IBM Cloudscape is a small-footprint Java database that doesn't require any installation or administration. However, since Cloudscape is implemented entirely in Java, understanding the Java class path is the key to a trouble free installation. This article explains what Java class path is, how to set it for different versions of Cloudscape, and how to troubleshoot any problems that might occur.
|
|
Articles |
|
15 Sep 2004 |
|
| |
Functionality from the DB2 UDB SQL Reference for Cross-Platform Development not supported by Derby
Some of the functionality described in the IBM> DB2 Universal Database (DB2 UDB) SQL Reference for Cross-Platform Development Version 1.1 is not supported by Derby. This article lists these differences. This comparison was developed by reviewing the DB2 UDB SQL Reference for Cross-Platform Development Version 1.1 documentation against Derby functionality.
|
|
Articles |
|
09 Sep 2004 |
|
| |
