I didn't specify the engine in MySQL. It's whatever the default is.
On the driver location issue, choose ONE of:
- common/lib if you have other webapps using it via a JNDI resource def and
tomcat's built-in database pooling. Be careful there aren't any other webapps
with their own copy of the mysql driver.
- shared/lib if you have other webapps accessing the database directly like
magnolia's jackrabbit implementation does. Again, be careful there aren't any
other webapps in your tomcat setup with their own copy the mysql driver.
- WEB-INF/lib (recommended) prevents version and classloader conflicts if other
webapps have their own mysql driver. On the other hand, if you have other
webapps and they are using tomcat's database pooling, don't put one here. Use
(and preferably upgrade as necessary) the one in common/lib.
The first two aren't a problem if Magnolia author and public are the ONLY pair
of webapps running on your tomcat server.
--David
> Hi David,
>
> One more question:
>
> Which database engine are you using in MySQL? MyISAM or InnoDB? Which
> one is suitable for Magnolia?
>
> One thing about your wiki page:
> Can we just put one JDBC driver in ${TOMCAT_HOME}/common/lib?
>
> Thanks for all your help.
>
> Cheers,
> Richard
> ([EMAIL PROTECTED])
>
> On 8/30/06, David Smith <[email protected]> wrote:
>> A follow-up for the archives -- after sitting idle for 18 hours,
>> magnolia is still working with the mysql backend. ?autoReconnect=true
>> tacked on to the end of the connection url definitely fixed the problem
>> of db connections going stale.
>>
>> I've also written a wiki page taylored to getting 2.1.5 working with
>> mysql if anyone would like to refine it a bit.
>>
>> http://www.magnolia.info/wiki/Wiki.jsp?page=UsingMysqlWithMagnolia2.1.5
>>
>> --David
>
> ----------------------------------------------------------------
> for list details see
> http://www.magnolia.info/en/magnolia/developer.html
> ----------------------------------------------------------------
>
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
