Forum Stats

  • 3,733,304 Users
  • 2,246,743 Discussions
  • 7,856,653 Comments

Discussions

Connectivity with database associated with JCS-SC

SanjeevChauhan
SanjeevChauhan Member Posts: 1,554 Gold Trophy
edited January 2018 in Java Cloud Service

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.

Best Answer

  • Vikash Mishra-Oracle
    Vikash Mishra-Oracle Member Posts: 61
    edited January 2018 Accepted Answer

    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

Answers

  • Vikash Mishra-Oracle
    Vikash Mishra-Oracle Member Posts: 61
    edited January 2018

    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
  • SanjeevChauhan
    SanjeevChauhan Member Posts: 1,554 Gold Trophy
    edited January 2018

    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 Mishra-Oracle
    Vikash Mishra-Oracle Member Posts: 61
    edited January 2018 Accepted Answer

    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
    SanjeevChauhan Member Posts: 1,554 Gold Trophy
    edited January 2018

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

    Thanks

    Sanjeev

This discussion has been closed.