You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
Step 2: Set Database Properties for Crcdata Tables
As stated earlier each i2b2 database schema has a corresponding directory that contains the data files for installing the data. Each of these directories has a file called db.properties and it needs to be updated with your environment variables.
Steps for setting database properties
Assumptions:
- You are logged into the command line application for your environment. (Linux: Terminal or Shell and Windows: Command Prompt)
- You have already changed your working directory to the one that is appropriate for this installation.
1. At the command prompt type the following:
2. The db.properties file will open. Set the following properties for the DBMS at your site:
Oracle Database
db.type=oracle
db.username=i2b2demodata
db.password=demouser
db.server=LocationOfYourDatabase:1521:xe
db.driver=oracle.jdbc.driver.OracleDriver
db.url=jdbc:oracle:thin:@LocationOfYourDatabase:1521:xe
db.project=demo
PostgreSQL Database
db.type=postgresql
db.username=i2b2demodata
db.password=demouser
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://LocationOfYourDatabase/i2b2?searchpath=i2b2demodata
db.project=demo
SQL Server Database
db.type=sqlserver
db.username=i2b2demodata
db.password=demouser
db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.url=jdbc:sqlserver://LocationOfYourDatabase:1433;database=demo
db.project=demo
3. Save the changes and close the file.
