Java

Get Involved. Join the Conversation.

Topic

    Sanjeevchauhan Orcl
    Connectivity with database associated with JCS-SC
    Topic posted January 20, 2018 by Sanjeevchauhan OrclBlue Ribbon: 750+ Points, last edited July 12, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Database, PaaS, Tip 
    231 Views, 4 Comments
    Title:
    Connectivity with database associated with JCS-SC
    Summary:
    Connectivity with database associated with JCS-SC
    Content:

    I know JCS-SX comes with a Database schema.

     

    Is there a possibility to connect with this database using local sqldeveloper. I would require host/port/service/username/password.

    My earlier assumption was that JCS-SX comes with preconfigured database as schema. But now in JCS-SX guide it looks like we need to provision DBCS before JCS-SX. Which means I would get db details and then I should be able to use SQL developer to connect with it. Right

     

    When we provision DBCS, we get complete database. We can create multiple schema in it. Which schema will get configured with JCS-SX.

    Is it like JCS-SX will create a new schema when we provision JCS-SX and it will use that to create a jndi connection.

     

    Thanks

    Sanjeev.

    Comment

     

    • Vikash K Mishra

      Hi Sanjeev,

      It's my pleasure to reply your Query.

        Is there a possibility to connect with this database using local sqldeveloper. I would require host/port/service/username/password. ?

      Ans: You can connect the Apex DB (Schema DB) to local sqldeveloper, but it is always connected in Read Only mode. Please refer the below on how to connect:

      Connect SQL Developer To APEX DB (Schema Service). (Doc ID 2303969.1)

      (ii) When we provision DBCS, we get complete database. We can create multiple schema in it. Which schema will get configured with JCS-SX. 

      Ans : The Apex DB (Schema Cloud service), which comes with JCS-SX is a multi tenant schema service and schema is pre-created for the customer. You can't create any more new schema within. You can create the db object using the SQL worksheet else, you can use the local db for development purpose and then export all the db object to schema service (Apex db).

      (iii) My earlier assumption was that JCS-SX comes with preconfigured database as schema. But now in JCS-SX guide it looks like we need to provision DBCS before JCS-SX.

      Ans: You are partially correct here. You need to create the Apex db (schema service) from Apex db UI, once you purchase the JCS-SX. Then you need to associate the db to the JCS-SX. You don't need to create DBCS. DBCS and Apex DB are totally different offerings.

      Regards

      Vikash Mishra

    • Sanjeevchauhan Orcl

      Hi Vikash, Thank you for information.

      I was also aware that we get database schema with JCS-SX, but then why Oracle is asking to provision DBCS as a prerequisite for JCS-SX. https://docs.oracle.com/en/cloud/paas/javase-cloud/csjsu/provisioning-database-instance.html#GUID-93E3B48E-DEFE-4F64-9D4…

      Can I assume this DBCS means database Apex Schema only not full DBCS.

      When I want sql developer connectivity my intent was to write a SQL/PLSQL script to export/import data from this database. I also want to automate that script. Ideally I would not be having sql developer in my local m/c but sql client or might be a java with jdbc. Can I do that? Alternatively I am thinking to expose database using REST services and then use them for export/import. What say? Is there any better alternative?

      Thanks

      Sanjeev

    • Vikash K Mishra

      Yes Sanjeev,

      Here DBCS refers to Schema service only. I totally agree. Using REST API is the best way to expose db. You can't write pl/sql or sql script using sql developer as it connects in read only mode.

      Regards

      Vikash Mishra

    • Sanjeevchauhan Orcl

      Thank you Vikash. Let me try REST way to work with database here.

      Thanks

      Sanjeev