java.sql.SQLException: ORA-00923: FROM keyword not found where expected

Hibernate JIRA | Mikael Carlstedt | 9 years ago
  1. 0

    Using an ID generator of type 'sequence' in the Hibernate mapping gives an Oracle syntax error when trying to save an object: DEBUG - JDBCExceptionReporter.logExceptions(69) | could not get next sequence value [select nextval ('TEST.requests_seq')] java.sql.SQLException: ORA-00923: FROM keyword not found where expected at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)

    Hibernate JIRA | 9 years ago | Mikael Carlstedt
    java.sql.SQLException: ORA-00923: FROM keyword not found where expected
  2. 0

    Hibernate Community • View topic - could not get next sequence value

    hibernate.org | 1 year ago
    org.hibernate.exception.SQLGrammarException: could not get next sequence value
  3. 0

    Hibernate Community • View topic - newbie question

    hibernate.org | 1 year ago
    org.hibernate.exception.SQLGrammarException: could not get next sequence value
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Community • View topic - could not get next sequence value

    hibernate.org | 6 months ago
    org.hibernate.exception.SQLGrammarException: could not get next sequence value
  6. 0

    using JTA and JDBC in a servlet, IBM Websphere 5.0.2

    Google Groups | 1 decade ago | Anony
    java.sql.SQLException: ORA-00933: SQL command not properly ended

  1. rp 1 times, last 3 weeks ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-00923: FROM keyword not found where expected

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteDescribe
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
    4 frames
  5. Hibernate
    SequenceGenerator.generate
    1. org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75)
    1 frame
  6. Hibernate
    SessionImpl.saveOrUpdate
    1. org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
    2. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
    3. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
    4. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
    5. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
    6. org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
    7. org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
    8. org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
    8 frames