Page History
...
- The CRCBootStrapDS points to the data source for your CRC_DB_LOOKUP table which is a hivedata table.
- This is a reserved name for connecting to the hive; the name should not be changed!
- The <user-name> and <password> need to match the database user you set up for your hivedata. In the i2b2 demo database this is i2b2hive and demouser.
- The QueryToolDemoDS points to the data source for your demodata tables.
- The <user-name> and <password> need to match the database user you set up for your demodata. In the i2b2 demo database this is i2b2demodata and demouser.
- Additional data sources can be created, following the pattern of QueryToolDemoDS. It is important that the jndi-name is the same as the pool-name, but with "java:/" prepended.
- These other data sources can be used to connect i2b2 to other databases, using entries in the db_lookup database tables to refer to the jndi-name of the datasource.
- The <connection_url> needs to have the following:
- The correct JDBC information for your type of database.
- The correct location of the database containing your crcdata or hivedata tables. (These may or may not reside in the same location)
...
indent | ||
---|---|---|
| ||
2. Open the crc-ds.xml file to configure your data sources. (see examples shown below) |
Oracle Database
Code Block | ||||
---|---|---|---|---|
| ||||
<datasource jta="false" jndi-name="java:/CRCBootStrapDS" <CRC_DB_LOOKUP datasource value> pool-name="CRCBootStrapDS" enabled="true" use-ccm="false"> <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <driver>ojdbc6.jar</driver> <security> <user-name>i2b2hive</user-name> <password>demouser</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> <datasource jta="false" jndi-name="java:/QueryToolDemoDS" <crcdata tables datasource value> pool-name="QueryToolDemoDS" enabled="true" use-ccm="false"> <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <driver>ojdbc6.jar</driver> <security> <user-name>i2b2demodata</user-name> <password>demouser</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> |
...
indent | ||
---|---|---|
| ||
Example: A second project called Demo2 would have the following entry: |
Second Data Source Configuration
...