what are list of database schemas available in Hybris ?

[former_member1354369]

Hello Hybris Experts,

Could you please guide me how do I identify the list of Schemas available in Hybris.

Appreciate your help!

Best Regards R Venkata karthik

[arvind-kumar_avinash]

Do you mean XML schemas? Please clarify with an example.

[former_member1354369]

need data base Schemas in Hybris -- priority I Am not aware on XML Schemas. Please provide both data base and xml information.

Thank you!

[arvind-kumar_avinash · Accepted solution]

You can find XML Schema Definition by searching *.xsd files in your Hybris installation directory. Some common XSDs are items.xsd, extensioninfo.xsd etc. In an XML file, you can find the name the XML schema(s) immediately after the XML Prolog (given below)

 <?xml version="1.0" encoding="UTF-8"?>

To know about your Hybris database schema, you can follow https://support.chartio.com/knowledgebase/how-to-list-all-available-schemas

If you are using HSQLDB, you can use the following SQL:

 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

For Oracle, the SQL command is:

 SELECT USERNAME FROM SYS.ALL_USERS

[former_member1354369 · Accepted solution]

Hi Arvind,

could not open the link,

https://support.chartio.com/knowledgebase/how-to-list-all-available-schemas,

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA gives

Exception message: type code 'INFORMATION_SCHEMA.SCHEMATA' invalid

Could you help in alternative way!

Best Regards R Venkata karthik

[arvind-kumar_avinash · Accepted solution]

You have added a comma at the end of the link, please try after removing it.

Please execute the SQL command, SELECT * FROM INFORMATION_SCHEMA.SCHEMATA in the SQL tab of hAC.

Please let me know if you have any further doubt.

[arvind-kumar_avinash · Accepted solution]

Hello - I hope, the answer fulfilled your requirement. Feel free to ask for further clarifications if required.

[former_member1354369 · Accepted solution]

Hi Arvind,

We are trying to configure oracle/SQL data base to view the list of available Schemas present in our Hybris data base. Thanks for the query. still I Am not able to open the link, please see in attachment.

[arvind-kumar_avinash · Accepted solution]

There might be some firewall issue. I have attached the page at PDF. Please let me know should you face any further issue.

link text

[former_member1354369 · Accepted solution]

Hi Arvind,

Thanks for query and support,

The query is working , SELECT USERNAME FROM SYS.ALL_USERS and gives the list of userNames.

Doubt :

Are the userNames are associated/mapped/logged in with one Schema name ?

---

could you suggest here, in current project Hybris uses oracle data base, which oracle software need to install with the version supported.

Appreciate your help!

Best Regards, R Venkata karthik

[arvind-kumar_avinash · Accepted solution]

In Oracle, users and schemas are essentially the same thing.

What is the version of Hybris being used in the project? The compatible version of Oracle varied from one version of Hybris to another. Please check the database compatibility at https://help.hybris.com/1811/hcd/8c71300f866910149b40c88dfc0de431.html

Just click the highlighted dropdown to choose the version of Hybris the project is using and it will show the compatible version of Oracle.