Message-ID: <757099244.7478.1711625138645.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7477_148826095.1711625138643" ------=_Part_7477_148826095.1711625138643 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Workplace cell needs to communicate with your i2b2 database<= /strong> and in order to do this it needs to know where the tables for the = workdata and hivedata reside. Therefore t= he sixth and final step in the cell confi= guration process is to configure the data sources for the Workplace Cell. T= his information is configured in the work-ds.xml file.
= =20
The following steps define how to conf=
igure your data sources for the Workplace Cell. These steps include example=
configurations for Oracle, PostreSQL and SQL Server.
<datasource jta=3D"false" jndi-name=3D"java:/WorkplaceBootStrapDS" =09=09pool-name=3D"WorkplaceBootStrapDS" enabled=3D"true" use-ccm=3D"false"= > =09<connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection= -url> =09<driver-class>oracle.jdbc.OracleDriver</driver-class> =09<driver>ojdbc6.jar</driver> =09<security> =09=09<user-name>i2b2hive</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<validate-on-match>false</validate-on-match> =09=09<background-validation>false</background-validation> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource> <datasource jta=3D"false" jndi-name=3D"java:/WorkplaceDemoDS" =09pool-name=3D"WorkplaceDemoDS" enabled=3D"true" use-ccm=3D"false"> =09<connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection= -url> =09<driver-class>oracle.jdbc.OracleDriver</driver-class> =09<driver>ojdbc6.jar</driver> =09<security> =09=09<user-name>i2b2workdata</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<validate-on-match>false</validate-on-match> =09=09<background-validation>false</background-validation> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource>=20
<datasource jta=3D"false" jndi-name=3D"java:/WorkplaceBootStrapDS" =09=09pool-name=3D"WorkplaceBootStrapDS" enabled=3D"true" use-ccm=3D"false"= > =09<connection-url>jdbc:postgresql://localhost:5432/i2b2</connecti= on-url> =09<driver-class>org.postgresql.Driver</driver-class> =09<driver>postgresql-9.2-1002.jdbc4.jar</driver> =09<security> =09=09<user-name>i2b2hive</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<validate-on-match>false</validate-on-match> =09=09<background-validation>false</background-validation> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource> <datasource jta=3D"false" jndi-name=3D"java:/WorkplaceDemoDS" =09pool-name=3D"WorkplaceDemoDS" enabled=3D"true" use-ccm=3D"false"> =09<connection-url>jdbc:postgresql://localhost:5432/i2b2</connecti= on-url> =09<driver-class>org.postgresql.Driver</driver-class> =09<driver>postgresql-9.2-1002.jdbc4.jar</driver> =09<security> =09=09<user-name>i2b2workdata</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<validate-on-match>false</validate-on-match> =09=09<background-validation>false</background-validation> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource>=20
<datasource jta=3D"false" jndi-name=3D"java:/WorkplaceBootStrapDS" =09=09pool-name=3D"WorkplaceBootStrapDS" enabled=3D"true" use-ccm=3D"false"= > =09<connection-url>jdbc:sqlserver://localhost:1433</connection-url= > =09<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</dri= ver-class> =09<driver>sqljdbc4.jar</driver> =09<security> =09=09<user-name>i2b2hive</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<valid-connection-checker class-name=3D"org.jboss.jca.adapters.jdb= c.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-ch= ecker> =09=09<validate-on-match>false</validate-on-match> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource> <datasource jta=3D"false" jndi-name=3D"java:/WorkplaceDemoDS" =09pool-name=3D"WorkplaceDemoDS" enabled=3D"true" use-ccm=3D"false"> =09<connection-url>jdbc:sqlserver://localhost:1433</connection-url= > =09<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</dri= ver-class> =09<driver>sqljdbc4.jar</driver> =09<security> =09=09<user-name>i2b2workdata</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<valid-connection-checker class-name=3D"org.jboss.jca.adapters.jdb= c.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-ch= ecker> =09=09<validate-on-match>false</validate-on-match> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource>=20
<datasource jta=3D"false" jndi-name=3D"java:/WorkplaceDemo2DS" =09pool-name=3D"WorkplaceDemo2DS" enabled=3D"true" use-ccm=3D"false"> =09<connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection= -url> =09<driver-class>oracle.jdbc.OracleDriver</driver-class> =09<driver>ojdbc6.jar</driver> =09<security> =09=09<user-name>i2b2workdata</user-name> =09=09<password>demouser</password> =09</security> =09<validation> =09=09<validate-on-match>false</validate-on-match> =09=09<background-validation>false</background-validation> =09</validation> =09<statement> =09=09<share-prepared-statements>false</share-prepared-statements&= gt; =09</statement> </datasource>=20
Note
The above example is for an Oracle database. If your database is SQL Ser= ver or PostgreSQL then you will need to copy the <datasource> section= for your type database connection. Do not use this one as it will not work= .