A Techno Blog, mainly about Java

apache derby

Derby Web Site : I downloaded this version.

Extract it and go into the \demo\simple\ directory, find example.html

Download the db2jcc driver for derby from ibm

Add to classpath:


run sample in the embedded envir: java -cp embedded SimpleApp.class

start server in server envir: java org.apache.derby.drda.NetworkServerControl start

run sample in server envir: java SimpleApp jccjdbcclient

Derby manual  page, on left hand side click your version (i.e. 10.1) .

Tutorial paper

DeveloperWorks Derby page, IBM infocenter

There are two separate Eclipse plugins for Derby: derby_core_plugin , derby_ui_plugin
After extracting the plugins to the eclipse plugins folder:
– From the main Eclipse menu at the top select Help >> Help Contents >> Derby Plug-ins User Guide
– you add a derby nature to your project, and following the getting started with the plugin   

Derby with Tomcat article, with J2EE, DeveloperWorks Derby Tutorial


run sysinfo.bat


ij> connect ‘jdbc:derby:derbyDB’ user ‘user1’ password ‘user1’;

ij> show connections;

ij> select * from sys.systables;

Derby future possibilities

December 23, 2005 - Posted by | Open Source

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: