[
http://jira.nuxeo.org/browse/NXP-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=38036#action_38036
]
Alexandre Russel commented on NXP-2484:
---------------------------------------
I'd like to suggest some improvement in the way datasources are
configured in Nuxeo:
- the modules(say nuxeo-platform-comment-jena) can choose to use a
datasource if needed (same as now)
- the datasource is configured in the datasource directory but point to
another datasource (same as a link in unix) using:
<mbean code="org.jboss.naming.NamingAlias"
name="jboss.jca:name=nxcomment-jena,service=DataSourceBinding">
<attribute name="ToName">java:/NuxeoDS</attribute>
<attribute name="FromName">java:/nxcomment-jena</attribute>
</mbean>
</datasources>
- the java:/NuxeoDS point to a "real" datasource, configured with a
database.
So the default would be for all datasources to use only 1 db and 1 pool
of connection.
it would be easier to change database (only one file to change) and the
perfomance would probably be better (only one pool to manage) There is
still the possibility to use 1 database/datasource by commenting out
the link and using a datasource configuration.
For system using the current system, we would need to either just use
the old datasource definition or copy tables from 1 db to the NuxeoDS one.
I created the NXP-2484 branch to show what I meant exactly (multi-part
still needs to be done). The only problem I can see would be if 2 tables
have the same name in 2 different DB, but I still think it should be
included in the 5.1 branch.
> simplify datasource configuration
> ---------------------------------
>
> Key: NXP-2484
> URL: http://jira.nuxeo.org/browse/NXP-2484
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Affects Versions: 5.1.4
> Reporter: Alexandre Russel
> Assignee: Alexandre Russel
> Fix For: 5.1.6
>
>
> If a user choose to change from hsql to another db, she should have, at least
> for ds setting, only one change to make.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
