| Repository implementation which pulls content from a database.
Here is an example configuration connecting to a MySql database:
<name>db_repository</name>
<driver>org.gjt.mm.mysql.Driver</name>
<url>jdbc:mysql://myserver.com/database</url>
<username>username</username>
<password>password</password>
<content-query>select body from content where path = ?</content-query>
<last-modified-query>select last_modified from content where path = ?</last-modified-query>
<paths-query>select * from content where path like ?</paths-query>
<delete-query>delete from content where path = ?</delete-query>
The database setup would be:
create table content (
path varchar(255) not null,
body text not null,
last_modified datetime not null
);
Note: This implementation does not currently implement all of the
required respository methods properly. |