Manual

Clone this repo and copy the "database" folder (/database) into your project (or into the folder you place your components)

CommandBox

box install dao

Railo/Lucee Notes

In order to use the DAO caching options with Railo/Lucee you'll need to enable a default cache in the Railo/Lucee Administrator. If this is not done, the caching mechanism will be forced off (otherwise would result in errors). Simply create a "RamCache" (for some reason EHCache throws NPE) type Cache service under Services > Cache and set it to be the default for Object caches. The default can also be set per app using Application.cfc by adding:

this.cache.object = "your_cache_name_here";

NOTE: DAO Caching is experimental and does not currently work well with nested dynamic relationships.

Also, the "Preserve single quotes" setting must be checked in the Railo/Lucee admin. DAO specifically passes the SQL strings through preserveSingleQuotes(), but this doesn't seem to work unless you have that setting checked under Services > Datasources.