how to set the default database in receiver jdbc adapter?

[Former Member]

Hi all,

Normally a database server has more than one database, and a db user could have access to also more than one database.

In the message mapping, I have to define a fully qualified table name in my xml sql message like this:

databaseName.userName.tableName

Otherwise i will get a error message

"invalide object tableName"

. That means the sql xml is system-dependent.

Is there any way to define the default database in the receiver adapter confirguration?

Regards,

Hui

[Former Member]

Hi,

Couldn't you configure the default database in the Connection string of the database connection configuration in the receiver JDBC comm chan?

In addition, the user name in the configuration of the comm chan can be set to have a default database.

The table name can also be explicitly specified in the JDBC receiver XML.

Regards,

Bill

[Former Member]

Hi william

how to set the default database for the user in the comm channel?

[Former Member]

Hi,

Setting the default database for the userid is done in the DBMS administrator, not XI. It is different for each DBMS, e.g. setting it for Oracle is different than SQLServer.

You can ask your DBA to do this, if you do not have the previlege.

Regards,

Bill