Developers Getting Started With i2b2
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Step 5: CRC Loader Configuration: Set the database properties


During the hivedata installation one of the tables created was the CRC_DB_LOOKUP table. The CRC Loader needs to communicate with this table and in order to do this we need to tell it where to find the Hivedata tables. During this step we will define the properties for JDBC connection and the data source lookup in the following CRC Loader configuration files.

  • CRCLoaderApplicationContext.xml
  • edu.harvard.i2b2.crc.loader.properties (should still be open from previous section)


Prerequisite

You need to know the location of your Hivedata tables. These are owned by the PM cell.


Steps to update data sources in CRCLoaderApplicationContext.xml


Unknown macro: {indent1}

1. The <b>CRCLoaderApplicationContext.xml</b> file is located in the following directory:

Unknown macro: {indent2}

<b><i>YOUR_I2B2_SRC_DIR</i></b>\edu.harvard.i2b2.crc\etc\spring


Unknown macro: {indent2}

<b><i>Example:</i></b>  C:\opt\i2b2\edu.harvard.i2b2.crc\etc\spring



Unknown macro: {indent1}

2. Open the CRCLoaderApplicationContext.xml file to configure the data source for the CRC Loader


Note

The following properties need to be updated or verified that they are set correctly for your environment:

  • "driverClassName" - make sure the jdbc driver is correct for your type of database.
  • "url" - verify the jdbc is correct for your type of database and update localhost to the location of your database that has your hivedata tables
  • "username" - verify the username is i2b2hive (defined when creating database users)
  • "password" - verify the password is demouser (defined when creating database users)


Oracle Database




<bean id="CRCBootstrapDS" class="org.apache.commons.dbcp.BasicDataSource"
	destroy-method="close">
	<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
	<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE" />
	<property name="username" value="i2b2hive" />
	<property name="password" value="demouser" />
</bean>



PostgreSQL Database




<bean id="CRCBootstrapDS" class="org.apache.commons.dbcp.BasicDataSource"
	destroy-method="close">
	<property name="driverClassName" value="org.postgresql.Driver" />
	<property name="url" value="jdbc:postgresql://localhost:5432/i2b2" />
	<property name="username" value="i2b2hive" />
	<property name="password" value="demouser" />
</bean>



SQL Server Database




<bean id="CRCBootstrapDS" class="org.apache.commons.dbcp.BasicDataSource"
	destroy-method="close">
	<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
	<property name="url" value="jdbc:sqlserver://localhost:1433" />
	<property name="username" value="i2b2hive" />
	<property name="password" value="demouser" />
</bean>



Unknown macro: {indent1}

3. Save the changes and close the file.


Steps to update data sources in edu.harvard.i2b2.crc.loader.properties


Unknown macro: {indent1}

1. Go to the <b>edu.harvard.i2b2.crc.loader.properties</b> file you still have opened from earlier.

Unknown macro: {indent1}

2. Scroll to the section called <b>Datasource Lookup info</b>.

Unknown macro: {indent1}

3. Set the Datasource Lookup information to reflect the information you entered previously in the CRCLoaderApplicationContext.xml file.


Datasource Lookup info

    edu.harvard.i2b2.crc.loader.ds.lookup.datasource=CRCBootsrapDS
    edu.harvard.i2b2.crc.loader.ds.lookup.servertype=ORACLE
    edu.harvard.i2b2.crc.loader.ds.lookup.schemaname=i2b2hive


Unknown macro: {indent1}

4. Save the changes and close the file.




  • No labels