Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-2214

ERROR org.hibernate.util.JDBCExceptionReporter ORA-00907: missing right parenthesis on List all click

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.1.2.RELEASE
    • Fix Version/s: None
    • Component/s: PERSISTENCE
    • Labels:
      None
    • Environment:
      windows xp, oracle 10g db

      Description

      I've setup my roo project.
      I've reversed engineered one table from my database, I generated my controller
      I started my application with mvn tomcat:run
      when I click List all xxx I get an Oracle error.

      from log
      Hibernate:
      /* select
      count(o)
      from
      Spem1a o */ select
      *
      from
      ( select
      count((spem1a0_.MODE_PAIE,
      spem1a0_.NAS)) as col_0_0_
      from
      SPE.SPEM1A spem1a0_ )
      where
      rownum <= ?
      i ve included as attachment : generated source code and database table definition

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                stewarta Alan Stewart
                Reporter:
                souer1 Eric Soucy
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: