[
https://jira.nuxeo.com/browse/NXP-7609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=102707#comment-102707
]
Florent Guillaume commented on NXP-7609:
----------------------------------------
This is possible but only but only by changing two files:
The file {{conf/Catalina/localhost/nuxeo.xml}} must contain:
{code:xml}
<ResourceLink name="jdbc/nxsqldirectory" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/nxrelations-default-jena" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/comment-relations" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/nxaudit-logs" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/nxjbpm" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/placeful_service_ds" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/nxwebwidgets" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/nxuidsequencer" global="jdbc/nuxeo"
type="javax.sql.DataSource" />
{code}
And the file {{conf/server.xml}} must contain:
{code:xml}
<GlobalNamingResources>
...
<Resource name="jdbc/nuxeo" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://wins:1433/nuxeo;useCursors=true"
username="nuxeo" password="*****" />
</GlobalNamingResources>
{code}
> Provide an unified data source for tomcat
> -----------------------------------------
>
> Key: NXP-7609
> URL: https://jira.nuxeo.com/browse/NXP-7609
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Packaging
> Affects Versions: 5.4.2
> Environment: tomcat
> Reporter: Benoit Delbosc
>
> The tomcat package defines 8 datasources, like this
> {code}
> <Resource name="jdbc/comment-relations" auth="Container"
> type="javax.sql.DataSource"
> maxActive="100" maxIdle="30" maxWait="10000"
> driverClassName="net.sourceforge.jtds.jdbc.Driver"
> url="jdbc:jtds:sqlserver://wins:1433/nuxeo;useCursors=true"
> username="nuxeo" password="*****" />
> ...
> {code}
> They should be unified to mutualise the connection pool.
--
This message is automatically generated by JIRA.
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
