Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Connectivity with database associated with JCS-SC
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
-
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
-
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
-
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
-
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
-
Thank you Vikash. Let me try REST way to work with database here.
Thanks
Sanjeev