Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

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

Step 2: Set Database Properties for PM 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 i2b2pm. Projects are not assigned to Pmdata which is why the db.project property is not in the PM's db.properties file


Note
titleACT Ontology

As of 1.7.12, it is possible to load an ACT ontology project. When doing so, change the project to ACT when installing the PM data, to create the project entry and user entries in the database. More information can be found in the release notes.




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

Oracle Database


indent
Level2

db.type=oracle


indent
Level2

db.username=i2b2pm


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



PostgreSQL Database


indent
Level2

db.type=postgresql


indent
Level2

db.username=i2b2pm


indent
Level2

db.password=demouser


indent
Level2

db.driver=org.postgresql.Driver


indent
Level2

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



SQL Server Database


indent
Level2

db.type=sqlserver


indent
Level2

db.username=i2b2pm


indent
Level2

db.password=demouser


indent
Level2

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


indent
Level2

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



...