search

jentrata / jentrata-msh

Jentrata - Message Handler Service
jentrara.org
Other
19 stars 57 forks source link

Oracle Table : Cluster for Jentrata DB #48

Open urspraveen2001 opened 6 years ago

urspraveen2001 commented 6 years ago

Hi Team,

We are trying to test Jentrata with the Oracle DB and trying to create the schema using script "https://github.com/jentrata/jentrata-msh/blob/master/Dist/src/main/scripts/sql/oracle_ebms.sql" there was a table "Cluster" which is actually a reserved keyword in Oracle and we couldn't create a table with that. Can you please let us know how to proceed further using Jentrata with Oracle DB. We have a hard requirement to use Oracle alone.

Much appreciate your response here.

Thanks Praveen Kalagarla

aaronwalker commented 6 years ago

@urspraveen2001 have you tried putting the table name in in double quotes?

CREATE TABLE "cluster" (
    hostname varchar2(255),
    status varchar2(12),
    timestamp number,
    PRIMARY KEY (hostname)
);
kumarkshiva commented 5 years ago

All reserved words of Oracle can be seen in the Oracle view V$RESERVED_WORDS for more information: https://docs.oracle.com/cd/B28359_01/appdev.111/b31231/appb.htm#CJHIIICD

Putting the table name in double quotes is the best option if you can not change the name.