Versions Compared

Old Version 2

changes.mady.by.user Marc-Danie Nazaire

Saved on

compared with

New Version 3

changes.mady.by.user Marc-Danie Nazaire

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themerdark
$ psql -U postgres i2b2
 
i2b2=# set search_path = public;
 
i2b2=# insert into PM_PROJECT_DATA (project_id, project_name, project_wiki, project_path, status_cd) values ('ACT', 'ACT Ontology', 'http://open.catalyst.harvard.edu/display/SHRINE', '/ACT', 'A');

After doing that, you will also need to add the Shrine Ontology data source (DS) to the ont-ds.xml file within the i2b2 instance. This file should be located within your i2b2 deployments directory (/opt/wildfly/standalone/deployments):

Code Block
languagexml
themerdark
<datasource jta="false" jndi-name="java:/ShrineOntologyDS" pool-name="ShrineOntologyDS" enabled="true" use-ccm="false">
    <connection-url>jdbc:postgresql://localhost:5432/i2b2</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <driver>postgresql-9.2-1002.jdbc4.jar</driver>
    <security>
    	<user-name>shrine_ont</user-name>
    	<password>yourPassword</password>
    </security>

    <validation>
    	<validate-on-match>false</validate-on-match>
    	<background-validation>false</background-validation>
    </validation>

    <statement>
    	<share-prepared-statements>false</share-prepared-statements>
    </statement>
</datasource>


Finally restart wildfly and tomcat.