Derby

View: [ 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 ]

Articles
Tutorials
  

Articles:
  • Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 6 by Robert Brunner   - [Clicks: 112]
    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.
    [Includes sample code]
    http://www.ibm.com/developerworks/java/library/os-ad-trifecta14/index.html - Aug, 2007
  • Getting started with Derby – The java database bundled with Java 6 by Jeroen van Wilgenburg   - [Clicks: 137]
    Today I will show how to run Derby as a network server. It is possible to run an embedded version of Derby, but for most web projects I prefer to keep my database and code separated. The purpose of using Derby for me is a temporary replacement for a ‘normal’ database like Oracle or MySQL.
    http://technology.amis.nl/blog/?p=2044 - May, 2007
  • Developing with Apache Derby -- Hitting the Trifecta: Java database development with Derby, Part 5 by Robert Brunner   - [Clicks: 51]
    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.
    [Includes sample code]
    http://www.ibm.com/developerworks/java/library/os-ad-trifecta13/index.html - May, 2007
  • Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 4 by Robert Brunner   - [Clicks: 50]
    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.
    [Includes sample code]
    http://www-128.ibm.com/developerworks/java/library/os-ad-trifecta12/index.html - Apr, 2007
  • Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 4: Deployment by Noel Rappin   - [Clicks: 216]
    In the past three articles in this series, you've built a simple but functional Web application using the Google Web Toolkit (GWT). Until now, you've been editing and debugging the application using GWT's hosted mode, which allows you to simulate a Web server environment within your Java development tool. Sadly, it's impractical to have all your users download Eclipse just to run your Web application. So, in this article, the fourth in this series, you'll learn how to deploy your GWT application within a Java Web application server and get tips on using the Apache Derby database to drive the GWT.
    http://www-128.ibm.com/developerworks/java/library/os-ad-gwt4/index.html - Feb, 2007
  • Developing with Apache Derby -- Hitting the Trifecta: Java database development with Apache Derby, Part 3 by Robert Brunner   - [Clicks: 61]
    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.
    [Includes sample code]
    http://www.ibm.com/developerworks/java/library/os-ad-trifecta11/index.html - Feb, 2007
  • Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 3: Communication by Noel Rappin   - [Clicks: 128]
    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.
    http://www-128.ibm.com/developerworks/java/library/os-ad-gwt3/index.html - Feb, 2007
  • Tuning Derby by Dejan Bosanac   - [Clicks: 76]
    Derby is a popular choice for an all-Java open-source database, but like all databases, it requires thought and care to run at ideal efficiency. Dejan Bosanac shows techniques--many of them applicable to all JDBC databases--that will keep your Derby-backed application running at top speed.
    http://www.onjava.com/pub/a/onjava/2007/01/31/tuning-derby.html - Jan, 2007
  • Developing with Apache Derby -- Hitting the trifecta: Java database development with Apache Derby, Part 2 by Robert Brunner   - [Clicks: 62]
    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.
    [Includes sample code]
    http://www-128.ibm.com/developerworks/java/library/os-ad-trifecta10/index.html - Jan, 2007
  • Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 2: The reliable back end by Noel Rappin   - [Clicks: 143]
    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 set 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.
    http://www-128.ibm.com/developerworks/library/os-ad-gwt2/index.html - Jan, 2007
  • Synchronizing a Web Client Database: LocalCalendar and Google Calendar by David Van Couvering   - [Clicks: 41]
    You have a web application, but in some cases your users want to be able to work locally, off-network, and synch up later. In this article, David Van Couvering shows how Java DB can be used to achieve this.
    [Includes sample code]
    http://today.java.net/pub/a/today/2007/01/16/synchronizing-web-client-database.html - Jan, 2007
  • Use Apache Derby to develop Eclipse plug-ins by Ilya Platonov, Artem Papkov, Jim Smith, Terry Finch   - [Clicks: 71]
    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.
    [Includes sample code]
    http://www-128.ibm.com/developerworks/library/os-ad-eclipse/index.html - Jan, 2007

[Top]

Tutorials:
  • Apache Derby resources from the Web services perspective, Part 3: Manage Apache Derby using Web Services Distributed Management by David Medinets   - [Clicks: 27]
    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.
    [Formats: html, pdf]
    http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-ws3.html - Mar, 2007
  • Real-world Apache Derby, Part 4: Wrapping up: Tracking SOX compliance by Dave Warner   - [Clicks: 19]
    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.
    [Formats: html, pdf]
    http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-sox.html - Feb, 2007
  • Real-world Apache Derby: Portable document storage by Dave Warner   - [Clicks: 58]
    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.
    [Formats: html, pdf]
    http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-viper.html - Feb, 2007
  • Two ways to build Apache Derby database applications in JRuby by Robert Thornton   - [Clicks: 116]
    JRuby is an implementation of the Ruby programming language that runs in the Java Virtual Machine (JVM). This tutorial demonstrates how to install and configure JRuby to connect to the Apache Derby database. As Ruby and Ruby on Rails become more popular, JRuby becomes an interesting technology to leverage the portability, security, and class libraries of the JVM while using Ruby features like simple syntax and closures. If you're writing a small application that needs a relational database, or you want to be able to ship a database with your product, then the Derby database is an excellent choice for a persistence mechanism. This tutorial shows you two methods of connecting to and building Derby database applications from JRuby.
    [Formats: html, pdf]
    http://www-128.ibm.com/developerworks/edu/os-dw-os-ad-jruby.html - Jan, 2007

[Top]