Changes between Initial Version and Version 1 of i2b2 Gotchas RDBMS Not Transparent


Ignore:
Timestamp:
12/10/15 10:15:56 (8 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Gotchas RDBMS Not Transparent

    v1 v1  
     1= i2b2 Gotchas RDBMS Not Transparent
     2
     3Tags: [[i2b2]] [[Gotchas]]
     4
     5See the above problem (!NameNotFoundException) regarding the c_db_servertype column in table CRC_DB_LOOKUP.
     6The implication is that this value is used somewhere to determine which RDBMS a project exists within.
     7
     8The 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.
     9
     10[[BackLinks]]