Forum Stats

  • 3,770,212 Users
  • 2,253,082 Discussions
  • 7,875,367 Comments

Discussions

Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?

Zex Alex
Zex Alex Member Posts: 6
edited Feb 3, 2020 2:06PM in Java Cloud Service

Hello all

It seems that JCS-SX is bound to one database schema in a multi-tenant database.

Question is, can a JCS-SX application connect to another schema in another database in the oracle cloud or is it restricted to use only that specific database schema?

The reason for this question is that we need to use JCS-SX and a database with several schemas and no pl/sql restrictions in terms of low level networking and file system access.

Thanks

Alex

Best Answer

  • oladayo.s
    oladayo.s Member Posts: 48 Red Ribbon
    edited Jan 15, 2018 1:30AM Accepted Answer

    Hello, The JCS-SX has the facade of the full fledged environment however, several limitations exists. One of which is that it can only (at the moment), connect to only one database server i.e. the one that it has been provisioned with. This was my experience as at the time i did some dev projects in the environment. You may need to perform crud operations via a web service of some sort against other databases if you need to do this.

Answers

  • oladayo.s
    oladayo.s Member Posts: 48 Red Ribbon
    edited Jan 15, 2018 1:30AM Accepted Answer

    Hello, The JCS-SX has the facade of the full fledged environment however, several limitations exists. One of which is that it can only (at the moment), connect to only one database server i.e. the one that it has been provisioned with. This was my experience as at the time i did some dev projects in the environment. You may need to perform crud operations via a web service of some sort against other databases if you need to do this.

This discussion has been closed.