Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Old Version 3

changes.mady.by.user Jeffrey Klann

Saved on

compared with

New Version 4

changes.mady.by.user Jeffrey Klann

Saved on

Key

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

...

  • 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
Level1

2. Open the crc-ds.xml file to configure your data sources. (see examples shown below)

 



Oracle Database


Code Block
xml
xml
<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
Level3

Example:   A second project called Demo2 would have the following entry:

 



Second Data Source Configuration

...