JDBC database connection

[Former Member]

G'day XI experts,

can the JDBC database connection be same for all the Environments( for e.g. dev, test, mirror and prod)?

please advise.

thanks in advance.

[Former Member · Accepted solution]

Hi,

In general database connection differs from environment to environment.

in our case we used to change database connection parameters in environment perspective.

Thanks

Hamja

[Former Member]

Hi Experts,

thanks a lot for your responses.

[venkatanarayana_vagu]

Hi,

That depends on your landscape. If your Database guys gave you as separate database or schema. Then you can use it or you can use separate tables in the same database.

[Former Member]

Can you be more clearer wtih your Question??

It depends on how many External DB's you have.?? DEV, Test Env's pointing to same DB... ??

The Communication channel will remain the same, but obviously the connection params would change..

Good practice to have 1 CC per Database...

-Siva Maranani

[Former Member]

Hi siva,

the CC is same in all enviroment.

just wanted to confirm if the JDBC connection will be diffrent or same in 4 diffrent envirorments

hope my query is clear now

thanks.

[Former Member]

Hi,

Obviously the CC will be same for all environments but only connection parameters will change from env to env.

If your landscape is having different databases for every envrionment, accordingly the connection parameters need to be changed in your CC. In other words CC need to be changed according to your database..if your landscape is using a single database instance for all your environments then..your CC will remain same otherwise your CC need to changed according to your database instance.

Hope this is clear.

thanks

Hamja

[Former Member]

Obviously..

for Example, an SQL SErver connection string looks like...

jdbc:microsoft:sqlserver://<HOSTNAME>:1433;DatabaseName=<xxxx>;SelectMethod=cursor

YourHost name will change in each of the landscapes... your DB-name is constant...

-Siva Maranani