Java

Get Involved. Join the Conversation.

Topic

    José Alves
    Can a JCS-SX application connect to multiple databases...
    Topic posted January 12, 2018 by José Alves, last edited January 15, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Cloud, Database, PaaS 
    54 Views, 1 Comment
    Title:
    Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?
    Summary:
    Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?
    Content:

    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

    Comment

     

    • Oladayo Salawu

      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.