Filter by products, topics, and types of content

(0 Products)

(122 Topics)

(9 Industries)

(6 Types)

1 - 4 of 4 results
Show Summaries | Hide Summaries
View Results
Title none Type none Date none
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: 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
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
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
1 - 4 of 4 results
Show Summaries | Hide Summaries