Skip to main content

Skip over site navigation to main content

developerWorks  >   Open source  >   Technical library  >  

Technical library view  RSS for Open source

 developerWorks
 Related links:    Redbooks

Filter your search and/or enter a keyword. If you don't filter your search or enter a keyword, the search results will default to all results.

 
 
 
  1 - 11 of 11 results    Hide Summaries
Title   Date  

Table that contains the results that meet the search criteria.

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. 		14 Feb 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. 		12 May 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. 		18 Apr 2006  
 
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. 		30 Jan 2007  
 
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. 		07 Nov 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. 		12 Dec 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. 		15 Aug 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. 		11 Jul 2006  
 
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. 		17 Apr 2007  
 
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. 		06 Jun 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. 		28 Mar 2006  
 
  1 - 11 of 11 results    Hide Summaries
Not finding what you're looking for? Suggest Content