How to start Railo from a CD with a H2 Database

Following my last post, here the version with a H2 database.

Here the steps

1- Extract this version of Railo into a folder ex c:\railo_cd

2- Start Railo via the batch c:\railo_cd\start.bat

3- Update Railo via http://localhost:8080/railo-context/admin/
Services -> Update -> Execute Update

4- Go to the web Administrator
Remove the debugging setting
Create a new datasource
Services -> Datasource
Important the type should be H2 Database Engine
Click Create
Database -> Enter the name you wants for it
Username -> sa
Password -> leave it blank
Path -> \railo_cd\database\
Now you have created a H2 database for your application.

5- You have by default with Railo a web interface to manage your H2 database Just click on this file c:\railo_cd\ext-lib\h2.jar
That will open a new browser here http://localhost:8082/login.jsp
The jdbc url ->
jdbc:h2:c:\railo_cd\database\NameOfYourDatabase;hsqldb.default_table_type=cached
Login -> sa
Password -> leave it blank

6- Bring your application to a folder under the webroot folder for example c:\railo_cd\webroot\myApplication

7- Test your application if everything goes properly proceed with the next steps

8- Redo the steps 5, 6, 7 and 8 of the previous post

If you want to be sure nobody write something in your database you can put your database readonly via this command call readonly() in web interface

| View count: 1231
del.icio.us Digg Facebook Yahoo! My Web Google Bookmarks DZone

No comments yet.

(will not be published)
Leave this field empty: