[daisy] Integration of Mysq/MXJ

[Paul Focke]

David Poelz wrote:
> Hi, 
>
> Im currently building an appication that uses the XMPP chat protocol to
> safe and retrieve documents from a daisy repository. Currently im trying
> to build a installation package and im trying to reduce the number of
> extra installation work. 
> It would be really great if the mysql server could be integrated in the
> distribution package. During my search i stumbled upon a mysql project
> called MySQL Connector/MXJ which starts the standalone mysql server
> whenever a connection is needed and all that would need to be changed is
> the connection string.(at least it seems so from the
> mysql-documentation)
> Did anyone try to integrate this into Daisy? Are there any reasons
> against it?
>   
Nope this is the first time I've heard of this
> Does anyone has any tips how i should start?
>   
Anyway if it's a question of changing the connection url then there's 
not much of a problem.  The connection settings are specified in the 
myconfig.xml (<daisy.data>/conf/myconfig.xml).  But you probably also 
need need to use the MXJ connector instead of the standard Connector/J.  
This can also be done the myconfig.xml under the section 'driverRegistrar'.

You might also want to have a look at a way of creating the database 
schema on startup.  Auto creating the database (just the database not 
the tables & what have you) is also just a question of adding a 
parameter to the url.

HTH,

Paul