You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by aasoj j <aa...@gmail.com> on 2009/08/04 12:11:35 UTC
JCR-1435: Choose the MySQL engine
Hi,
We want to choose mysql engine (InnoDB) for Jackrabbit tables without
changing the DB's default engine type. Is there a way to do this?
I saw a related jira
https://issues.apache.org/jira/browse/JCR-1435:Choose the MySQL engine
for database storage (default to MyISAM). I added mysqlEngine
parameter to the repository.xml but could not get the mysqlEngine
configuration to work. Please let me know if I am doing anything
wrong.
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
...
<param name="mysqlEngine" value="InnoDB"/>
</FileSystem>
Regards
Re: JCR-1435: Choose the MySQL engine
Posted by James Abley <ja...@gmail.com>.
2009/8/4 Sébastien Launay <se...@anyware-tech.com>
> Hi,
>
> This issue has not been integrated yet in Jackrabbit source code.
> Therefore, you have two solutions:
> - patch Jackrabbit source code with the JCR-1435 patch, build
> a custom jar and use it.
> - create the tables with the right engine and prefixes before
> starting the application (scripts can be found in the source code).
>
> --
> Sébastien Launay
>
> aasoj j a écrit :
> > Hi,
> >
> > We want to choose mysql engine (InnoDB) for Jackrabbit tables without
> > changing the DB's default engine type. Is there a way to do this?
> >
> > I saw a related jira
> > https://issues.apache.org/jira/browse/JCR-1435:Choose the MySQL engine
> > for database storage (default to MyISAM). I added mysqlEngine
> > parameter to the repository.xml but could not get the mysqlEngine
> > configuration to work. Please let me know if I am doing anything
> > wrong.
> >
> > <Repository>
> > <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
> > ...
> > <param name="mysqlEngine" value="InnoDB"/>
> > </FileSystem>
> >
> >
> > Regards
>
Is another option to use the schema parameter to define the name of the
resource which contains the DDL used to create the tables?
e..g.
<param name="schema" value="mysql-innodb" />
You then need to provide a mysql-innodb.ddl resource at an appropriate point
in the classpath, based on the mysql.ddl within the core, but adding the
desired engine type.
Untested, but I think it will work.
Cheers,
James
Re: JCR-1435: Choose the MySQL engine
Posted by Sébastien Launay <se...@anyware-tech.com>.
Hi,
This issue has not been integrated yet in Jackrabbit source code.
Therefore, you have two solutions:
- patch Jackrabbit source code with the JCR-1435 patch, build
a custom jar and use it.
- create the tables with the right engine and prefixes before
starting the application (scripts can be found in the source code).
--
Sébastien Launay
aasoj j a écrit :
> Hi,
>
> We want to choose mysql engine (InnoDB) for Jackrabbit tables without
> changing the DB's default engine type. Is there a way to do this?
>
> I saw a related jira
> https://issues.apache.org/jira/browse/JCR-1435:Choose the MySQL engine
> for database storage (default to MyISAM). I added mysqlEngine
> parameter to the repository.xml but could not get the mysqlEngine
> configuration to work. Please let me know if I am doing anything
> wrong.
>
> <Repository>
> <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
> ...
> <param name="mysqlEngine" value="InnoDB"/>
> </FileSystem>
>
>
> Regards