Home > Articles > Databases

Further Steps with Derby: Derby Embedded in a Browser

Stephen B. Morris
  • PrintPrint
  • Share ThisShare This
  • DiscussDiscuss
Close WindowStephen B. Morris

Stephen B. Morris

Learn more…

Nonlinear Code Management in EJB3
Jul 30, 2009
Database Access via C# ADO.NET
Jul 2, 2009
C# Reflection
Jun 29, 2009
Object Relational Mapping and Java Persistence: Data Modeling and Legacy Schemas
Jun 23, 2009
C# GUI Programming
Jun 16, 2009
C# Assembly Programming
Jun 11, 2009
Using the C# system.io Namespace
Jun 2, 2009
Using C# Generics
May 13, 2009
An Introduction to Concurrent Java Programming
May 12, 2009
Using C# Interfaces
Apr 22, 2009
Getting Your Software onto Linux
Apr 13, 2009
What’s Wrong with Modern Software Development?
Mar 9, 2009
Building a Solid Foundation for JPA and Hibernate
Feb 16, 2009
Java Patterns for MPLS Network Management, Part 2
Dec 15, 2008
Java Patterns for MPLS Network Management, Part 1
Dec 8, 2008
Getting Started with Spring Web Flow
Sep 26, 2008
Application Contexts for Spring Web Services
Sep 16, 2008
Spring Web Services with SOAPUI
Aug 15, 2008
Hit the Ground Running with the Spring Framework
Aug 8, 2008
Building Multithreaded C# Applications
Jun 6, 2008
Hosting an LDAP Server in VMWare
May 30, 2008
Integrating Linux Into Your Windows Environment
May 21, 2008
Understanding C# Object Serialization and Object Graphs
May 19, 2008
Further Subversion Steps: Get Motoring with TortoiseSVN
Apr 22, 2008
Further Steps with the Java Sound API
Apr 7, 2008
5 Easy Steps to Using Virtualization Technology
Apr 4, 2008
Five Steps to Getting Started Server-Side with PHP
Mar 7, 2008
Targeted Client Upgrades: Creating a Flexible, Low-cost Application Upgrade Mechanism
Feb 15, 2008
Java DMK and Legacy IT Management
Feb 8, 2008
Aspect-Oriented Programming: A Tool for Internationalization
Feb 1, 2008
Achieving Separation of Concerns Using BPEL
Jan 25, 2008
Mobile Java with J2ME
Jan 18, 2008
Graph Algorithms in Java
Dec 28, 2007
Design Patterns in Java: The Observer
Dec 21, 2007
Five Steps to Managing Unstructured Data with Derby
Dec 14, 2007
Using the Java Sound API
Nov 9, 2007
Moving C++ and Java Programmers Up the Value Chain
Nov 2, 2007
Java Nuts and Bolts: Copy Constructors, Cloning, and Linked Structures
Oct 19, 2007
Further Steps with Derby: Derby Embedded in a Browser
Oct 5, 2007
Further Steps with Derby: Defining and Accessing Your Data
Sep 28, 2007
IT Management Using C# with WMI
Sep 21, 2007
Using Derby as a Network Database Server Engine
Sep 21, 2007
Five Steps to Further Success with Subversion
Sep 14, 2007
Improve Software Installation with AntInstaller
Sep 7, 2007
Multithreaded Java GUI Programming
Aug 10, 2007
The C++ Strategy Pattern for Multiple Network Events
Aug 4, 2007
Java Collections and Iterators
Aug 3, 2007
The C++ State Pattern for Network Operations
Jun 15, 2007
C++ Nuts and Bolts: Casts, Call-by-Reference, and Inheritance
Jun 8, 2007
Getting Started with Subversion on Windows
May 25, 2007
Getting Started with Derby
May 11, 2007
C# Callback and Event Mechanisms
Mar 23, 2007
Some Rules for Safer Java Programming
Mar 16, 2007
Inheritance and Polymorphism in C++ and C#
Mar 2, 2007
IT Management: Dipping into the Platform with C#
Feb 2, 2007
C# and IT Management Infrastructure
Jan 26, 2007
C++ to C# Migration
Dec 29, 2006
Service Oriented Architecture with Apache Axis
Nov 22, 2006
Speech-Enable Your Java Software
Sep 1, 2006
Generic C++ for Networks
Apr 21, 2006
C++ Inheritance and Polymorphism
Apr 7, 2006
Thinking Recursively with C++
Mar 24, 2006
Aspect-Oriented Programming for Production Code
Mar 10, 2006
C++ Modularity with Namespaces and Exception Handling
Mar 3, 2006
C++ Chain of Responsibility Pattern: Network Events
Feb 10, 2006
The Web Services Distributed Management (WSDM) Standard
Feb 3, 2006
MPLS Network Design Nuts and Bolts
Jan 6, 2006
BPEL: The Next Big Thing in Software?
Nov 18, 2005
On-Demand Computing: A New Paradigm
Oct 6, 2005
Software Plasticity with Aspect-Oriented Programming
Sep 16, 2005
Parser Configuration in JAXP
Aug 26, 2005
Publish and Subscribe Using C++ and the Observer Pattern
May 27, 2005
Java Application Servers: Seven Things You Should Know
Apr 29, 2005
Legacy IT Management using C++
Apr 29, 2005
Software Futures: Architecture
Mar 25, 2005
Saving Money with Legacy Data
Mar 11, 2005
Saving Money with Legacy Source Code
Feb 4, 2005
MPLS and Ethernet: Seven Things You Need To Know
Dec 17, 2004
Quality of Service, Part 2 of 2: Managing Enterprise QoS
Oct 15, 2004
Quality of Service, Part 1 of 2: Elements of Enterprise QoS for Voice Over IP
Oct 8, 2004
The Need for Autonomic Computing
Oct 8, 2004
A Blade Server Primer
Aug 27, 2004
Workflow-Based Network Management
Jul 30, 2004
SNMP Versus Command-Line Interface (CLI) for Network Management
Jul 23, 2004
Security and the Management Plane, Part 2
Jul 2, 2004
Security and the Management Plane, Part 1
Jun 25, 2004
Network Management and MPLS
Nov 13, 2003
Managing Large Networks: Problems and Solutions
Oct 17, 2003
Getting my first iPhone app into the App Store
By on September 25, 20092 Comments

Having just posted my first iPhone to the App store, I wanted to briefly describe the experience and at the same time to debunk some myths I’ve heard about since I started.

SOA and IT Strategy
By on April 27, 2009 No Comments

It's a rare organization that has a comprehensive IT strategy. Why does a strategy matter? For one thing, IT is now part of the DNA of all organizations. So, an effective strategy is a key business element.

IT staff and contractors - why they matter
By on April 21, 2009 1 Comment

IT salaries and contract rates in free fall

A day in the life of a software contractor - Forming good relationships
By on April 9, 20082 Comments

I wanted to share a few findings with you about my recent forays into the world of software contracting.

The path to programming excellence ? C++ to Java from C, Pascal and others
By on September 28, 2007 No Comments

I’ve probably used more programming languages down the years than is good for me. And like many other programmers, I mostly use Java nowadays. During my most recent product development, I made a foray back into C in order to do some Ethernet protocol analysis. Some languages are just better than others for such tasks - remember C is a system language so you can use it to dig right into the platform. Java is more constrained because of the JVM boundary. In the end, I integrated the down-to-the-metal C code right back into Java using JNI.

Moving up the value chain
By on September 14, 2007 No Comments

Following on from my previous posting on decision-making quality, I wanted to talk a little about the related subject of the value chain.

Decision-making Quality
By on August 7, 20073 Comments

The need for forward momentum is perhaps one of the negative consequences of the fast pace of modern life. This issue is discussed in ex-world chess champion, Garry Kasparov’s latest book “How life imitates chess”. Kasparov feels that decision-making suffers if insufficient time is taken. He’s not alone. Edward de Bono – the inventor of lateral thinking once said that apart from extreme emergencies there is rarely a need to think quickly. Warren Buffett moved his offices out of New York City to Omaha because he wanted not one good idea every day but one good idea every year. Excessive and unnecessary speed takes a heavy toll on the quality of decision-making.

Does it surprise you to think of a fully fledged database product integrated into a web browser application? If you think databases belong only on high-end servers, you might be interested to hear that you can now integrate an instance of Apache Derby into a browser. To find out how, read the latest installment of Stephen B. Morris's Further Steps with Derby series.

Software is still hard to write because the present generation of programming languages has what might be called a low level of granularity (that is, coding still involves thinking at a low level of abstraction). In some respects, things have improved (for example, automatic garbage collection in languages such as Java and C# have obviated the need for destructor code), so you can instantiate objects without having to worry too much about the destruction phase. But on the other hand, you still have to do a lot of grunt work—handling files, opening network connections, interacting with databases, and so on.

All of the latter are hard to do and are error-prone, and in many ways distract programmers from the task at hand. Frameworks do attempt to abstract a lot of low-level details, but some frameworks are a bit top-heavy; others are hard to learn and some don’t even work properly.

Integrated Computing Environments

It’s when you join entities together during integration that the coding gets more difficult. For example, suppose that you want to display some database information in Java GUI. Sounds simple enough, right? Well, if you want to use the JTable component, you must present the data as an array of arrays of objects.

The latter is not the natural format of data retrieved from a relational database. So, when you want to logically join your database information in your GUI, you have a reasonably difficult coding problem on your hands. It’s not insuperable; it’s just a rather annoying problem associated with integrating different components.

All of this is an introduction to this article: how to embed Derby in a web browser. Why is this important? Well, integrating a database inside a browser is a big step in the direction of an integrated computing environment.

The only reason why you couldn’t host a database engine on a low horsepower desktop machine up to now was the scale of database products. Traditionally, complex database engines are hungry entities that require lots of disk space, RAM, and CPU cycles. My previous articles about Derby (see the "References" section at the end of the chapter) show that for low-end database applications, there is no longer a pressing need to spend big bucks. We’re now in an era of lightweight, low-footprint, powerful database engines. (Later on, I’ll briefly discuss the growing level of commitment to this area from organizations such as Sun Microsystems.)

The good news is that a database can now be integrated into a browser with relative ease (this is a good example of helping programmers and developers to move up the value chain [2]). Also, you can control the entire integration process without having to rely on a framework to do it for you.

Let’s look at why and how it’s done.

  • Share ThisShare This
  • Your Account

Discussions

You can buy standard and premium support for Java DB
Posted Oct 9, 2007 07:10 PM by francois.orsini
0 Replies

Make a New Comment

You must log in in order to post a comment.

Related Resources

There are currently no related podcasts. Please check back later.

Great password information at a small price
By John Traenkenschuh on June 13, 2009 No Comments

Where can cash-strapped security pro's get great information on security basics??

Steven HainesOracle Buys Sun of $7.4B
By Steven Haines on April 20, 2009 No Comments

In a stunning turn of events, Oracle steps in and buys Sun amist the breakdown of IBM's attempt to acquire Sun.

Buck WoodyIf it's Free it's for Me
By Buck Woody on January 26, 2009 No Comments

Sign me up for anything free these days. I just ran across a book that promises to help you build a web site for free...

See All Related Blogs

Informit Network