Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Step 2: Set Database Properties for Workdata Tables

Excerpt Include
3.4.2 Set Database Properties
3.4.2 Set Database Properties
nopaneltrue


Note
titleImportant

When setting the database properties make sure you set the user to i2b2workdata and the project to demo.



Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
titleDatabase Properties File
borderStylesolid

Oracle Database

indent
Level2

db.type=oracle

indent
Level2

db.username=i2b2workdata

indent
Level2

db.password=demouser

indent
Level2

db.server=LocationOfYourDatabase:1521:xe

indent
Level2

db.driver=oracle.jdbc.driver.OracleDriver

indent
Level2

db.url=jdbc:oracle:thin:@LocationOfYourDatabase:1521:xe

indent
Level2

db.project=demo


PostgreSQL Database

indent
Level2

db.type=postgresql

indent
Level2

db.username=i2b2workdata

indent
Level2

db.password=demouser

indent
Level2

db.driver=org.postgresql.Driver

indent
Level2

db.url=jdbc:postgresql://LocationOfYourDatabase/i2b2?searchpath=i2b2workdata

indent
Level2

db.project=demo


SQL Server Database

indent
Level2

db.type=sqlserver

indent
Level2

db.username=i2b2workdata

indent
Level2

db.password=demouser

indent
Level2

db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

indent
Level2

db.url=jdbc:sqlserver://LocationOfYourDatabase:1433;database=demo

indent
Level2

db.project=demo




indent
Level1

3. Save the changes and close the file.


Tip
titleTip

To save yourself steps, DO NOT close your Command Prompt window as you will be continuing to use it throughout the remainder of the installation.