JDBC Receiver needs to connect to different schemas in Dev and Sys Test

[mayur_patel6]

Hello Experts,

I have a Receiver JDBC adapter which is connecting to IBM DB2. Now, we have to pass the schemaname.table in the xml and i am setting the schemaname.table name in my Message Mapping via a constant. But, when we moved to the higher environment we realized that they changed the schema name on us and now for System Test we have to connect to a different schema (same table name though). Now if I change the constant in Dev and then transport, it will mess up my Dev mapping. So, I am looking for configurable parameter (in JDBC adapter) which we can set in Integration Directory to get around this issue.

One option comes to mind is value mapping. But, then I am hoping there should be an easier way to manage this.

Thank you!!!

[mayur_patel6]

Never mind ... found it

In JDBC Comm channel -> Connection -> add "currentSchema=xyz" after the url

so,

jdbc:db2://conn.conn.url.com:<port>/<database name>:currentSchema=<schemaname>;

becareful about the case

[RaghuVamseedhar]

Hi Mayur,

May be you can try [Parameterized Message Mappings|http://help.sap.com/saphelp_nwpi711/helpdata/en/43/bcc01b3fd566c2e10000000a1553f7/frameset.htm].

Regards,

Raghu_Vamsee