- Derby: A Database for All Seasons
- What Is Derby?
- How to Use Derby
- Setting Up Your CLASSPATH
- Testing Your Setup
- Running Your First Derby Program
- Derby Application Components
- Derby Application Startup
- Loading the Derby Driver
- Database and Connection Creation
- Statement Creation
- Table Creation
- Table Access
- Shutdown
- Running the Code
Running the Code
I haven’t included the program SimpleApp.java with this article because you need the Derby distribution to run the program and the latter is included as part of the distribution. So, if you download Derby, the steps described here should still apply to the accompanying example programs.
Conclusion
I really like Derby! It’s a no-nonsense piece of software that requires no particularly complex setup. It also requires no associated frameworks. It just works. I’m actually using Derby in one of my company’s products due for release in the next few weeks. So, I really do believe in Derby!
Derby has a very light footprint, which facilitates its use in low-end software entities. There’s no need for top-of-the range servers. Derby runs happily on entry-level PCs.
The workflows required for writing Derby programs are also fairly straightforward. Just a few steps are needed to get your code up and running. I can’t recommend Derby highly enough! Try it and see what you think.