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
spring & hibernate
spring 2.x: Alex – Main – discussing with Rod and Rob
Tutorial with Hibernate: Hibernate
Hibernate + Spring : this looked like a decent example, follow on as I do not know German and translated to English below.


