Harish Amarnath Harish Amarnath - 11 months ago 61
Java Question

Exception in thread "main" org.hibernate.exception.SQLGrammarException: ORA-00926: missing VALUES keyword

kindly ignore this,,,
this post is supposed to be deleted.


The problem in the SQL is that the minus sign in the table name "COLLECTION-TABLE" is not a valid character in an unquoted identifier.

Is suspect that this:


should really be this:


If you really want a minus sign in your table name (crazy!) then you need to include the (suitably escaped) quote characters in the names. Like this for Oracle:


Reference: https://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/mapping.html#mapping-quotedidentifiers