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 Bug
    • Status: Resolved
    • Priority: Major 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

      1. spem1a.ddl
        0.8 kB
        Eric Soucy

        Issue Links

          Activity

          Hide
          Alan Stewart added a comment -

          I noticed you have a composite primary key class but Roo does not support composite primary keys in data on demand, integration tests, and MVC as yet. You won't be able to use an MVC front-end for these classes until ROO-1999 and ROO-2070 are resolved. Please vote for them anyway.

          Show
          Alan Stewart added a comment - I noticed you have a composite primary key class but Roo does not support composite primary keys in data on demand, integration tests, and MVC as yet. You won't be able to use an MVC front-end for these classes until ROO-1999 and ROO-2070 are resolved. Please vote for them anyway.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: