Database Plugin

Gav.... wrote:
> Hi G , 
> 
> It 'looks' like you would need to get the plugin from
>
..whiteboardpluginsorg.apache.forrest.plugin.Database
> 
> This is a whiteboard plugin, usually meaning 'use at
your own risk'
> Sometimes though only popular plugins make it out of
the 
> whiteboard, so unpopular ones remain there even if
stable.
> 
> Strange though how I could not find it listed on the 
> plugins section of the forrest site 
> http://forrest.apache.org/pluginDocs/plugins_0_80/in
dex.html

It has never been released because forrest.xconf needs to be
patched for 
it to know where to get database connection from.

At one time I patched Forrest to allow automatic patching of
the xconf 
files when plugins are installed. However, I used the XPatch
method 
which is being deprecated within Cocoon, so we removed it
again.

I have half-enabled the ability to dynamically load
additional xconf 
files. However, I never found the time to finish off this
work. Perhaps, 
now we have a user needing it, we will finish it with their
help 

There is also a need to patch the web.xml file, currently
there is no 
way of doing this automatically.

However, both of these can be done by hand (see Cocoon docs
on this).

> Maybe it is only available via subversion. You may need
to
> use the latest svn version of forrest, or someone else
> will be along to tell you how you can get it elsewhere.

It is only available via SVN.

It should work with 0.7, but I make no promises about that,
best to use 
SVN head.

An alternative, which I am using right now, is to write a
custom 
generator that will talk directly to the database. This is
not the most 
efficient method as it will no reuse the database pooling
etc. within 
the Cocoon DB block, however, it is quick and easy to do (if
you know 
how to write a java app to talk to the DB).

I can provide some simple skeleton code as an example if you
want to go 
this later route.

Ross

Thanks for answer

Could you tell me how I must modify plugin's files to work
with MySQL 
database? I need mysql-connector-java or something like
this, right? 
Your plugin only has excalibur and hsqldb driver. Am I
right?


Greg