Filter by products, topics, and types of content

(448 Products)

(771 Topics)

(20 Industries)

(6 Types)

1 - 41 of 41 results
Show Summaries | Hide Summaries
View Results
Title none Type none Date none
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.
Also available in: Russian   Japanese  
Articles 18 Apr 2006
Build a Derby calendar, Part 3: Using transactions and locking
In this final tutorial of the series, you'll finish the calendar and reminder application using the 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.
Tutorial 27 Sep 2005
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.
Also available in: Russian   Japanese  
Articles 20 Feb 2007
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.
Also available in: Russian   Japanese  
Articles 12 Dec 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.
Also available in: Russian   Japanese  
Articles 12 May 2006
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
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.
Tutorial 20 Dec 2005
Build Web applications with Eclipse, WTP, and Derby
Building dynamic Web applications is easy using Eclipse, the Web Tools Platform (WTP) for Eclipse, Derby, and Apache Tomcat. Learn how to install and configure all of the required Open Source components, and build a complete Web application using JSPs and servlets to store and retrieve information from a Derby database. This article has been updated to reflect the release of WTP 1.0.
Articles 09 Mar 2006
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
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.
Also available in: Chinese   Russian   Japanese  
Articles 16 Jan 2007
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
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
Use Derby in a J2EE Server environment
IBM Cloudscape is a freely available repackaging of the Apache Derby relational database manager. J2EE Servers are middle-ware software based on Sun's Java Enterprise Edition (J2EE) specification that bundle a number of Java Service technologies into an integrated system. Most J2EE applications require that a JDBC-compliant database be integrated with the Server to store information. This article shows how to best fit Cloudscape or Derby into a J2EE environment and has been updated to feature WebSphere Application Server Community Edition as an example.
Articles 15 Jun 2006
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
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.
Also available in: Japanese  
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.
Also available in: Japanese  
Articles 26 Aug 2008
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
Meet the Experts: Why IBM is open sourcing Cloudscape as Derby
At LinuxWorld in San Francisco, IBM announced that it was releasing Cloudscape, a fully relational Java database as open source to the Apache Software Foundation (ASF), which has established it as an incubator project under the name "Derby." This is the latest in a long series of commitments that IBM has made to the open source community. To find out more about the database, and how it fits into both IBM's strategy and the Java application stack, we talked to Jon Prial, IBM Vice President, Marketing, Information Management Software. Here's what he had to say.
Articles 14 Oct 2004
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.
Also available in: Japanese  
Articles 24 Oct 2006
Integrate Cloudscape Version 10 or Derby with Tomcat
Learn to intergrate Cloudscape and Tomcat with three common scenarios: the prototype integration, the casual integration, and the enterprise integration.
Also available in: Chinese  
Articles 11 Aug 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
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.
Also available in: Japanese  
Articles 18 Jul 2006
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
Apache Derby
The Apache Derby project develops open source database technology that is based on Java technology, is easy to use, has a small footprint, is standards based, and is secure.
Downloads 26 Jan 2006
Cloudscape and Ajax - An example
Learn how to create an embedded database and Web server application using Cloudscape or Derby and Ajax. The source code and a ready-to-run application provided as a zip file are available for download.
Also available in: Chinese  
Articles 20 Jul 2006
Welcome to the Open source zone
IBM is launching a revamped developerWorks Open source zone, which will deliver more articles, resources, tools, and tutorials that support major industry open source initiatives, including Linux, Apache, Derby, Globus, and Eclipse. Learn how you can benefit.
Articles 25 Feb 2005
JPA with Rational Application Developer 8 and WebSphere Application Server 8
Learn how to create Java Persistence Architecture (JPA) entities that are built from pre-existing relational tables, that use database-generated primary key values, and are part of a composition (or aggregation) of one or more other JPA entity beans. You will use Rational Application Developer tools to rapidly generate and customize JPA entities from a Derby database with tables that use the Identity Value Generation capability. Using the views and editors increases your productivity by freeing you from hand coding the required annotations.
Articles 28 Jun 2011
Setting up IBM DB2 database for IBM Systems Director 6.2
IBM Systems Director is the core IBM platform management product for managing data center devices. A default Systems Director installation includes the Apache Derby database as its data repository. If your environment has more than 500 devices under management, it's highly recommended you switch to a full-fledge database management system, such as IBM DB2. This article will show you how to prepare the DB2 instance and database and how to make the switch in conformance with DB2 best practices.
Also available in: Chinese  
Articles 07 Dec 2010
Cloudscape Version 10: A technical overview
The core of IBM Cloudscape is the Apache Derby open source database. Derby's lightweight, embeddable architecture makes it the ideal database engine for deploying database-driven Java applications. With Derby, the database engine becomes part of the application, so the user never has to install or manage it. This article provides an overview of Derby technical features.
Articles 17 Jul 2006
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
Cloudscape and ODBC
ODBC support is available for the Cloudscape 10 and Derby databases as an IBM DB2 Run-Time Client. The use of Derby, Version 10.1 and 10.0, with ODBC is a supported platform for Windows and available as a beta for Linux. This article discusses platforms, system requirements, configuration, and where to download the free driver.
Articles 01 Dec 2005
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.
Also available in: Japanese  
Articles 03 Oct 2006
Zend Core for IBM - A guided tour for PHP developers
Walk through the installation of a PHP 5 environment using the industry's first integrated PHP environment that includes the IBM Cloudscape database server.
Also available in: Russian   Japanese  
Articles 14 Jul 2005
Introducing IBM WebSphere sMash, Part 1: Build RESTful services for your Web application
In this series, learn all about IBM WebSphere sMash, a simple environment for creating, assembling, and executing applications based on current Web technologies. In this first article, get a hands-on tour of the innovations that let you create, assemble, and deploy powerful Web applications. Learn how WebSphere sMash is community driven, and about its conventions for creating RESTful Web services. Using a step-by-step example, you set up the environment, create a project, build a RESTful service to expose data, test your application, and import a sample application to consume the RESTful services.
Also available in: Chinese   Russian   Japanese  
Articles 02 Sep 2008
Understanding web services specifications, Part 3: Uniform Description and Discovery Interface (UDDI)
Learn the basic concepts of the Uniform Description and Discovery Interface (UDDI), and how to access it using a Java application, in this third in a series of tutorials on the major web service specifications.
Also available in: Chinese   Spanish  
Tutorial 21 Jul 2006
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
A compendium of Cloudscape frequently asked questions
IBM Cloudscape is a small-footprint, multiuser, standards-driven, relational database system written entirely in Java that is well suited for embedding in Java applications and Servers. This technical article answers common questions.
Articles 27 Jul 2006
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
Support mobile client access in multilanguage platforms with DB2 Everyplace Sync Server
Extend your DB2 Everyplace server to support mobile clients in different language platforms using Java Database Connectivity (JDBC) application development and DB2 Everyplace Sync Server. This article shows you how to leverage the horizontal filtering and Unicode standard provided by DB2 Everyplace-related products in an open-standard-based environment.
Articles 18 Apr 2006
Accelerate access to critical data using IBM solidDB Universal Cache
IBM solidDB Universal Cache is in-memory caching software for use with traditional disk-based relational databases. It promises extreme speed, adaptability, and robustness. Explore these promises and follow a sample use case for the first - extreme speed.
Also available in: Chinese  
Articles 12 Mar 2009
Develop IBM Cloudscape and DB2 Universal Database applications with PHP
Learn how to configure IBM Cloudscape 10.0 and DB2 Universal Database Version 8.2 servers for access from PHP 4.x and PHP 5.x. Write database applications using the Unified ODBC extension. Overcome common performance issues due to scrollable cursors and avoid functional limitations in stored procedures.
Articles 24 Feb 2005
1 - 41 of 41 results
Show Summaries | Hide Summaries