TechnoBuzz

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:

%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbynet.jar;%DERBY_INSTALL%\lib\derbyclient.jar;%DERBY_INSTALL%\lib\db2jcc.jar;%DERBY_INSTALL%\lib\db2jcc_license_c.jar;;%DERBY_INSTALL%\lib\derbytools.jar

run sample in the embedded envir: java org.apache.derby.tools.sysinfo -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

C:\derby\frameworks\NetworkServer\bin

run sysinfo.bat

ij:

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

ij> show connections;

ij> select * from sys.systables;

Derby future possibilities

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: