Java API 2 (new) and MDM on DB2 database

[Former Member]

Hi !

We have created java application with connection to MDM Repository using new Java API (mdm-data.jar, mdm-protocol.jar, ....). This application was successfully tested in environment where MDM was connected to MS SQL Server.

Now we migrated to environment where MDM repository stands on DB2 (8.2) database and in this environment each call to authorize session fails with exception "MDM repository is incorrect".

Any idea / suggestions what can be wrong ?

thx, marcin

current MDM software version MDM Server / Java API is: 5.5.35.42

[Former Member]

Hi Marcin,

When creating a session, you must provide a repository identifier.

Part of the repository identifier is the DBMS type.

You must change this code in order for it to work with DB2.

RepositoryIdentifier repID = new RepositoryIdentifier(repositoryName, dbmsName, DBMSType.MS_SQL);

RepositoryIdentifier repID = new RepositoryIdentifier(repositoryName, dbmsName, DBMSType.IBM_DB2);

Ideally you should externalize this value in an xml or .properties file so that you can change it without changing your code.

Hope this helps,

Richard

[Former Member]

Richard thx for your help !