How to declare a jdbc used by a vocabulary in Studio ?

pibou_Bouvret — Tue, 21 Apr 2015 15:19:02 GMT

In studio, it seems impossible to declare a custom vocabulary (not based on the single data source).

So I choose an arbitrary vocabulary and give in custom properties my directoryName (test)

The bundle is generated as expected

    <properties widgetMode="edit">
      <property name="directoryName">test</property>
    </properties>

and in studio i even have "Directory Name" positionned to "test" (as if it was a studio vocabulary).

That's a real dirty solution !

I also declared an XML extension in studio for my directory :

<extension point="directories" target="org.nuxeo.ecm.directory.sql.SQLDirectoryFactory">
    <directory name="test">
      <schema>vocabulary</schema>
      <dataSource>XXXXX</dataSource>
      <cacheTimeout>3600</cacheTimeout>
      <cacheMaxSize>1000</cacheMaxSize>
      <table>test</table>
      <idField>id</idField>
      <autoincrementIdField>false</autoincrementIdField>
      <createTablePolicy>never</createTablePolicy>
    </directory>
  </extension>

First question : what's the syntax of the datasource element :

a studio vocabulary would be defined as java:/test whereas, according to common contributions to the org.nuxeo.ecm.directory.sql.SQLDirectoryFactory directories extension point, it would be jdbc/test. What's the difference ?

Server side : I tried to declare the mentionned jdbc ressource.

I copied common-base to a custom template

it is deployed after common-base

in server.xml template, I declared a second ressource next to the common datasource :

<Resource name="jdbc/testDS" auth="Container" type="javax.sql.DataSource"
    maxActive="5" maxIdle="30" maxWait="10000" driverClassName="${nuxeo.test.driver}"
    url="${nuxeo.test.jdbc.url}" validationQuery=""
    username="${nuxeo.test.user}" password="${nuxeo.test.password}"
    accessToUnderlyingConnectionAllowed="true" />

In nuxeo.xml template, I delared the ressource link pointing to the global ressource

<ResourceLink name="jdbc/test" global="jdbc/testDS" type="javax.sql.DataSource" />

Finally, I excluded both ressource names from the common datasource in nuxeo.conf

singleDataSource.exclude=jdbc/testDS,jdbc/test

When using the widget, I get the following error :

Caused by: **org.postgresql.util.PSQLException**: ERREUR: la relation « test » n'existe pas

What would be the proper declaration(s) for my directory to work with the data source I declared ?

Re: How to declare a jdbc used by a vocabulary in Studio ?

pibou_Bouvret — Tue, 01 Mar 2016 11:04:44 GMT

The solution is to simply create a contribution extending the "datasources" extension point of "org.nuxeo.runtime.datasource"

topic How to declare a jdbc used by a vocabulary in Studio ? in Nuxeo Forum

How to declare a jdbc used by a vocabulary in Studio ?

Re: How to declare a jdbc used by a vocabulary in Studio ?