Add Apache Derby Embedded Database To ColdFusion 10 Server

This tutorial guides the reader how to add an Apache Derby Embedded Database to ColdFusion 10 server.

1) The database used for this exercise is based on http://www.forta.com/books/032166034X/owsdata.zip. Download the zip file, extract it to C:\ColdFusion10\cfusion\db as follows:







2) Browse Admin page at http://127.0.0.1:8500/CFIDE/administrator/
Enter your admin password.


3) In the left Panel, click Data & Services/Data Sources.




4) Type the Data Source Name=ows, select Driver=Apache Derby Embedded, click Add.



5) Browse for the location.
Click Submit.



6) You should get success message.