= i2b2 Gotchas RDBMS Not Transparent

Tags: [[i2b2]] [[Gotchas]]

See the above problem (!NameNotFoundException) regarding the c_db_servertype column in table CRC_DB_LOOKUP.
The implication is that this value is used somewhere to determine which RDBMS a project exists within.

The situation must be a little convoluted because the CRC_DB_LOOKUP table itself exists within a similar context, so I'm unsure of why it is there. Perhaps the system caters for having projects across a spectrum of RDBMS's (well 2: Oracle and !SqlServer), so one project could be Oracle and another project !SqlServer. This could have implications for going the MySql or PostgreSql route.

[[BackLinks]]